Results 1 to 4 of 4

Thread: ISAM error

  1. #1
    Join Date
    Jan 2005

    Unanswered: ISAM error

    Hi guys
    I am no DB expert and need help here please.
    I have just recovered from a disk crash on WinNT40
    running Informix DS 7.31 TC4

    After recovering the users could noty log in
    Error was -27002
    so I tried 'onmode -m' - with no luck

    baan support suggested running 'ontape -a' but this came back with an error

    so I checked online.log and it had a message to run 'oncheck -pt 3146124'

    so I ran the above command and go the following message:
    IAMS Error: Primary and Mirror chunks are bad.

    How do I recover from this?

  2. #2
    Join Date
    Jan 2005
    I think you have a down dbspace/chunk. Check 'onstat -d' output.
    You got some corruption during windows crash.

    May need to restore down dbspaces.

  3. #3
    Join Date
    Jan 2005

    ISAM error

    What should I be looking for?

  4. #4
    Join Date
    Nov 2004
    Check the Flags for all the chunks. They all should be PO, if you find PD, it means, that particular chunk is down. You can try to change the status of chunk using onspaces command.

Posting Permissions

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