IBM Support

IT39582: DEFRAGMENT TABLE CORRUPTS INDEX STRUCTURE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as duplicate of another APAR.

Error description

  • After a defragment table subsequent operations like an insert
    report corruptions
    on one of the existing indexes on the table.
    
    On LINUX we can see a assertion with
    
    0x000000000170643c (oninit) bycmpr
    0x0000000000e49a69 (oninit) bycompare
    0x0000000000e43bb9 (oninit) btcpybck
    0x0000000000e45435 (oninit) btusearch
    0x0000000000e37123 (oninit) btadditem
    0x0000000000e38d2f (oninit) rsbtadditem
    0x00000000015cb9dd (oninit) fm_idxinsert
    0x00000000015a571d (oninit) fmwrite
    0x000000000071d403 (oninit) aud_sqiswrite
    0x000000000090c733 (oninit) chkrowcons
    0x00000000008ae301 (oninit) addone
    0x00000000008aaaa1 (oninit) ins1row
    0x00000000008ad29b (oninit) insone_next
    0x00000000009179c0 (oninit) doinsert
    
    
    On AIX we see
    
    07:02:39  Assert Warning: No parent node
    07:02:39   Who: Session(49, informix@db-vyvoj, 8585774,
    70002000139b068)
                    Thread(67, sqlexec, 70002000135bd40, 8)
                    File: rskey.c Line: 1321
    
    0x00000001006baa7c (oninit)kybad
    0x00000001001b7ac8 (oninit)btusearch
    0x00000001001b5c58 (oninit)btadditem
    0x00000001001ba508 (oninit)rsbtadditem
    0x0000000100a14da0 (oninit)isbtadditem
    0x00000001005a880c (oninit)fm_idxinsert
    0x00000001006f48f4 (oninit)fmwrite
    0x00000001007ff3c4 (oninit)aud_sqiswrite
    0x0000000100fb64b4 (oninit)chkrowcons
    0x0000000100fd1be4 (oninit)addone
    0x0000000100fd17cc (oninit)ins1row
    0x0000000100fccf3c (oninit)insone_next
    
    or
    
    Database selected.
    
    
      271: Could not insert new row into the table.
    
      105: ISAM error:  bad isam file format.
    Error in line 1
    Near character position 104
    
    
    Database closed.
    
    $ oncheck -cDI db:table
    
    Validating indexes for db:informix.tab...
                    Index i_tab
                      Index  fragment partition rootdbs in DBspace
    rootdbs
    ERROR:  Bad key information in TBLspace description.
    ERROR:  Keys in leaf node 0x1 have no rowids.ISAM error:
    illegal key descriptor (too many parts or too long).
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • This APAR is a duplicate of IT41062
    

APAR Information

  • APAR number

    IT39582

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED DUB

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-01-07

  • Closed date

    2023-02-02

  • Last modified date

    2023-02-17

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
18 February 2023