Re: ONLOAD : How to specify first & next extent sizes

In article <6ev2jd$n1m$1@news.xmission.com>, ssoman@omm.com writes > > >Hi all, > In my efforts to de-fragment my biggest tables, I have come up with a >problem. I "onunload" - ed my table to tape, created new dbspaces to hold the >new table. The next step therefore is to drop my old table, and "onload" the >table back into the new dbspaces. But, HOW do I specify the first and next >extent sizes, since onload creates the table as opposed to loading the data into >a created table ? I do not see a parameter for first and next extent sizes on >the "onload" syntax, so how then does "onload" work ? Also, how can I specify I would guess it creates an initial extent of 16 pages and keeps adding extents as needed an doubling every 16 extents. Remember adjacent extents are joined into one extent. Hence it should not be a problem unless Online cannot allocate enough continous pages. Once it is loaded you can set the next entent size. >multiple dbspaces for "onload" to load data ?? I doubt so.. > Secondly, how do I verify that my "onunload" is good ? I have taken an You cannot. >ontape level 0 backup also. Is there any other backup method that I should use, >incase onunload fails ?? My table is quite large - about 8 Gig. Not really , you might want to go to iiug.org and look under Software, Special Software for archecker which will MAY you to validiate your level 0 archive. I belive this only works on certain platforms... >Thanks for the help > >Sujata >***************************************** > Sujata Soman > > > E-Mail: ssoman@omm.com > > O'Melveny & Myers, Los Angeles > >****************************************** > > > > > > > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care