Hi Karl et al,
Oh this is fun!
I've just worked out that:
1. The system does auto generate a new iietab when the data source was a
copy. I'm not so sure about inserts, I'll play with those later.
2. Any subsequent attempt to insert into the base table will succeed,
the data going to the new iietab....BUT,
The first attempt in the SESSION (not transaction) to insert will
generate the following errors in the errlog.
E_DM92BF_DM1P_TABLE_TOO_BIG Error extending table past maximum table
size of , Database *** ERslookup() ERROR: Missing or bad parameter for
this message. ***
E_DM92CB_DM1P_ERROR_INFO An error occurred while using the Space
Management Scheme on table: iietab_137_138, database: bowtest
E_DM92DC_DM1P_EXTEND Error extending a file.
E_DM92CB_DM1P_ERROR_INFO An error occurred while using the Space
Management Scheme on table: iietab_137_138, database: bowtest
E_DM92DC_DM1P_EXTEND Error extending a file.
E_DM92D0_DM1P_GETFREE Error allocating a page from free list.
E_DM9257_DM1B_FINDDATA Error occurred finding disk space for a new
record.
E_DM0138_TOO_MANY_PAGES An attempt was made to grow a file to a
size larger than a TID can handle.
Marty
-----Original Message-----
From: info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of Karl
& Betty Schendel
Sent: 07 May 2008 15:31
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] page_size on iietabs
On May 7, 2008, at 9:51 AM, Martin Bowes wrote:
> BTW. Expanding to 8k will probably buy me another year before I'm
> in this problem again ... on this column. Can I make the etab a
> partitioned table?
>
>
>
No.
But etabs are supposed to accumulate if one fills up. Obviously that
is not
working, which would be a bug.
Also, I think I recall discovering that etabs on a partitioned base
table aren't quite right -- each partition gets its own etab, but
all the blob data goes into the partitioned master's etab, which
certainly wasn't what I had in mind originally. It's been
a while since I poked around with blobs in a partitioned
table, though.
You might want to go to 16K pages, or larger, instead of 8.
Karl
_______________________________________________
Info-Ingres mailing list
Info-Ingres@[EMAIL PROTECTED]
|
