Re: Migration DB from 9.2 Unix to NT with Datablade inside

It can not be done : Unregister module ETX.1.30.TC3 out of database test1? [Y/n]Y blademgr: ERROR: DataBlade ETX.1.30.TC3 could not be unregistered from database test1. Use 'show last log' for details of failures in module's scripts. ol_lrevel>show last log blade: ETX.1.30.TC3 err expct: unexpected SQL stmt: drop opclass etx_mrd_ops restrict; SQL state: XIX000:-9872 : Cannot drop operator class (informix.etx_mrd_ops): still in use. And it 's normal because I 've got ETX Index based on the Datablade. So I think there 's only one way : split manually files to remove ETX function and TXT and all Datablade statements. Obnoxio The Clown wrote: > > OK, how about you unregister the DataBlades, dbexport, dbimport and then > register the 'blades on NT? > > From: Laurent REVEL <lrevel@reef.com> > > > > Yes I can do it : the substitution of ETX.1.30.UC5 to ETX.1.30.TC5 in > >UNL. > >But I discovered later that sometimes the DataBlade References are not > >only TXT.1.10.UC4 but could be : > > > >---- sysbl00106.unl file ----- > >ifxrltree1|ifxrltree.2.00| > >ILLD1|LLD.1.20.UC2| > >ILLD2|LLD.1.20.UC2| > >ITXT2|TXT.1.10.UC4| > >ITXT1|TXT.1.10.UC4| > >ITXT110UC4|TXT.1.10.UC4| <<< So I have to substitute also TXT110UC4 to > >TXT110TC4 > > > >But I could miss something else, and I m sure it is not a INFORMIX > >Supported > >Migration Procedure. > > > > > > > >Obnoxio The Clown wrote: > > > > > > From: Laurent REVEL <lrevel@reef.com> > > > > > > > > Sorry I did a mistake with my example : > > > >here is the kind of things whichs 'fails' > > > >( I want to say : DATABLADE won't be recognize by the Engine ) > > > > > > > >create function "informix".etx_begin_scan(pointer) > > > >returns integer > > > >with > > > >( not variant ) > > > >external name > >"$INFORMIXDIR/extend/ETX.1.30.UC2/ETX.bld(etx_begin_scan)" > > > >language c; > > > > > > > >And for NT IDS.2000 it should be : > > > > > > > >external name > >"$INFORMIXDIR/extend/ETX.1.30.TC2/ETX.bld(etx_begin_scan)" > > > > > > > >I Tried to make a Shell Script to substitute 1.30.UC2 with 1.30.TC2 > > > >but inside UNL files there is also Datablade References. > > > > > > Agh! Can't you mangle the .UNL files as well? > > > ________________________________________________________________________ > > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > >-- > >----- REVEL Laurent / DBA Engineer ----- > >REEF - 116, rue du Faubourg St Martin - 75010 PARIS > >Office Tel: 33 (0)1-55-26-53-53 and ask : 5404 > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- ----- REVEL Laurent / DBA Engineer ----- REEF - 116, rue du Faubourg St Martin - 75010 PARIS Office Tel: 33 (0)1-55-26-53-53 and ask : 5404