Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006

    Unanswered: .dat/.idx question archaic iformix v. 311

    let me preface this by saying I am a programmer and not informix db management savvy, but somehow I ended up being the choice to inherit db maintainance when my boss decided oxycontin was the way forward and quit. My question is this, I have several .dat files w/ no .idx files
    is it possible to rebuild the indexes using only the .dat files? If so,
    is bcheck the proper tool and how do I use it.

    One last caveat, as I stated before we are running the equvelent of informix 3.11 (its a long story that starts many years ago) on a current HPUNIX release.

    Sorry for my ignorace and any help would be great.

  2. #2
    Join Date
    Aug 2003

    Please test running create index.


  3. #3
    Join Date
    Jan 2006
    Thanks for the quick reply, sorry about being so undereducated about this,
    how would I go about testing running create index, I'm not sure what program to use to do this, if you are saying to do it w/ bcheck I again am not sure how to. There is no documentaion for bcheck (aside from the source code). Again I'm sorry about my lack of knowledge. please expand your solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts