PH06024: USE OF "%" AS THE SOLE VALUE OF A HOST VARIABLE CAN CAUSE EXCESSIVE CPU WHEN ACCESSING DB2 CATALOGUE TABLES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Catalogue tables are accessed at various points in the
  creation of subscriptions and when processing Agent logon
  requests.  The SQL used may or may not need to use certain key
  columns for obtaining the needed data.  When a particular key
  column is not needed, the DB2 wildcard character ("%") is
  provided as the sole character of the related host variable.
  Rather than being interpreted by DB2 as "ignore use of this
  column for row set determination", DB2 still uses the column in
  its row set determination, and accesses the column data for all
  values in the table.  This can lead to high CPU and processing
  inefficiencies when using the SQL.
  

Local fix

• No local fix is available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of InfoSphere Change Data Capture for  *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When an instance of IIDR CDC for z/OS   *
  *                      accesses the DB2 Catalogue tables, the  *
  *                      SQL used may or may not need certain    *
  *                      key columns for obtaining the needed    *
  *                      data. When a particular key column is   *
  *                      not needed, the DB2 wildcard character  *
  *                      ("%") is provided. This can lead to     *
  *                      high CPU & processing inefficiencies    *
  *                      when using the SQL.                     *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  Accessing DB2 Catalogue tables can require a large amount
  of CPU resources.
  

Problem conclusion

• The "%" wildcard, where it appears as the sole value of an SQL
  predicate, is no longer being used.
  

Temporary fix

Comments

APAR Information

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

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

  UI61621

Modules/Macros

•    CHCDB2DL CHCDB210
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI61621

     UP19/03/08 P F903

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.