IDS 7.22 on AIX

I'm trying to upgrade this system to IDS 7.31. There are 3 databases, and
the dbexport for 2 of them fails with a segmentation fault (I've tried it
multiple times and it fails at the same point each time - see below).
Obviously I'm not going to be able to get support, due to the aged nature of
the db server, so I'd be grateful for any suggestions of a way forward.

thx
Neil

dpackages smallint not null constraint "hpl".n152_201,
dgweight float not null constraint "hpl".n152_202,
invtwo char(14),
pickflg char(1),
dcurrency char(4),
dsetdisc float not null constraint "hpl".n152_203,
dsetdays smallint not null constraint "hpl".n152_204,
dauthby char(4),
ddelivery char(3),
dtransport smallint not null constraint "hpl".n152_205,
dcountry char(3),
dackflg char(1),
delvnoorg integer not null constraint "hpl".n152_1477
);
revoke all on "hpl".delv from "public";

create index "hpl".ixdinflg2 on "hpl".delv (dinflg,dtype,dcmpy);
create index "hpl".ixdntflg2 on "hpl".delv (dntflg,dtype,dcmpy);
create index "hpl".ixdedate on "hpl".delv (dedate);
create index "hpl".ixdtaxd on "hpl".delv (dtaxd);
create index "hpl".ixdcust on "hpl".delv (dcust);
create unique cluster index "hpl".ixdelvno on "hpl".delv (delvno);
create index "hpl".ixinvtwo on "hpl".delv (invtwo);
create index "hpl".ixdelvnoorg on "hpl".delv (delvnoorg);
Segmentation fault(coredump)

Neil Truby wrote:
> IDS 7.22 on AIX
>
> I'm trying to upgrade this system to IDS 7.31. There are 3 databases, and
> the dbexport for 2 of them fails with a segmentation fault (I've tried it
> multiple times and it fails at the same point each time - see below).
> Obviously I'm not going to be able to get support, due to the aged nature of
> the db server, so I'd be grateful for any suggestions of a way forward.

Neil, give myeport a try, see what happens. You'll also need myschema from
utils2_ak and Jonathan's sqlcmd package. Oh, and optionally Ravi Krishna's
myonpload package if you want to use the HPLOADER options to
myexport/myimport and if there was a HPLoader in 7.22 (don't remember
anymore). Also, finally, the Informix SDK, if you don't already have it, in
order to compile myschema and sqlcmd.

Art S. Kagel

> thx
> Neil
>
> dpackages smallint not null constraint "hpl".n152_201,
> dgweight float not null constraint "hpl".n152_202,
> invtwo char(14),
> pickflg char(1),
> dcurrency char(4),
> dsetdisc float not null constraint "hpl".n152_203,
> dsetdays smallint not null constraint "hpl".n152_204,
> dauthby char(4),
> ddelivery char(3),
> dtransport smallint not null constraint "hpl".n152_205,
> dcountry char(3),
> dackflg char(1),
> delvnoorg integer not null constraint "hpl".n152_1477
> );
> revoke all on "hpl".delv from "public";
>
> create index "hpl".ixdinflg2 on "hpl".delv (dinflg,dtype,dcmpy);
> create index "hpl".ixdntflg2 on "hpl".delv (dntflg,dtype,dcmpy);
> create index "hpl".ixdedate on "hpl".delv (dedate);
> create index "hpl".ixdtaxd on "hpl".delv (dtaxd);
> create index "hpl".ixdcust on "hpl".delv (dcust);
> create unique cluster index "hpl".ixdelvno on "hpl".delv (delvno);
> create index "hpl".ixinvtwo on "hpl".delv (invtwo);
> create index "hpl".ixdelvnoorg on "hpl".delv (delvnoorg);
> Segmentation fault(coredump)
>
>

Hello Neil,

> Obviously I'm not going to be able to get support, due to the aged nature of
> the db server, so I'd be grateful for any suggestions of a way forward.

i would give 'm a call. you'll never know....

in case Art's stuff does not work, i would try...

how about using dbschema and some sql like:

unload to unloadbd.sql delimiter ";"
select
" unload to "|| trim (tabname) ||".unl select * from "|| trim (tabname
)
from systables
where tabid > 99 and tabtype ='T'

-->> run unloadbd.sql

loading it in, i would set constraints and indexes all disabled.....

OR
on a different box using tcp and FET_BUF_SIZE=32000 using 7.31... (you
may get lucky here.....)
export INFORMIXSERVER=<tcp connection from 7.22> make sure the machine
and is trusted!!!!!!
from 7.22. is in sqlhost file....and run dbexport using 731. dbexport.

See you

Superboer.

Neil Truby schreef:
> IDS 7.22 on AIX
>
> I'm trying to upgrade this system to IDS 7.31. There are 3 databases, and
> the dbexport for 2 of them fails with a segmentation fault (I've tried it
> multiple times and it fails at the same point each time - see below).
> Obviously I'm not going to be able to get support, due to the aged nature of
> the db server, so I'd be grateful for any suggestions of a way forward.
>
> thx
> Neil
>
> dpackages smallint not null constraint "hpl".n152_201,
> dgweight float not null constraint "hpl".n152_202,
> invtwo char(14),
> pickflg char(1),
> dcurrency char(4),
> dsetdisc float not null constraint "hpl".n152_203,
> dsetdays smallint not null constraint "hpl".n152_204,
> dauthby char(4),
> ddelivery char(3),
> dtransport smallint not null constraint "hpl".n152_205,
> dcountry char(3),
> dackflg char(1),
> delvnoorg integer not null constraint "hpl".n152_1477
> );
> revoke all on "hpl".delv from "public";
>
> create index "hpl".ixdinflg2 on "hpl".delv (dinflg,dtype,dcmpy);
> create index "hpl".ixdntflg2 on "hpl".delv (dntflg,dtype,dcmpy);
> create index "hpl".ixdedate on "hpl".delv (dedate);
> create index "hpl".ixdtaxd on "hpl".delv (dtaxd);
> create index "hpl".ixdcust on "hpl".delv (dcust);
> create unique cluster index "hpl".ixdelvno on "hpl".delv (delvno);
> create index "hpl".ixinvtwo on "hpl".delv (invtwo);
> create index "hpl".ixdelvnoorg on "hpl".delv (delvnoorg);
> Segmentation fault(coredump)

If you have a dbexport binary from 7.31 for the OS you are migrating
you may want to try your export using that in case a defect in the
dbexport on 7.22 has been subsequently fixed.

As the jump from 7.22 to 7.31 is quite significant this may introduce
new problems but its an idea.

also does oncheck run clean? are there other indexes on the table thats
just been unloaded other than the one that are in the create tabel
statement? if so, can you drop these and remember to create them
manually afterwards?

"scottishpoet" <dryburghj@yahoo.com> wrote in message
news:1169030922.181023.143920@a75g2000cwd.googlegr oups.com...
> If you have a dbexport binary from 7.31 for the OS you are migrating
> you may want to try your export using that in case a defect in the
> dbexport on 7.22 has been subsequently fixed.

I'm trying to migrate from 7.22 on AIX 4 to 7.31 on AIX 5 on a lovely shiny
new server I've sold the customer. And I won;t get my money until it's done
;-) And the inability to export the 7.22 databases is a bad start.

> also does oncheck run clean? are there other indexes on the table thats
> just been unloaded other than the one that are in the create tabel
> statement? if so, can you drop these and remember to create them
> manually afterwards?

I don;t have a lot of room to play around, but will try to look into these
things.

cheers
Neil

"scottishpoet" <dryburghj@yahoo.com> wrote in message
news:1169030922.181023.143920@a75g2000cwd.googlegr oups.com...

>
> also does oncheck run clean? are there other indexes on the table thats
> just been unloaded other than the one that are in the create tabel
> statement? if so, can you drop these and remember to create them
> manually afterwards?


An oncheck -cD works fine.
oncheck -cI stops almost immediately:

<informix@f40>/ifx_dump2/ardenta> oncheck -cI hpldb

Validating indexes for hpldb:informix.systables...
Index tabname
Index tabid

<informix@f40>/ifx_dump2/ardenta>

If I do a dbschema of the database, then use that to create an empty
database and dbexport *that*, the dbexport completes fine, so it's clearly
data- (or maybe index-) related.

"Neil Truby" <neil.truby@ardenta.com> wrote in message
news:514v9hF1j3fb7U1@mid.individual.net...
> IDS 7.22 on AIX
>
> I'm trying to upgrade this system to IDS 7.31. There are 3 databases, and
> the dbexport for 2 of them fails with a segmentation fault (I've tried it
> multiple times and it fails at the same point each time - see below).
> Obviously I'm not going to be able to get support, due to the aged nature
> of the db server, so I'd be grateful for any suggestions of a way forward.

The simplest way to fix this involved upgrading the v7.22 instance to v7.31.
Under v7.31 the databases could be dbexported. This adds an unnecessary
extra step to my migration plan, but it is not that onerous.

As an aside, I didn;t call IBM Tech Support because of the aged version of
the instance. To their credit, UK Tech Support called me, unprompted, and
asked if they could help as the problems are being encounterd in the process
of migrating to a supported version. As it happens the workaround is
adequate, but the gesture was much appreciated anyway.