Select the tablespace of the fragment containing the selected row

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. 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 ------+