Attaching Informix.dat and .idx Files

Question

We are trying to duplicate one of our informix databases on a test server, but without Informix experience at home, we can only guess what we need to do. I study this material on the fly myself and nowhere near the level of knowledge necessary for Informix to work effectively or even inefficiently. One way or another ... We managed to copy the .dat and .idx files from a live server. Installed Linux and the latest Informix Dynamic Server on it and its launch and launch.

Now what do we do with the .dat and idx files from the live server? Will we copy it somewhere and it will automatically recognize it?

Or is there an equivalent way, how can you connect a DB from MS SQLServer to register database files in a new database?

At the end of my rope ...

Answer 1

, . Informix , , , . , dbspace,.dat .idx . , , , . , , .dat .idx , . Dbspaces , , . , .dat .idx dbspace.

, , PARISC, Itanium x86/x64, .

• dbspaces, , onunload onload .
• ontape onbar .

1 , , dbspaces . onstat -d , . BTW, , onstat -d, , , Linux - 2K-.

2 , . , ROOTDBS . , onstat -c | grep ROOTDBS

, , , .

Answer 2

.dat .idx C-ISAM , dbase.dbs( dbase - ), .dat .idx Informix , Informix SE. SE C-ISAM . SE ( ) Informix Dynamic Server (IDS). , .dat .idx IDS; .

, SE. SE IDS, , , DB-Export SE DB-Import Linux/IDS. , .

- Datablade C-ISAM , , , . , HPL ( ).

Informix -, (http://www.informix.com - Informix IBM -), - International Informix User Group (IIUG). ( , ) Informix.

Answer 3

Informix-SE datafiles (.DAT) (.IDX) , , SYSTABLES.DAT SYSTABLES.IDX, SYSCOLUMNS, SYSINDEXES ..

, Informix-SE , node 2K 4K.

- .DAT .IDX db, , , .

, "dbexport", ascii "dbschema" . "bcheck" , ascii.

Answer 4

, Informix, , , ( ), , .

Also, be careful with problems caused by various system architectures; some DBs look spectacular if you move them from a large number of systems (like Solaris) to a little-endian system (like x86 Linux). In addition, the manual section for moving the database will cover any additional steps that are necessary.