Re: Special table & tbstat -t

|> 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 ^^ These flags mean that this is a tblspace that has been dropped while the structure was still active. Why, you ask, should such a thing happen? Must you ask? Ok, first you must understand psuedo-closing. In OnLine, when you close a table, it isn't always really closed, since you may want to open it again. So we sort of keep a pointer to it around in shared memory (putting it simply). But from the user's perspective, it is closed. Now if another user comes along and drops that table, it is allowed to occur (since noone else really has it open). However, we have to deal with that psuedo-close floating around out there. So we mark the tblspace as "dead" (thus the 41 flag). A dead table has no physical address, since it has been removed from the database. But it still holds that entry in the shared memory table. at some point soon after, that entry will be removed from the shared memory table. In the meantime, any user who tries to access it (including the one who has it psuedo-closed) will be told that the table does not exist (since it really doesn't anymore). Ok? Dave |> 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 |> -----------------------------------------------------------------