Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Bad access path is possible when FETCH FIRST N ROW or OPTIMIZE
  FOR N ROW clause is present.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Sometimes when the OPTIMIZE FOR N    *
  *                         ROW or FETCH FIRST N ROW clause      *
  *                         is present on a query, a poor access *
  *                         path may be generated due to an      *
  *                         unitialized internal structure.      *
  *                      2. ABEND0CC RC0C in DSNXOCSC or poor    *
  *                         performance can sometimes occur for  *
  *                         queries on tables having at least    *
  *                         one index.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1. Sometimes when the OPTIMIZE FOR N ROW or FETCH FIRST N ROW
     clause is present on a query, a poor access path may be
     generated due to an uninitialized internal structure.
  2. ABEND0CC RC0C in DSNXOCSC or poor query performance can
     sometimes occur for queries on tables having at least one
     index.  An uninitialized variable can cause trouble if it
     happens to pick up certain garbage values.
  
  Additional Keywords:
  SQLACCESSPATH  SQLOFNR  SQLFFNR  ROWS
  

Problem conclusion

• The internal structure is initialized to allow the proper
  access path to be chosen.  An uninitialized variable is set to
  avoid the abend.
  

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:

  UK12030

Modules/Macros

• DSNXOCSC
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK12030

     UP06/03/11 P F603

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.

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Product categories:

Software

Data Management

Data Servers (Database Management Systems)

DB2 for z/OS

Software version:

810

Reference #:

PK18018

IBM Group:

Software Group

Modified date:

2006-06-07