Re: R: Can I export an Informix 3 without Informix 3?

In article <3A130A51.774C473C@informix.com>, Jonathan Leffler <jleffler@informix.com> writes >Matteo Sirotti wrote: >> >> Thank you for your interest. >> >> 1 - The database directory is database.dbs >> 2 - I have installed Informix 4.11 but when I run isql (and select my >> database) or dbexport it gives me error "Cannot read system catalog >> (systables)" >> 3 - The database is quite big: 98 tables for about 10 Mb compressed (with >> pkzip) >> >> I think that if I find dbexport for Informix 3 I'll be good. >> >> Jonathan Leffler <jleffler@informix.com> wrote in message >> 3A0C3FDF.D37BB127@informix.com... >> > Siro wrote: >> > > I need to obtain ascii files from tables of an Informix 3 database on >> > > SCO Unix, but I have got only Informix 4.11 for Unix. >> > > Is there a way to do this? >> > >> > First of all, we need to verify which software you have. [...] > >Working off-line from the news group, we've established that the >application is written in I4GL 1.10.03, so the Informix 3.30 stuff does >not apply. We're working on why the 4.10 (not 4.11) SE database won't >access the 2.10.03 files; it should work, but there's a chance that the >locking mode on Xenix (which is where 1.10.03 would have been running; >this is circa 1988) was different from the locking mode on SCO Unix >where 4.10 is running. > >Does anybody remember whether DB-Export was part of the I4GL 1.10.03 or >ISQL 2.10.03 software, or did it arrive with version 4.00? What about >DB-Schema? dbexport & dbschema were after the version you are using. Things to check & try: 1) UNIX permissions on the .dbs directory & it's contents - to get at the stuff set to 777/666, or create a new database and copy how that is set up. 2) Run bcheck -S (I think) on all the .idx files in the directory - that will move the .idx to .IDX and rebuild the .idx so long as it can get the information out of the system catalogues, so do it on sys*.idx first. If there are corruptions in the indexes that should sort them. > -- Surfer!

"Surfer!" wrote: > Jonathan Leffler <jleffler@informix.com> writes > >Matteo Sirotti wrote: > >> 1 - The database directory is database.dbs > >> 2 - I have installed Informix 4.11 but when I run isql (and select my > >> database) or dbexport it gives me error "Cannot read system catalog > >> (systables)" > >> 3 - The database is quite big: 98 tables for about 10 Mb compressed (with > >> pkzip) > >> > >> I think that if I find dbexport for Informix 3 I'll be good. > >> > >> Jonathan Leffler <jleffler@informix.com> wrote in message > >> 3A0C3FDF.D37BB127@informix.com... > >> > Siro wrote: > >> > > I need to obtain ascii files from tables of an Informix 3 database on > >> > > SCO Unix, but I have got only Informix 4.11 for Unix. > >> > > Is there a way to do this? > >> > > >> > First of all, we need to verify which software you have. [...] > > > >Working off-line from the news group, we've established that the > >application is written in I4GL 1.10.03, so the Informix 3.30 stuff does > >not apply. We're working on why the 4.10 (not 4.11) SE database won't > >access the 2.10.03 files; it should work, but there's a chance that the > >locking mode on Xenix (which is where 1.10.03 would have been running; > >this is circa 1988) was different from the locking mode on SCO Unix > >where 4.10 is running. > > > >Does anybody remember whether DB-Export was part of the I4GL 1.10.03 or > >ISQL 2.10.03 software, or did it arrive with version 4.00? What about > >DB-Schema? > > dbexport & dbschema were after the version you are using. We'd pretty much established that -- thanks for the confirmation. > Things to check & try: > > 1) UNIX permissions on the .dbs directory & it's contents - to get > at the stuff set to 777/666, or create a new database and copy how that > is set up. > > 2) Run bcheck -S (I think) on all the .idx files in the directory - > that will move the .idx to .IDX and rebuild the .idx so long as it can > get the information out of the system catalogues, so do it on sys*.idx > first. If there are corruptions in the indexes that should sort them. I got the data and ran SE 5.08.UD1 on Solaris against it. All the data types were portable (no FLOAT or SMALLFLOAT columns), so I've dbexport'd it and sent that back to Matteo -- overflowed one mail box but the remainder seems to have fitted in another. Since 5.08 could work OK, I don't know what was wrong with Matteo's setup, but there was definitely something up. The only weirdness I encountered was that when I first ran 5.08 against the data, it failed to add syssyntable; simply running it a second time added the table OK. I've no idea what that was about. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"