Posted: Sat Oct 28, 2006 5:02 am Post subject: Max number of pages in a table can not exceed 16777216
Informix has a limitation that does not let it assign more than 16777216
pages to a table that has a single fragment...
theoretically, fragmenting would solve this problem, however if you table
has reached 16 million pages, you probably don't have time to
re-fragment the table... so that is out of the question...
deleting rows from the table does not solve the problem either even in
IDS10...
so what you have to do is create a new dbspace with default page size
larger than the pagesize of the table with 16 million rows. Then copy the
table over from it's original location into the new dbspace.
for example if the table had 16 million 2KB pages, then it will only need 4
million 8KB pages... it's the fastest solution as informix was copying 55000
rows per second with row size being 380 bytes... That's right, 55 thousand
rows per second...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum