dbexport core dumps
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 machineand 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?