PM77357: ABEND0C4 RC11 AT DSNXOGPS+2C6A

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC11 at DSNXOGPS+2C6A
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and 10 for z/OS users of SQL       *
  *                 statements where global optimization is      *
  *                 applied.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 RC00000011 at the location     *
  *                      DSNXGRDS DSNXOGPS OFFSET2C6A could      *
  *                      happen for an SQL statement when global *
  *                      optimization is used. This ABEND is     *
  *                      dependent on the contents of some       *
  *                      random storage in the PSA, so normally  *
  *                      it won't happen.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The failure can be observed in the following example:
  
  CREATE TABLE TBL1 (
    C1  INTEGER,
    C2  CHAR(10),
    C3  SMALLINT);
  
  CREATE TABLE TBL2 (
    C1  INTEGER,
    C2  CHAR(10),
    C3  SMALLINT);
  
  SELECT C1
  FROM TBL1 T1
  WHERE
  T1.C1  IN
  (SELECT C1  FROM TBL2 T2
   WHERE T2.C3=28
  )
  FOR FETCH ONLY
  WITH CS;
  
  DB2 did not correctly set the internally generated table name of
  the virtual table, which caused the ABEND.
  

Problem conclusion

• DB2 has been modified to correctly process the virtual table
  setting, so there will be no ABEND.
  
  Additional keywords: SQLGLOBALOPT
  

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:

  UK91020 UK91021

Modules/Macros

•    DSNXOB2  DSNXOSO4
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK91020

     UP13/02/02 P F302

• R910 PSY UK91021

     UP13/02/02 P F302

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.