IDS Forum

Re: DBIMPORT 2KB page to 4KB page

Posted By: Art Kagel
Date: Friday, 10 October 2008, at 5:00 p.m.

In Response To: RE: DBIMPORT 2KB page to 4KB page (LARRY SORENSEN)

myimport is just another script in the same package if you went to the IIUG
site. It does not have to be compiled, it is just two Korn Shell scripts
that will run OK with Bash as well (though you'll have to change the first
line in each to point to Bash) if you don't want to install ksh. Install
the two scripts where ever you put executables in your PATH. To build
myschema just unpack (execute) the shell archive for utils2_ak and run
'make' on most platforms. The README.1st and BUILD files (which will list
out during the unpacking of the shell archive) explain any changes you need
for specific platforms (on RedHat you may get some warnings but otherwise is
should compile out of the box). Sqlcmd comes with instructions as does
myonpload.

Art

On Fri, Oct 10, 2008 at 11:33 AM, LARRY SORENSEN <lsorensen25@msn.com>wrote:

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

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.