Hi Everyone,



I've answered my own question: the Config parameter:
blob_etab_page_size.



Marty



From: Martin Bowes
Sent: 07 May 2008 14:00
To: 'Ingres and related product discussion forum'
Subject: page_size on iietabs



Hi Everyone,



I have a table with 4 long varchar columns. The table itself has only
793613 rows on 142675 pages, but one of its supporting iietabs has just
reached the magical 8.3million rows (1 row per page). And so now an
insert into the table fails as the blob table cannot be extended.



If this were an ordinary table I would simply expand the page size from
2k to 8k and buy myself some more time. But I can't seem to do that with
the iietab. I was hoping the page size would be copied from the base
table when creating the blob table but this doesn't appear to be the
case and its stuck on 2k pages.



Is there a configuration parameter, or modify option that allows me to
specify the page size on the iietabs?



Would making the base table partitioned help the iietab?



Ingres version is: II 9.0.4 (a64.lnx/105)NPTL + patch12707



Martin Bowes