Re: Size of Index for given table

#1

On Sep 6, 12:05 am, Claus Samuelsen <c... (AT) dk (DOT) ibm.com> wrote:

Quote:

mohitanch... (AT) gmail (DOT) com wrote:

Is 4096 the limit on number of bitmap pages a partition can have

Yes, the maximum number of pages per fragment (partition) is 16,775,134
pages. Since one bit map page can map 4096 pages you need 4096 pages to
map 16,775,134 pages.

What's lockid in sysptnhdr mean. Is it the dbspace number to which the
fragment is attached to ?

#2

On Oct 1, 12:19 pm, mohitanch... (AT) gmail (DOT) com wrote:

Quote:

On Sep 6, 12:05 am, Claus Samuelsen <c... (AT) dk (DOT) ibm.com> wrote:

mohitanch... (AT) gmail (DOT) com wrote:

Is 4096 the limit on number of bitmap pages a partition can have

Yes, the maximum number of pages per fragment (partition) is 16,775,134
pages. Since one bit map page can map 4096 pages you need 4096 pages to
map 16,775,134 pages.

What's lockid in sysptnhdr mean. Is it the dbspace number to which the
fragment is attached to ?

It's the address of the initial fragment of the table itself (or only
fragment if the table's not fragmented). That is the address that's
locked for a table level lock.

Art S. Kagel

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Size of Index for given table

comp.databases.informix comp.databases.informix

Re: Size of Index for given table - 10-01-2007 , 12:19 PM

Re: Size of Index for given table - 10-01-2007 , 12:51 PM