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
------------------------------