Oninit cdi / Archive
Talk to an expert →

blobpages with data pages

Posted in 2007

Topics: Storage & Space Management

mohitanchlia@gmail.com — — source: Usenet: comp.databases.informix

Version: IDS 10 Tablespace has limit of 16.2 million pages. If blobpages are part of same dbspace as the rows then are those blobpages counted as part of same tablespace. In other words 16.2 million pages are just the row data pages or are these data pages + blob pages also. I think it's data pages + blob pages because looking at the structure of extent it contains both data pages + blob pages.

↪ replying to mohitanchlia@gmail.com
jprenaut@yahoo.com — — source: Usenet: comp.databases.informix

On Oct 7, 2:35 pm, mohitanch...@gmail.com wrote: > Version: IDS 10 > > Tablespace has limit of 16.2 million pages. If blobpages are part of > same dbspace as the rows then are those blobpages counted as part of > same tablespace. In other words 16.2 million pages are just the row > data pages or are these data pages + blob pages also. I think it's > data pages + blob pages because looking at the structure of extent it > contains both data pages + blob pages. Yes, if your blobs are stored in the tablespace then the 16.2 million pages is data + blob pages.

Glossary