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

From: Laurent REVEL <lrevel@reef.com> > > 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. So I guess we're left with Paul's idea. This sure sounds like fun... >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 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com