Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Usenet: comp.databases.informix
On Sun, 14 Mar 2004 23:30:38 -0500, Peter Harris wrote:
If the table is fragmented or the index is either detached or fragmented:
select dbspace from sysfragments where index_name = 'myindexname';
If the index is attached to a non-fragmented table:
select dbinfo('dbspace', partnum)
from systables
where tabname = 'mytablename';
It is left for the reader as an exercise ;-) if one knows the indexname but
not what non-fragmented table it belongs to.
Art S. Kagel
> Dear all,
>
> I am running Informix 7.31 UDF4 on solaris 8. Given an index name, is there
> a way of finding out which dbspace it is physically residing in?
>
> //Pete
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.