Re: Size of Index for given table

Posted in 2007

Topics: High Availability & Replication, Storage & Space Management

mohitanchlia@gmail.com — Mon, 01 Oct 2007 09:19:10 -0700 — source: Usenet: comp.databases.informix

On Sep 6, 12:05 am, Claus Samuelsen <c...@dk.ibm.com> wrote: > mohitanch...@gmail.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 ?

↪ replying to mohitanchlia@gmail.com

Art S. Kagel — Mon, 01 Oct 2007 16:51:40 -0000 — source: Usenet: comp.databases.informix

On Oct 1, 12:19 pm, mohitanch...@gmail.com wrote: > On Sep 6, 12:05 am, Claus Samuelsen <c...@dk.ibm.com> wrote: > > > mohitanch...@gmail.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

Glossary

HDR
dbspace