Re: Migration DB from 9.2 Unix to NT with Datablade inside
I can only say one thing: AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGH!!!!!!!!!!!!!!! And offer my condolences. From: Laurent REVEL <lrevel@reef.com> > > 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 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com