IBM Support

IT10790: INDEX REPACK WRITES ASSERT FAILURE EVEN IF IT SUCCEEDS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The index repack on a fragmented table succeeds but writes
    assert failure files:
    
    Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
    blocked 1, Plog used 18432, Llog used 42859
    
    Assert Warning: Repack has attempted 1000 times to repack index
    ak_46989:"informix".miscari#ix_cont_fisa
    IBM Informix Dynamic Server Version 12.10.FC5W1
    Who: Session(36, informix@, 0, 0x44c3f0e0)
                    Thread(150, repack.2, 44bfb1e8, 1)
                    File: rsidxreorg.c Line: 1578
     Results: Unable to complete repack of index because its too
    volatile.
    Action: Try running the repack operation when index is being
    updated less frequently.
    stack trace for pid 23044 written to
    /opt/informix/12.10.FC5W1/tmp/af.47e5ee2
    See Also: /opt/informix/12.10.FC5W1/tmp/af.47e5ee2
    Repack has attempted 1000 times to repack index
    ak_46989:"informix".miscari#ix_cont_fisa
    SCHAPI Repack succeeded for index
    'ak_46989:informix.ix_cont_fisa' partnum 400003.
    SCHAPI Shrink for ak_46989:informix.ix_cont_fisa started
    SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum
    200003 succeeded.
    SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum
    300003 succeeded.
    SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum
    400003 succeeded.
    SCHAPI index repack shrink  ak_46989:informix.ix_cont_fisa
    succeeded
    
     (oninit) afstack
     (oninit) afhandler
     (oninit) afwarn_interface
     (oninit) rsidxrepack
     (oninit) fmrepack_idxfrag
     (oninit) startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * users of IDS 12.10                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IBM Informix Server 12.10.xC6                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IBM Informix Server 12.10.xC6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT10790

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-08-19

  • Closed date

    2015-12-30

  • Last modified date

    2015-12-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 December 2015