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

It doesn't work because the Datablade Install should somewhere else keep the Path to his DataBlade at the Installation Phase. So when I tried Renamming all NT Datablade directory to put UC, it gives me during the DBIMPORT. create index "informix".etxidx_lgtext on "informix".rf_f_dt_text (text_value etx_mrd_ops) using etx (char_set='OVERLAP_ISO' , word_support='PATTERN', phrase_support='MAXIMUM'); *** execute sqlobj 212 - Cannot add index. 12802 - Error in initializing an access_method routine execution sequence. -12802________________Error in initializing an access_method routine execution sequence. An access_method routine cannot be made ready to execute. For example, the external name used in the CREATE FUNCTION statement that defined the access method routine might not exist. Check that the routines used for the access method are properly defined. So, I will do my split manually, which seems more safe. "Watson, Paul" wrote: > > Change the blade NT install directory to ....UC2 ??? > > Paul Watson > WF Software Ltd > Tel: +44 1436 674729 > Fax: +44 1436 678693 > www.wfsoftware.com/informix > > > -----Original Message----- > > From: Laurent REVEL [mailto:lrevel@reef.com] > > Sent: Wednesday, August 09, 2000 03:43 > > To: Obnoxio The Clown > > Cc: informix-list@iiug.org > > Subject: Re: Migration DB from 9.2 Unix to NT with Datablade inside > > > > > > 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. > > > > > > > > > > > > Obnoxio The Clown wrote: > > > > > > From: Laurent REVEL <lrevel@reef.com> > > > > > > > > Like I need to do this kind of migration 9.20 with > > DataBlade UNIX -> NT > > > >or NT -> UNIX, we can find out that DBEXPORT/DBIMPORT can > > not do this > > > >automically. > > > >The SQL/UNL file generated always contains OS specific path like : > > > > > > > >create function "informix".sysbldlike(SYSBldSQLText,SYSBldSQLText) > > > >returns boolean > > > >external name > > > >'$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextLike)' > > > >language c; > > > > > > > >Does someone know a simplest way to do this, without splitting SQL > > > >and UNL manually ? > > > > > > And are you sure this will fail? Have you actually tried > > it? (With the > > > datablades in the same relative path, of course) > > > > > ______________________________________________________________ > > __________ > > > 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 -- ----- 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