Special table & tbstat -t

Posted in 1993

Poul Pedersen — 2 Apr 93 14:39:22 DST (Fri) — source: Informix-list mailing list archive (1991-1998)

Special table or what ??? (ONLINE V. 5.00.UC2 ) ========================= (DG/UX 5.4.2 AViiON mc88100) tbstat -t gave me this output: RSAM Version 5.00.UC2 -- On-Line -- Up 06:06:21 -- 27088 Kbytes Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns 0 80948e00 1 1 1000001 10000e 2505 8 0 0 1 1 80948f20 1 1 2000001 200004 8063 49 0 0 1 2 80949040 1 1 3000001 500004 2505 2 0 0 1 3 80949160 1 1 2000003 200006 24 20 11 402 3 5 809493a0 41 1 200002c 0 312 308 151 7240 4 7 809495e0 1 3 2000002 200005 16 9 4 58 2 12 80949b80 1 1 2000004 200007 8 8 3 58 1 7 active, 5120 total, 2048 hash buckets Why and when is the physaddr 0 for a table ? Second flgs is 41 why ? I have not been able to find any documentation on these. Can you help me ? Thanks from ----------------------------------------------------------------- Databaseadministrator Poul Pedersen Kuwait Petroleum (Danmark) A/S Hummeltoftevej 49 Mail: pp@q8.dk 2830 Virum Voice: +45 45 98 45 94 Denmark Fax: +45 42 85 14 18 -----------------------------------------------------------------