IDS Forum

RE: DBIMPORT 2KB page to 4KB page

Posted By: LARRY SORENSEN
Date: Monday, 13 October 2008, at 5:43 p.m.

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

I am trying to make utils2_ak on a fedora 2.6.25-14.fc9.i686 box. When running `make`, I receive the following errors. Any suggestions for help:?

INFORMIXC-gcc esql -DHAVE_GNU_GETOPT=1 -o ul ul.ec -L/usr/lib -lgen
/usr/bin/ld: cannot find -lgen
collect2: ld returned 1 exit status
make:*** [ul] Error 1

Thanks> To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: DBIMPORT 2KB page to 4KB page [13681]> Date: Fri, 10 Oct 2008 17:00:08 -0400> > 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. > > > ******************************************************************************* > 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.