SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 07:52 PM
| ||||
| ||||
 RE: Select the tablespace of the fragment containing the selected row Ave you tried ALTER FRAGMENT ON table DETACH dbspace new_table. This will move the data out from a single fragment to a new table. -----Original Message----- From: owner-informix-list@iiug.org [mailto  wner-informix-list@iiug.org]On Behalf Of Art S. Kagel Sent: Thursday, January 08, 2004 4:08 PM To: informix-list@iiug.org Subject: Re: Select the tablespace of the fragment containing the selected row On Thu, 08 Jan 2004 13:02:35 -0500, Jacob Salomon wrote: > Greetings, Family. > > I have a situation where I need to select a subset of the rows of a > fragmented table - the rows, say, DBSpace#6. If it is fragmented by > expression it's easy; just specify "WHERE <fragment condition>". Similarly, > for any row I randomly select, I can check for the condition of each > fragment in turn until I get a match. But if it is fragmented by > round-robin, how do I select the rows that reside only in the specified > DBSpace? Or if selecting by other means, how do I retrieve the name of the > row's DBSpace? > > I have the eerie feeling I have done this before but I can't recall how. > Very frustrating! > > My motivation here is to isolate some corruption that may have been cause by > a hardware glitch. I need to prove if it is table-wide or only in one > dbspace. Hi Jake, Try: o Set ONDBSPACEDOWN 0 (and restart if that's a change) o Mark all the other dbspaces down o Unload the table getting rows only from the dbspace that's still online. o Mark the dbspaces back up Or inversely, only mark the suspect dbspace down and unload. If the data's fine then by association the bad data must be coming from the suspect dbspace. Art S. Kagel > Thanks much. > > +------------ Jacob Salomon JSalomon@bn.com -- -------------- -----+ | Man > does not live by words alone, despite the fact that sometimes| | he has to > eat them. | > +------------------------------------------- Adlai Stevenson ------+ sending to informix-list      |
Linear Mode
