IDS Forum

FW: utils2_ak Make

Posted By: LARRY SORENSEN
Date: Wednesday, 15 October 2008, at 1:26 p.m.

I am resending this message since no one has responded. Please read the text below. I have since made a change to the makefile and now instead of getting the -lgen message I get several esqlc syntax errors for listdb7.ec.

I have also tried to compile this on a Sun server and received other errors. I thought that I changed the appropriate places for Solaris, but without affect.> > 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. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Messages In This Thread

• FW: utils2_ak Make
  LARRY SORENSEN -- Wednesday, 15 October 2008, at 1:26 p.m.
  • Re: FW: utils2_ak Make
    Art Kagel -- Wednesday, 15 October 2008, at 8:44 p.m.
  • Re: FW: utils2_ak Make
    Jonathan Leffler -- Sunday, 19 October 2008, at 1:41 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.