IC87310: INDEX ON CDR_DELTAB_* IS CREATED WITH EXTENT AND NEXT SIZE WHEN BASE TABLE HAS AN INDEX (PRIMARY KEY) DEFINED WITH EXTENT AND NE

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

  • Table is created with an initial and next extent size and has a
    primary key defined with an initial and next extent size as
    well.
    
    Replication is defined on the table with timestamp conflict
    resolution. cdr_deltab_* is created with default extent size but
    the primary key on cdr_deltab_* is  created with the same extent
    and next size as the base table's primary key.
    
    But if the table is created with initial and next extent size
    and the primary key on the table has the default
    extent and next size, both the cdr_deltab_* and it's primary key
    are created with the default index size.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ER customers with a large  fragmented index using update     *
    * anywhere                                                     *
    ****************************************************************
    * 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

    IC87310

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-17

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

  • 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

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RB50 PSN

       UP

  • RB50 PSY

       UP

  • RB70 PSN

       UP

  • RB70 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

B70

Reference #:

IC87310

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation