Re: backup informix with different machine and....

Wahyu Cahyadi wrote: > Art S. Kagel (Oninit) wrote: >> Wahyu Cahyadi wrote: >>> Hi all, >>> I have database production using Informix Dynamic Server Version >>> 9.40 FC5 on HP Itanium rx4640 machine with HP-UX operating system >>> And I have IBM x3400 machine using IDS 9.40 for backup informix >>> database server with Linux Centos 5.1. I have run dbexport on >>> production server (hp rx4640), then dbimport it to backup server >>> (ibm x3400). it was takes 7 hours for dbimport, the total size of >>> dbexport is 16 GB My questions: 1. Why it takes long time for dbimport? >>> >> >> That does seem a bit slow. I think it works out to about 40MB/min. >> >>> 2. Does it possible if I run ontape -s on production server, then >>> restore it (ontape -r) on backup server? >>> >> >> No. >> >>> 3. Please give advice what the best should I do to backup informix >>> database from rx4640 to ibmx3400 with different OS >>> >> >> You can try my dbexport/dbimport replacement utility, myexport, which >> can use the HPLoader and parallel loading to get the job done faster. >> To use myexport/myimport you will also need the following packages >> from the IIUG Software Repository: my utils2_ak (for myschema), >> Jonathan Leffler's sqlcmd (the latest), and Ravi Krishna's myonpload >> utility. >> >>> thanks in advance >>> >>> > thanks Art, > I want to use myexport/myimport for backup and restore my production > server to backup server > I have downloaded myexport.shr.gz, utils2_ak.gz, myonpload_2.1.zip, > sqlcmd-85.00.tgz from www.iiug.org > first I extract sqlcmd-85-00.tgz, then I run ./configure, and I get > error message: > configure: error: Could not find a valid ESQL/C compiler > where do I get ESQL/C compiler for linux? > > Can you give me step by step how to install all > software(myexport,utils2_ak,myonpload and sqlcmd) in my linux? > I have searched on uncle google, but until now I couldn't find any > help for install myexoprt/myimport > > --- > http://veryeasytutorial.blogspot.com > I success install myexport,utils2_ak,myonpload and sqlcmd first download myexport.shr.gz, utils2_ak.gz, myonpload_2.1.zip, sqlcmd-85.00.tgz from www.iiug.org before install all those software above , dont forget install clientsdk for esql/c compiler sqlcmd: - extract sqlcmd-85.00.tgz: $ tar zxvf sqlcmd-85.00.tgz- change direktori to sqlcmd-85.00 $ cd sqlcmd-85.00 - run: $ CC="gcc -m64m" ./configure $ make # make install ( make install using root ) myonpload: - extract myonpload_2.1.zip $ unzip myonpload_2.1.zip- compile myonpload.ec $ esql -o myonpload myonpload.ec utils2_ak: - extract utils2_ak.gz $ gunzip extract utils2_ak.gz - Unpack utils2_ak $ sh utils2_ak - run make $ make myexport: - extract myexport.shr.gz $ gunzip myexport.shr.gz- Unpack myexport.shr $ sh myexport.shr- Give execute permission for myexport and myimport file # chmod +x myexport # chmod +x myimport Then, run export PATH for utils2_ak, myonpload and myexport in your informix environment Thanks Art, I am running myexport right now, I hope it will work, and then I hope I can run myimport faster then dbimport -- http://veryeasytutorial.blogspot.com