Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2002
    Posts
    3

    Unhappy Unanswered: SYSOBJSTATE corrupted after HPL load problems?

    Hi to all,

    We've a DW which uses the High-Performance Loader to add to it's tables in an overnight cron job (IDS 9.40.FC3W2 on Solaris 8) each weekend.

    This weekend, it looks as though one of the jobs on the DW db kicked off early, and "fought" with the HPL load job :-(
    15:34:18 Records Processed -> 6680000
    Cannot set mode of indexes objects '"informix".xpkparcel' to enabled mode,
    SQL error -242, ISAM error -106

    Cannot re-enable all objects, 619595 violations detected,
    check for violations in violations table 'parcel_vio'
    and diagnostics table 'parcel_dia'

    Database Load Completed -- Processed 6686934 Records
    Records Inserted-> 6067339
    Detected Errors--> 0
    Engine Rejected--> 619595


    I'm not worried about the violations, they're likely to be an overlap in data, as the previous week's unload/load didn't happen until Thursday night, so will have loaded a few extra days' data from the earlier part of last week...

    The problem is, if I do a dbschema of the table in question, I get the column details and table privs, followed by an error:
    ...
    amend_func char(8)
    );
    revoke all on "informix".parcel from "public";

    100 - ISAM error: duplicate value for a record with unique key.


    Attempting to query Info->Status thru dbaccess menu, or "info status for parcel" thru SQL gives:
    397: System catalog (sysobjstate) corrupted.

    111: ISAM error: no record found.


    (SELECT * FROM parcel / SELECT COUNT (*) FROM parcel also give 397/111 errors. )

    oncheck -ci ops_dwh:parcel gives
    Validating indexes for ops_dwh:informix.parcel...
    oncheck failure: gettab()


    There's no warning messages in the online.log, and to trace of an assert fail or shm dump on the server.

    I'd like to canvass opinion of anything else I can try, before calling IBM Support. What stage has dbschema got to when it hits the duplicate/unique problem? (and does this shed any light on a possible fix?)

    I've an ON-Bar (whole) backup we can restore, but I'm loath to do this, as it means messing around with the (legacy) unload jobs to ensure they pick up the correct data...

    Thanks in advance for any advice! Please let me know if you want me to post additional info.

    Rob

    PS Forgot to mention, the table and indices are fragmented...
    unload to...
    select
    fragtype,
    indexname,
    strategy,
    location,
    evalpos,
    flags,
    dbspace
    from sysfragments
    where tabid = 880
    order by 1,2,5


    gives

    I|pk_pcl_key_2|I|L|0|2|dbs11|
    I|xie1parcel|T|L|0|0|dbs01|
    I|xie1parcel|T|L|1|0|dbs02|
    I|xie1parcel|T|L|2|0|dbs03|
    I|xie1parcel|T|L|3|0|dbs04|
    I|xie1parcel|T|L|4|0|dbs05|
    I|xie1parcel|T|L|5|0|dbs06|
    I|xie1parcel|T|L|6|0|dbs07|
    I|xie1parcel|T|L|7|0|dbs08|
    I|xie1parcel|T|L|8|0|dbs09|
    I|xie1parcel|T|L|9|0|dbs10|
    I|xie1parcel|T|L|10|0|dbs11|
    I|xie1parcel|T|L|11|0|dbs12|
    I|xie1parcel|T|L|12|0|dbs13|
    I|xie1parcel|T|L|13|2|dbs14|
    I|xie2parcel|T|L|0|0|dbs01|
    I|xie2parcel|T|L|1|0|dbs02|
    I|xie2parcel|T|L|2|0|dbs03|
    I|xie2parcel|T|L|3|0|dbs04|
    I|xie2parcel|T|L|4|0|dbs05|
    I|xie2parcel|T|L|5|0|dbs06|
    I|xie2parcel|T|L|6|0|dbs07|
    I|xie2parcel|T|L|7|0|dbs08|
    I|xie2parcel|T|L|8|0|dbs09|
    I|xie2parcel|T|L|9|0|dbs10|
    I|xie2parcel|T|L|10|0|dbs11|
    I|xie2parcel|T|L|11|0|dbs12|
    I|xie2parcel|T|L|12|0|dbs13|
    I|xie2parcel|T|L|13|2|dbs14|
    I|xie3parcel|T|L|0|0|dbs01|
    I|xie3parcel|T|L|1|0|dbs02|
    I|xie3parcel|T|L|2|0|dbs03|
    I|xie3parcel|T|L|3|0|dbs04|
    I|xie3parcel|T|L|4|0|dbs05|
    I|xie3parcel|T|L|5|0|dbs06|
    I|xie3parcel|T|L|6|0|dbs07|
    I|xie3parcel|T|L|7|0|dbs08|
    I|xie3parcel|T|L|8|0|dbs09|
    I|xie3parcel|T|L|9|0|dbs10|
    I|xie3parcel|T|L|10|0|dbs11|
    I|xie3parcel|T|L|11|0|dbs12|
    I|xie3parcel|T|L|12|0|dbs13|
    I|xie3parcel|T|L|13|2|dbs14|
    I|xpkparcel|I|L|0|2|dbs11|
    T||R|L|0|0|dbs01|
    T||R|L|1|0|dbs02|
    T||R|L|2|0|dbs03|
    T||R|L|3|0|dbs04|
    T||R|L|4|0|dbs05|
    T||R|L|5|0|dbs06|
    T||R|L|6|0|dbs07|
    T||R|L|7|0|dbs08|
    T||R|L|8|0|dbs09|
    T||R|L|9|0|dbs10|
    T||R|L|10|0|dbs11|
    T||R|L|11|0|dbs12|
    T||R|L|12|0|dbs13|
    T||R|L|13|2|dbs14|


    Is the flags=2 on the PK and frags in dbs14 something to worry about?
    Last edited by Fester; 01-31-05 at 15:27.

Posting Permissions

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