IBM Support

tbstat -t output's column flgs explained.

Technote (FAQ)


How to interpret value of flgs in tbstat -t output?


Example output :
tbstat -t

RSAM Version 5.20.UC3 -- On-Line -- Up 21 days 17:21:15 -- 820 Kbytes


n address flgs fucnt tblnum physaddr npages nused npdata nextns

0 1001f008 1 1 1000001 10000e 205 0 0 1

1 active, 200 total, 64 hash buckets

Tblspace 1001f008 is in use.

Here are the possible values for flags and what they mean:

0x01 partition structure in use
0x02 info has been modified
0x04 some process is dropping this partition
0x08 pseudo table partition
0x10 partition being altered (add/drop index)
0x20 partition being altered by ALTER TABLE
0x40 partition dropped with pt structs active

Document information

More support for: Informix OnLine

Software version: 5.2

Operating system(s): AIX, HP-UX, Linux, Solaris

Reference #: 1598584

Modified date: 04 May 2017

Translate this page: