HowToForums.net

[bozoz]

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


some reference URLs for the intrigued:


http://groups.google.com/group/comp.databases.informix/browse_thread/thread/ea3b9a02372f30ac/a00d65fe9cf7dc82?lnk=st&q=informix+table+fragment&rnum=1&hl=en#a00d65fe9cf7dc82

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls64.htm

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls64.htm

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0610gupte/

http://www.iiug.org/forums/informix-forum/index.cgi/noframes/read/54