tbstat -t output's column flgs explained.

Technote (FAQ)


Question

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

Answer

Example output :

tbstat -t

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

Tblspaces

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix OnLine

Software version:

5.2

Operating system(s):

AIX, HP-UX, Linux, Solaris

Reference #:

1598584

Modified date:

2012-06-14

Translate my page

Machine Translation

Content navigation