IC98568: CROSS DATABASE INSERTS INTO TABLES USING RANGE INTERVAL BASED FR AGMENTATION AND VIOLATION TABLES YIELD SYSTEM CATALOG CORRUPTION

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 following system catalog corruption was observed in
    11.70.FC4 on linux x86_64.
    
    Consider two databases db1, db2 having similar schemas that
    involve tables using fragment by range/interval.
    
    DML on db2 when db1 is current can cause this problem.  The
    problem is heightened when these tables
    use violation tables and are dropped and recreated.  It appears
    we are losing track of which database is open
    and current in these statements.
    
    Types of oncheck -cc errors that may be seen are:
    
        Validating systables for database c31db31
    ERROR:  Database c31db31  sysfragments has 33 records,
            but systables and sysindices refer to 30.
    
    or
    
    Validating database c31db31
    
        Validating systables for database c31db31
    TBLspace c31db31:informix.t_remessadetrec                 Table
    fragment partition sys_p95 in DBspace dbs02
    ERROR:  wrong pn_lockid 6291461, should be 6291458.
    TBLspace c31db31:informix.t_remessadetrec                 Index
    ix_tremessadetrec01 fragment partition sys_p40 in DBspace idx01
    ERROR:  wrong pn_lockid 6291461, should be 6291458.
    TBLspace c31db31:informix.t_remessadetrec                 Index
    pk_tremessadetrec fragment partition sys_p40 in DBspace idx01
    ERROR:  wrong pn_lockid 6291461, should be 6291458.
    TBLspace c31db31:informix.t_remessadetrec_vio             Table
    fragment partition sys_p95 in DBspace dbs03
    ERROR:  wrong pn_lockid 6291463, should be 6291460.
    
    or even
    
    Validating database c31db31
    
        Validating systables for database c31db31
    TBLspace c31db31:informix.t_remessadetrec                 Table
    fragment partition sys_p95 in DBspace dbs02
    ERROR:  wrong pn_lockid 6291460, should be 6291458.
    ERROR:  informix.t_remessadetrec rowsize 16 != tblspace.rowsize
    53
        TBLspace name                  t_remessadetrec
        Owner                          informix
        TBLspace number                0
        Tabid                          100
        Row size                       16
        Number of columns              4
        Number of indexes              2
        Number of rows                 0
        Date created                   01/03/2014
        TBLspace major version number  104
        TBLspace minor version number  2
        TBLspace type                  T
        Locking level                  R
        Number of pages used           0
        First extent size              1000
        Next extent size               2000
        Flags                          0
        Site
        Database name
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * insert/update on cross-database table which triggers         *
    * fragment creation(interval fragmented table/index) will      *
    * corrupt the sysfragment catalog.                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-11.70.xC8                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-11.70.xC8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC98568

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-06

  • Closed date

    2014-05-08

  • Last modified date

    2014-05-08

  • 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

  • RB70 PSY

       UP

  • RC10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

B70

Reference #:

IC98568

Modified date:

2014-05-08

Translate my page

Machine Translation

Content navigation