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

Here is the detail on what I tried this morning and yesterday after Paul gave the idea to rename NT Directory : FROM NT : IDS.2000 with ETX.1.30.TC3 + TXT.1.10.TC4 and I would like to migrate one Database TO UNIX Box : IDS.2000 with ETX.1.30.UC2 + TXT.1.10.UC4 Steps followed : 1-Rename D:\\informix\\extent\\ETX.1.30.TC3 and D:\\informix\\extent\\TXT.1.10.TC4 on the NT 2-Create a NEWDB 3-Register Datablade in the NEWDB 4-DBEXPORT for NT 5-Transfer NEWDB.EXP to UNIX 6-Change SBSPACE Name inside the NEWDB.SQL 6-DBIMPORT NEWDB -l buffered. Now it doesn't fail with the Error mentionned yesterday : -12802________________Error in initializing an access_method routine [My mistake was to replace ETX.1.30.TC3 to ETX.1.30.UC3 and this directory doesn't exist on my Unix but ETX.1.30.UC2 ] BUT It always HANGS during the first statement CREATE INDEX ETX. DBIMPORT hangs but ONSTAT -G SES shows the Build statement : onstat -g ses 37 Informix Dynamic Server 2000 Version 9.20.UC2 -- On-Line -- Up 00:36:32 -- 64512 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 37 informix 2 29889 loadtest 1 184320 176952 tid name rstcb flags curstk status 53 sqlexec b7d3718 --BP--- 12848 b7d3718 running Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag Changing data structure forced command termination. Perhaps I miss something ( but I don't know what ) IT SHOULD BE THE DIFFERENCE OF VERSION of the ETX Blade NT <-> UNIX, I m going to search if one of my UNIX Server owns an ETX.1.30.UC3. I perhaps WILL LOG a Case to the Technical Support but like I work since two years on the 9.1, I never heard about a INFORMIX Blade Migration Tool. Obnoxio The Clown wrote: > > From: "Watson, Paul" <Paul.Watson@aggregate.com> > > > > > 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. > > > >Hang on, you are saying if you copy the datablade to disk and then > >rename the directory, and then do the install the datablade knows it's > >orginal directory name? > > The datablade seems to always install to a directory name which has a > companent of its name set, so if you install the blade in > d:\\pwatson\\is\\a\\twat, it would create d:\\pwatson\\is\\a\\twat\\ETX.1.30.TC3 ... > :0) > > > > >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 > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hot