HowToForums.net Forum Index HowToForums.net
An Open Source of Knowledge
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Max number of pages in a table can not exceed 16777216

 
Post new topic   Reply to topic    HowToForums.net Forum Index -> Informix
View previous topic :: View next topic  
Author Message
bozoz
HowTo Grandmaster
HowTo Grandmaster


Joined: 30 Jul 2006
Posts: 17

PostPosted: Sat Oct 28, 2006 5:02 am    Post subject: Max number of pages in a table can not exceed 16777216 Reply with quote

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    HowToForums.net Forum Index -> Informix All times are GMT
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group