Re: How to get dbspace for a t
Reply to item 1665203 from INFORMIX-LIS sent on 94/10/30 11:02
>I am trying to get th dbspace which a table is resident to.
>Does anyone know how to do this? (either through systable lookup
>or through an Informix utility?
><Using Informix version 4.10>
>Thanks in advance,
>Bill
database databasename;
select tabname, hex(partnum) from systables;
output should be:
tabname Hex(partnum)
table1 0x08000002
table2 0x0A000001
:
:
This means that table1 resides in dbspace # 8 and table2 resides in dbspace
#10. Now cross-reference this with the output of 'tbstat -d' under the Dbspaces
header. Match dbspace number 8 ( under number column) with its associated name
(under name column).
##############################################################
David Nguyen Internet: davidn@geis.geis.com
GE Information Services UUCP: uunet!ge!davidn
401 North Washington Street Voice: 1-301-340-5461
Rockville, MD 20850 USA
##############################################################