Very Computer

by **Lee, Boon-Che** » Wed, 08 Sep 1999 04:00:00

Hi All,

Wonder is there any way we can get rid of overflow pages in an ISAM storage
structure table? Even an empty isam table contains 1 overflow page. See
below. For the rest of isam table, there are at least 1 overflow page.

TIA.

Regards,
Lee Boon Cheow
MobileOne, Singapore

1> help table
isamtmp

Name: isamtmp
Owner: dba_cabsprod
Created: 06-sep-1999 11:13:00
Location: gsmdb_loc0
Type: user table
Version: ING6.0
Row width: 215
Number of rows: 0 <-- no rows
Storage structure: isam
Compression: none
Duplicate Rows: allowed
Number of pages: 2
Overflow data pages: 1 <-- but 1 overflow pg - ie
unavoidable !
Journaling: disabled
Base table for view: no
Permissions: none
Integrities: none

by **Lee, Boon-Che** » Wed, 08 Sep 1999 04:00:00

Thanks for your reply. Even with a much lower fillfactor than the default,
it still contains at least one overflow page. The wonder is, how to get rid
of that one page overflow for a isam table?

> ----------

> Sent: Tuesday, September 07, 1999 2:57 PM
> To: Lee, Boon-Cheow
> Subject: RE: How to get rid of overflow pages in an ISAM table?

> Hi,
> Take a look at fill factor. You could modify the table using a lower
> fill factor, as far as I can recollect the default fill factor is 80 %,
> you could try with a lower percentage, but then the total number of pages
> will increase. You would need to take a look at the SQL and DBA manuals.
> HTH
> Raju

> "Luck is what happens when preparation meets opportunity." --- Coach
> Darell Royal

> -----Original Message-----

> Sent: Tuesday, September 07, 1999 11:52 AM
> To: 'info-ingres'
> Subject: How to get rid of overflow pages in an ISAM table?

> Hi All,

> Wonder is there any way we can get rid of overflow pages in an ISAM
> storage structure table? Even an empty isam table contains 1 overflow
> page. See below. For the rest of isam table, there are at least 1 overflow
> page.

> TIA.

> Regards,
> Lee Boon Cheow
> MobileOne, Singapore

> 1> help table
> isamtmp

> Name: isamtmp
> Owner: dba_cabsprod
> Created: 06-sep-1999 11:13:00
> Location: gsmdb_loc0
> Type: user table
> Version: ING6.0
> Row width: 215
> Number of rows: 0 <-- no rows
> Storage structure: isam
> Compression: none
> Duplicate Rows: allowed
> Number of pages: 2
> Overflow data pages: 1 <-- but 1 overflow
> pg - ie unavoidable !
> Journaling: disabled
> Base table for view: no
> Permissions: none
> Integrities: none

by **Karl & Betty Schend** » Wed, 08 Sep 1999 04:00:00

Quote:>Hi All,

>Wonder is there any way we can get rid of overflow pages in an ISAM storage structure table? Even an empty isam table contains 1 overflow page. See below. For the rest of isam table, there are at least 1 overflow page.

I think you get the overflow page if you define the table without specifying UNIQUE keys.
I confess to not having worried about this very much, and I'd suggest that you not worry about it
too much either. One overflow page is not going to hurt anything. :)

Karl R. Schendel, Jr.

Ingres and Unix Expertise

Past President, North American Ingres Users Association