×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data Recovery from older Informix DB

Data Recovery from older Informix DB

Data Recovery from older Informix DB

(OP)
Sorry if this is the wrong forum but ...

Does anyone either have a link to or know of somewhere where I can get the DBD file specs for INFORMIX 3.3?

I have all the dbd and dat files which were backed up nightly ... I need to recover the data from an old Xenix box circa 86 and move into another RDB but the going has been painfully slow ... the data is stored in fixed format so I could manually determine the field sizes but that would take a huge amount of time considering there are several hundred fields across many tables and DB's ... so far I have figured out how to recover the Table and Field names out of the dbd files but still struggling with deciphering the Field details.

I have the Informix Manual which describes the data types just not sure how they coded these types in the dbd file. Any help would be appreciated.

RE: Data Recovery from older Informix DB

I hope this isn't a dumb question, but don't you have access to the Informix admin tools like dbexport and dbschema?

RE: Data Recovery from older Informix DB

(OP)
we have had a hardware failure ... haven't found any old working hardware that is compatible with the old XENIX OS ... the last time I was able to revive an old Harddrive and restore our image files but this time no luck ... kind of hard to run any INFORMIX tools without a machine loaded with XENIX ... so I am hoping to recover the files from the backup files ... plus at this point I would rather get off this old technology once and for all as it is taking too much time to support ... the only detail I am missing from the dbd file is the Data Type Tokens/defs ... ie where the field data type is stored in the file and how to determine the data length ... as the dat files are fixed length this is all I need to recover all the data.

RE: Data Recovery from older Informix DB

OK, I'm assuming we are talking about the Standard Engine and not Turbo/Online.  It sounds like you might have the database System Catalogue information.  The total Informix documentation is online at:

http://www-306.ibm.com/software/data/informix/pubs/library/

The oldest SE documentation is SE 5.  The system cat info is in the Guide to SQL:

http://publib.boulder.ibm.com/epubs/pdf/7193a.pdf

It looks like your version is older than SE 5.  If the above documentation doesn't help you out, I'd ask your question at the comp.databases.informix newsgroup.  I haven't visited there in some time, but they might be able to help you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close