Re: Informix dbexport & dbimport Problem

Oh man, you REALLY need to take my internals class in Denver, this is all covered there. It looks like someone sent you their chunk files. Do you even know what version owned that engine? If not you can guess by running the following: dd if=csdata/ifmxdata/rootdbs_dat.000 bs=2k count=1 2>/dev/null |od -c You will see something like: 0000000 \\0 020 \\0 \\0 021 313 240 I \\0 001 020 \\0 \\0 214 007 l 0000020 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 I n f o r m i x 0000040 D y n a m i c S e r v e r 0000060 C o p y r i g h t ( C ) 1 9 8 0000100 6 - 1 9 9 8 I n f o r m i x 0000120 S o f t w a r e , I n c . \\0 0000140 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 004 \\b \\0 \\0 \\0 0000160 @ 002 243 250 \\0 \\0 \\0 \\r \\0 \\0 \\0 \\0 \\0 \\0 \\0 x 0000200 9 . 4 0 \\0 \\0 \\0 027 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 Right here^^^^^^^^^^^^^ is the version number that last updated this root chunk. 0000220 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 * 0003760 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 \\0 030 \\0 t 021 313 240 I 0004000 If you do not see this output, especially if it's all zeros, then the root chunk was created with an offset and you'll have to add a skip=<npages> or increase the count=<npages> until you find that copyright page. If it's not 9.40 then you will have to get the exect version that created the server. You could try to bring it up with 9.40 anyway and the new server will try to convert the disk space to the latest version, but that's a gamble. You might also try dumping page 6 (the copyright page is page zero) which contains the paths where the server will expect to find the disk chunks and copy the files to those paths. Finally, you'll need a compatible ONCONFIG file. The onconfig parameters that were used to last startup the engine that owned those chunks is on page 1 of the root chunk. They are stored as 'PARAMETERNAME value' and each parameter/value pair is NULL terminated. The most important parameters to reset to their original settings are: ROOTNAME, ROOTPATH, ROOTOFFSET, ROOTSIZE, PHYSDBS, PHYSFILE, LOGFILES, LOGSIZE DBSERVERNAME, DBSERVERNUM, DBSERVERALIASES and most others can be configured as you would for a new server. You'll have to create appropriate sqlhosts file entries. Of course all of this assumes that these files are indeed IDS disk chunks. If not go back to the user who sent them to you. If they are and you can configure and start a new server using these files, mazel tov. You can then export the data anyway you want. Art S. Kagel ----- Original Message ----- From: Umapathi Mudigonda <mup@proclass.coas.com> At: 2/23 2:23 > Dear Friends > I am Umapathi from India > I have an problem with Informix dbexport and dbimport > I received the Database from the client > the cd contains "csapps" and "csdata" directories > in "csapps" one sub directory contains "ifmxdata" which is having > "llog_dbs1" , "rootdbs_dat.000", "tmp_dbs1" > > and the "csdata" > "ifmxdata" contains > "dat_dbs1", and "plog_dbs1" files > > all of these files does't have any extensions > > I successfully installed Informix dynamic server 9.4 > now I have to export and import the database > > would you please help me in this regard > > Advance thanks > > Umapathi Mudigonda > > ************************************************************** > Scanned by eScan Anti-Virus and Content Security Software. > Visit http://www.mwti.net for more info on eScan and MailScan. > ************************************************************** sending to informix-list