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:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.