IDS Forum

RE: DBIMPORT 2KB page to 4KB page

Posted By: LARRY SORENSEN
Date: Friday, 10 October 2008, at 11:33 a.m.

In Response To: Re: DBIMPORT 2KB page to 4KB page (Art Kagel)

I found myexport, but I can't find myimport. Also, do the infos have step-by-step instructions for installation/compile?> To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: DBIMPORT 2KB page to 4KB page [13671]> Date: Fri, 10 Oct 2008 08:40:24 -0400> > Robert: > > 3) Use my dbexport/dbimport replacement utility myexport. It uses sqlcmd's > sqlunload and sqlreload to handle the data (by default) which does not have > the 2GB file size limit so you can output the export to disk instead of tape > allowing you to edit the schema to fiix the extents before reloading it into > the new server. The resulting export is completely compatible with dbimport > so you can a) use dbimport to build the new database, b) use myimport to > perform the import faster using the parallel load option, c) use myimport to > perform the import REALLY fast by having it use the HPLoader during the > load. > > The myexport package is available for download from the Oninit web site ( > www.oninit.com/utils) or the IIUG Software Repository (www.iiug.org/software). > It also required my utils2_ak package, Jonathan Leffler's sqlcmd package, > and Ravi Krishna's myonpload package (if you want to use the HPLoader > options). Note that since myexport uses my dbschema replacement utility, > myschema, to generate the dbimport compatible schema file, it automatically > exports as if -ss were included and automatically calculates optimal extent > sizes in the schema file. By default these are entered as recommendations > in comments, but you can easily edit the myexport script to include the > myschema options (-a, -m, -n, & -e) that control that calculation and > whether to use the calculated values in the CREATE TABLE statement or just > comment on the recommended values. I'd also recommend using the myexport -u > option since the most recent dbexport versions include the UPDATE STATISTICS > statements that this option generates (if you use dbimport to create the > database you'll have to run the update stats script manually afterwards or > append it to the main schema before the reload run - dbimport takes care of > that for you). > > Art > > On Fri, Oct 10, 2008 at 6:19 AM, ROBERT CLOW <robert@clow.biz> wrote: > > > Before I re-invent the wheel... ;-) > > > > 7.31 (32 bit) 2 KB page size on redhat going to a nice new IDS 10 (64 bit) > > on > > aix. > > > > - db2export to tape... (2GB limits and all that mutter mutter mutter) > > - dbexport -ss to ensure the same dbspace layout > > - dbimport is aborting with minimum extent size 16... (I have some 8's ;-) > > > > Tried dbimport -c but still aborts - Could edit the 'tape' file but then > > the > > fixed length would be wrong... > > > > Is there a flag to tell dbimport to simply ignore or overwrite the inital / > > next extents 8 (Or does Alter table in 7.31 allow me to alter the initial > > as > > well (as it does the next extent?) > > > > Otherwise the options I see are: > > 1) Not use -ss and move the indexes after the dbimport > > 2) Use unload / load or sql to move the data after using dbschema to create > > the desire table/index layout... > > > > Ideas? > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any entity > with which I am affiliated nor those of the entities themselves. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Messages In This Thread

• DBIMPORT 2KB page to 4KB page
  ROBERT CLOW -- Friday, 10 October 2008, at 6:19 a.m.
  • Re: DBIMPORT 2KB page to 4KB page
    Keith Simmons -- Friday, 10 October 2008, at 6:42 a.m.
  • Re: DBIMPORT 2KB page to 4KB page
    Art Kagel -- Friday, 10 October 2008, at 8:40 a.m.
    • RE: DBIMPORT 2KB page to 4KB page
      LARRY SORENSEN -- Friday, 10 October 2008, at 11:33 a.m.
      • Re: DBIMPORT 2KB page to 4KB page
        Art Kagel -- Friday, 10 October 2008, at 5:00 p.m.
        • Re: DBIMPORT 2KB page to 4KB page
          ROBERT CLOW -- Friday, 10 October 2008, at 5:42 p.m.
        • RE: DBIMPORT 2KB page to 4KB page
          LARRY SORENSEN -- Monday, 13 October 2008, at 5:43 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.