Hello,
just have a look at the limits for a table fragment regarding the number of records and the number of pages.
If one of these limits hit, then you hace to fragment or partition the table.
Here a script to check:
{#####################################################################
### Check limit for rows and pages ###################################
#################################### gerd.kaluzinski@de.ibm.com ######
#####################################################################}
database sysmaster;
set isolation to dirty read;
select first 5
n.tabname[1,20], dbsname[1,8] as db,
4277659295 - h.nrows as rows_left,
h.nrows,
(round(100 * (4277659295 - h.nrows)/4277659295,2))::char(3) as prc_left
from sysptnhdr h, systabnames n
where h.partnum = n.partnum
and n.tabname[1] != ' '
and h.flags != -2147481599
order by 3
;
select first 5
n.tabname[1,24], dbsname[1,12] as db,
16777215 - h.nptotal as pages_left,
h.nptotal,
(round(100 * (16777215 - h.nptotal)/16777215,2))::char(3) as prc_left
from sysptnhdr h, systabnames n
where h.partnum = n.partnum
and n.tabname[1] != ' '
and h.flags != -2147481599
order by 3
;
------------------------------
Gerd Kaluzinski
------------------------------
Original Message:
Sent: Wed March 03, 2021 02:23 PM
From: AMIT PATEL
Subject: Number of extents
Dears,
We got issue for number of chunks exceed. Is this Informix bug or Informix can not read extent if over 200 extents?
if we move the table in other dbspace where dbspace has much space left, will solve the problem without changing the table data and schema?
Error Could not insert new row into the table. :ISAM[-136]
Message Log:
03/01/21 03:36:46 WARNING: partition 'oltp:informix.cs_ptrg_trns': no more pages
Cause:
table "cs_ptrg_trns" is big size and cannot auto pages allocation due to number of extents exceed limitation at 200.
Kindly revert.
Thanks
Amit Patel
------------------------------
AMIT PATEL
------------------------------
#Informix