Re:tables in dbspaces

Posted in 1999

samir BADAOUI — Mon, 19 Jul 1999 08:44:49 PDT — source: Informix-list mailing list archive (1991-1998)

Think you Vijaya, I think that your query works. please can you explain to me the relation between systables.partnum and dsysmaster:sysdbspaces.dbnum ? (why this 1048576) or say me where can I find documentation about this Thinks ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to samir BADAOUI

Art S. Kagel — Mon, 19 Jul 1999 14:29:51 -0400 — source: Informix-list mailing list archive (1991-1998)

samir BADAOUI wrote: > > Think you Vijaya, I think that your query works. > please can you explain to me the relation between systables.partnum > and dsysmaster:sysdbspaces.dbnum ? (why this 1048576) or say me where can I > find documentation about this The partnum is the logical page number of the table's TABLESPACE TABLESPACE entry, in other words the table's internal header record. The high order 12 bits (3 nibbles or hex digits) represent the dbspace number for a logical page number. The remainder of the address is the page number. Dividing by 1048576, or 0x100000, shifts off the page number leaving just the dbspace number behind. Art S. Kagel

Glossary

dbspace