IBM Support

PI21358: QREP MIGHT RETURN RC00C90064 IF THE DICTIONARY IS BUILT BY INSERT ON ANOTHER MEMBER.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • QREP was running on member A. Dictionary was built by insert on
    member B, then member B tried to notify other members to load
    the dictionary.
    Compressed log records were generated on members where
    dictionary was loaded successfully.
    
    There was a timing window issue that QREP running on member A
    fetched compressed log record before member A loaded the
    dictionary.
    
    Another possible abend is 00C90101 DSNIMOFR:500E, showing
    message DSNI014I and CORRELATION-ID 021.ZLDICT01, when two
    members are both doing INSERT's and both begin building a
    dictionary via DSNUZLCR.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Data Capture applications using IFCID 306    *
    *                 to read compressed log data in DB2 for       *
    *                 z/OS V10 and V11.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION: IFI 306 log read failed with            *
    *                      reason code 00C90064.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    In data sharing environment, insert from one DB2 member,
    say DB2A, into a compressed table space can trigger dictionary-
    building for the pageset or partition during the insert, and
    then subsequent rows inserted into the same pageset or partition
    and the associated log records will get compressed. If an
    IFI 306 reader runs from another DB2 member, say DB2B, using
    the same pageset or partition at the same time, there is a
    timing window during which the IFI 306 reader on DB2B may see
    the newly compressed log records before the dictionary is
    loaded in DB2B's buffer. In this case the IFI 306 will fail
    with reason = 00C90064.
    

Problem conclusion

  • DB2 code has been modified to load the dictionary from DASD if
    the IFI 306 log reader encounters compressed log records
    when the dictionary has not been loaded yet.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PI21358

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-07

  • Closed date

    2014-11-21

  • Last modified date

    2015-03-10

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

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

    UI23321 UI23322

Modules/Macros

  • DSNIDCML DSNIFDIC DSNIZLDR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI23321

       UP14/12/06 P F412

  • RB10 PSY UI23322

       UP14/12/06 P F412

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
10 March 2015