IBM Support

PM65918: CIU2207E DB2 ERROR ON SYSIBM.SYSPACKSTMT SQL CODE -525 DB2 V10 COMPATIBILITY MODE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You upgraded your DB2 subsystem to DB2 V10 in compatibility
    mode.  You re-ran the CIUCNFG1 CICS IA configuration clist to
    update the CICS IA supplied sample JCL and SQL.  You ran the
    CIUDBNT job which binds CICS IA background program CIUCINB2.
    When the CINB task runs and needs to update dependency data for
    DB2 resources the following message is received on the CINTLOG:
    
    CIU2207E mm/yy/dd hh:mm:ss applid DB2 error on
    SYSIBM.SYSPACKSTMT SQL code -525, DB2 requests stopped
    
    Pogram CIUCINB2 which accesses the SYSIBM.SYSPACKSTMT catalog
    table in its GET_DB2_RESOURCE proc uses the DB2_RELEASE field
    which was set from a EC INQUIRE DB2CONN for field DB2RELEASE.
    In this case, if DB2 V10 is in compatibility mode, the
    STATEMENT column does not yet exist in the SYSPACKSTMT table.
    
    CICS IA needs to determine the DB2 runtime mode and if not in
    new function mode, it needs to use the STMT column.  The
    SYSIBM.VERSION DB2 catalog table identifies the DB2 version and
    mode.
    
    Additional Symptom(s) Search Keyword(s): KIXREVWJB
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All CICS IA v.3.2 users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: Customer obtains the message CIU2207E   *
    *                      -525 SQLCODE from CIUCINB2 when DB2     *
    *                      V10 is in a compatibility mode.         *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF and perform HOLD ACTION item.  *
    ****************************************************************
    CICS IA checks the DB2 version only, but does not check the
    mode in which DB2 works. The customer obtains the error message
    CIU2207E -525 SQLCODE from CIUCINB2 when DB2 V10 is in a
    compatibility mode with DB2 V910.
    

Problem conclusion

  • This PTF uses DB2 Session Variable SYSIBM.VERSION to check the
    level identifier. If it is less than 5, the new DB2 V10 function
    is not used.
    

Temporary fix

Comments

  • ž**** PE12/12/14 FIX IN ERROR. SEE APAR PM79205  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PM65918

  • Reported component name

    CICS INTER ANAL

  • Reported component ID

    5655U8600

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-31

  • Closed date

    2012-09-28

  • Last modified date

    2013-01-25

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

    PM63018

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

    UK82318

Modules/Macros

  •    CIUCINB2
    

Fix information

  • Fixed component name

    CICS INTER ANAL

  • Fixed component ID

    5655U8600

Applicable component levels

  • R320 PSY UK82318

       UP12/10/10 P F210

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSPPUS","label":"CICS Interdependency Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
25 January 2013