Re: INFORMIX-SE 4.11,UC1 how to connect?

ph wrote: >> And you should not be attempting to get it with SE 4.11; it was obsolete >> circa 1995, arguably longer ago than that. >> >> You've got a fight on our hands, even if everything is favourable. >> >> Do you have I-Net on your Unix machine where SE 4.11 is running? What >> o/s is running there? >> >> If not, I suggest upgrading to SE 7.2x immediately. >> >> If so, then you *may* be able to get ODBC to talk to SE by running >> $INFORMIXDIR/lib/sqlexecd (and the presence or absence of that >> executable may be your only way to tell if you have I-Net installed) on >> the machine. You'll have to dig up the notes on how to configure I-Net >> 4.11; the sqlhosts file is different from the version 5.x and more >> recent versions. I probably do have the manual at the office, but it >> will take some digging out (if you'd seen my office, you'd know what I >> mean!). So, you will run sqlexecd; it will listen on some port; you >> will then configure your Informix ODBC driver on the Windows machine to >> connect to your Unix box on the port to which sqlexecd is listening. >> And, if the wind is with you, you will have a connection that you can use. >> >> You're in a tough spot. No I-Net; nothing doing. With I-Net, you're on >> unsupported software using an unsupported combination. If it works, >> great; if not, don't try Tech Support unless you want to upgrade. >> >> It may be simpler to migrate the database: DB-Export the current >> database, transfer to new machine with current SE - or IDS - and >> DB-Import. Let's put it this way - this is what I'd do. >> >> -- >> Jonathan Leffler #include <disclaimer.h> >> Email: jleffler@earthlink.net, jleffler@us.ibm.com >> Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ > > Thank you, > your information are useful. > I know, that this is very old version :(, > it works on HP-ux B.10.20 A 9000/826, > unfortunately there isn't $INFORMIXDIR/lib/sqlexecd > on this machine. > My task is gather only information from database to other > database and this machine will be turn off. > I think eksport will be useful, i found dbexport in > ....informix/bin, but because I have 2 databases > (two file *.dbs in diffrent locations but with the same file name) > on this server - where can I find names of this databases? The 'files' are actually directories - dbase.dbs is the directory that holds the actual C-ISAM files that hold the data for the database called 'dbase'. You can, therefore, run dbexport twice, each time with the current directory as the directory that contains dbase.dbs. This will create separate directories dbase.exp, which you can then package up separately with tar and cart off to a suitable new machine. The dbase.exp directory will contain dbase.sql - a text file containing the database schema and related material. This is the basis of how to import the data. If you end up needing dbase1 and dbase2 for the new environment, then rename dbase.exp to dbase1.exp, and dbase1.exp/dbase.sql to dbase1.exp/dbase1.sql. You might also need to edit the name at the top of the file - but the rest should be OK - unless you want to set server-specific attributes (such as extent sizes, lock modes, dbspace names, fragmentation schemes, etc for IDS). The other files will have names along the lines of table00123.unl containing the Informix UNLOAD format data for a table name starting with 'table' and with tabid 123. These names are referenced in the dbase.sql file (as renamed). There is documentation on that format in the file unload.format that comes with the source of SQLCMD - available at the IIUG Software Archive (shameless plug). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/