Re: How to get dbspace for a table???

jlumbley@netcom.com (Joe Lumbley) writes: >Bill, > The other way is to look at the tbstat -t output. First, you have >to be sure that your table is in use. Secondly, you need to know how to >identify the table. This can be done by SELECT hex(partnum) from systables >where tabname="YOURTABLENAME". This hex(partnum) corresponds to the physical >address in the tbstat -t output. The first digit of physical address or >tblnum in this output then corresponds to the dbspace number from the tbstat -d >output. (See, I told you the tbcheck -pe was easiest :) You don't need tbstat -t output. Nor does your table have to be in use. Select hex(partnum) from systables where tabname="whatever"; You'll get a hex value like 0x02000245 ^^---------dbspace number is first 2 digits From this, you can determine that the table is in dbspace 2. partnum (or tblspace num) is a constant that doesn't change whether the table is currently in use of not. ---------------------------------------------------------------------------- Bill Glidden Sr. Advanced Support Engineer E-mail: glidden@informix.com Advanced Support (415) 926-6904 Informix Software, Inc. ----------------------------------------------------------------------------