PM48239: DB2 V10 CONCURRENCY SUPPORT FOR RUNTIME COLLECTORS AND UTILITIES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Provide concurrency support for DB2 V10 within CICS IA for the
  runtime collectors and batch utilities.
  .
  Additional Symptom(s) Search Keyword(s): KIXREVWJB
  DB2V10 10 compatability concurrence run time
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: CICS IA 3.2 users who plan to collect        *
  *                 DB2 V10 commands.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The names of new DB2 V10 commands (SQL  *
  *                      statements) are not recognised by CICS  *
  *                      IA, and resources of all DB2 commands   *
  *                      are not determined by CICS IA.          *
  *                      The CIUDB2V view is incorrect in        *
  *                      DB2 V10.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF and perform HOLD ACTION.       *
  ****************************************************************
  The new DB2 V10 commands and resource types are absent in the
  CIUUFIDT module.
  The SYSIBM.SYSPACKSTMT table has changed in DB2 V10.
  The STMT column which held all or a portion of the text for the
  SQL statement no longer exists.  It has been replaced instead by
  the STATEMENT column which is a CLOB that holds the complete
  text of an SQL statement.
  The CIUDB2V view uses the STMT column which is correct for DB2
  V9 and earlier releases, but for DB2 V10 it is incorrect and the
  STATEMENT column should be used instead.
  

Problem conclusion

• The new DB2 V10 commands and resource types have been added to
  the CIUUFIDT module. CIUCINB2 module has been corrected to
  obtain resources from the SYSIBM.SYSPACKSTMT table.
  The CIUDB2V view is created during configuration of CICS IA
  depending on DB2 version.
  

Temporary fix

Comments

APAR Information

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

  PM39169

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

  UK74588

Modules/Macros

•    CIUAFFL1 CIUAFFL2 CIUAFFL3 CIUCINB2 CIUCNFG2
  CIUDBNT  CIUDBV10 CIUGETCD CIUREPRO CIUUFIDT CIUU042  CIUU045
  H274320J
  

Fix information

• Fixed component name

  CICS INTER ANAL

• Fixed component ID

  5655U8600

Applicable component levels

• R320 PSY UK74588

     UP12/01/07 P F201

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.