IDS Forum

Re: Upgrade question

Posted By: Art Kagel
Date: Tuesday, 15 July 2008, at 4:15 p.m.

In Response To: RE: Upgrade question (Tim Ertl)

Sounds like you don't have, or at least are not using, GNU Make. The
makefile has to be edited to work with std UNIX make. On line 71 or so
there's a conditional block like:

ifeq ($(ESQL),c4gl)

cpp -DC4GL_720_COMPILER=1 $? >$@_4gl.ec

INFORMIXC=$(INFORMIXC) $(ESQL) $(ECFLAGS) -o $@ $@_4gl.ec

rm $@_4gl.ec
else

INFORMIXC=$(INFORMIXC) $(ESQL) $(ECFLAGS) -o $@ $?
endif

Just remove everything except the line immediately above the endif (or use
GNU Make). You'll have to edit the myschema makefile also and make the same
change there. That's the file myschema.mk.norcs in the myschema.d
subdirectory.

Oh, unless the update went in today (I uploaded it a week ago but it wasn't
there as of yesterday), the copy you have may have a compile time bug in the
file myschema.d/print_procedures.ec. Updated version is attached, just
replace the one you have with this new one.

Art

On Tue, Jul 15, 2008 at 4:04 PM, Tim Ertl <tim@lmrgroup.com> wrote:

> Art, wow! the myexport stuff lead me into its requirements that are a whole
> bunch of neat Informix programs. Great stuff! We should have had a session
> at the IIUG about non-IBM user utilities!
>
> In anycase the utils2_ak had an issue I do not see a fix for in the
> Makefile.
> make: Fatal error in reader: Makefile, line 72: Unexpected end of line seen
>
> If you have any quick thoughts on this problem I welcome the help.
>
> ,,,Thanks,,,
>
> Tim Ertl
> 413-442-9000 x6211
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Tuesday, July 15, 2008 10:03 AM
> To: ids@iiug.org
> Subject: Re: Upgrade question [12703]
>
> Get my dbexport/dbimport replacement utility, myexport. It can use the
> HPLoader to export and import your data and it can do all tables in
> parallel
>
> for maximum throughput. To use myexport you will also need my utils2_ak
> package for my dbschema replacement utility myschema, Jonathan Leffler's
> sqlcmd utility (which myexport/myimport uses by default for moving data),
> and Ravi Krishna's myonpload utility that lets myexport/myimport run the
> HPLoader from the commandline.
>
> For fastest loading use the -p (parallel), -C (HPLoader), and -m (create
> indexes and constraints after the load) options for myexport and -p, -H D
> (HPLoader in deluxe mode), and -m for myimport. Myimport can also create
> the database and load the tables into different dbspaces than they were
> exported from using the -T <mapfile> option. See the README.1st file and
> the sample mapping files in the package.
>
> Art
>
> On Tue, Jul 15, 2008 at 9:05 AM, Tim Ertl <tim@lmrgroup.com> wrote:
>
> > Hi Sebastian, I am leaving Sun Enterprise 250 (32 bit Sparc) Solaris 8
> > informix 9.30, going to Sun T5120 (64 bit Sparc) Solaris 10 Informix
> > 11.10 and more disk drives to spread out the I/O!.
> >
> > The migration guide suggest dbexport/dbimport but I wonder if there is a
> > better way.
> >
> > Thanks for your time...
> >
> > ,,,Tim
> >
> > Tim Ertl
> > 413-442-9000 x6211
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > 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

• Upgrade question
  Tim Ertl -- Monday, 14 July 2008, at 6:52 p.m.
  • Re: Upgrade question
    Sebastian, Norma J. -- Monday, 14 July 2008, at 7:00 p.m.
  • RE: Upgrade question
    Sebastian, Norma J. -- Monday, 14 July 2008, at 7:07 p.m.
    • Re: Upgrade question
      Tim Ertl -- Tuesday, 15 July 2008, at 9:05 a.m.
      • Re: Upgrade question
        Art Kagel -- Tuesday, 15 July 2008, at 10:02 a.m.
        • RE: Upgrade question
          Tim Ertl -- Tuesday, 15 July 2008, at 4:04 p.m.
          • Re: Upgrade question
            Art Kagel -- Tuesday, 15 July 2008, at 4:15 p.m.
      • RE: Upgrade question
        Sebastian, Norma J. -- Tuesday, 15 July 2008, at 4:05 p.m.
        • RE: Upgrade question
          Tim Ertl -- Tuesday, 15 July 2008, at 4:18 p.m.
          • RE: Upgrade question
            Sebastian, Norma J. -- Tuesday, 15 July 2008, at 6:56 p.m.
  • Re: Upgrade question
    Art Kagel -- Monday, 14 July 2008, at 7:57 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.