PI23445: ABEND0C4 RC0000003B POSSIBLE OVERLAY IN DSNXOV0 WHEN VIEW CONTAINS MULTIPLE UNIONS 14/09/29 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC0000003B or ABEND0C1 R00000001 encountered when view
  contains multiple UNION.This may be a possible overlay in
  DSNXOV0 module.
  The registers are corrupted and the PSW address is invalid
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 or 11 for z/OS users of           *
  *                 view with multiple UNION/UNION ALL           *
  *                 with PI15409 applied.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 RC0000003B may occur for       *
  *                      query references a view that            *
  *                      contains multiple UNION/UNION ALL       *
  *                      with PI15409 / UI18603 (DB2 10) /       *
  *                      UI18604 (DB2 11).                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For example,
  
  1. Create a view
  
  CREATE VIEW V1 AS
  SELECT * FROM T1
  UNION
  SELECT * FROM T2
  ....
  SELECT * FROM T129;
  
  2. Reference a view
  
  SELECT * FROM V1;
  
  The abend occurs because the DB2 internal data structure that
  is used to hold the query blocks exceeds the maximum limit.
  This problem is exposed with PI15409.
  

Problem conclusion

• DB2 was updated to increase the size of the DB2 internal data
  structure which is used to hold the query blocks.
  
  Additional KeyWords: SQLUNION SQLUNIONALL SQLVIEW
                       DB2OVRLAY/K SMCOVERLAY
  

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:

  UI23122 UI23123

Modules/Macros

•    DSNXOACA DSNXOB1  DSNXOFN3 DSNXOLV  DSNXOMTX
  DSNXOONY DSNXOTL  DSNXOVC  DSNXOVM  DSNXOV0  DSNXOV1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI23122

     UP14/12/04 P F412 Ø

• RB10 PSY UI23123

     UP14/12/04 P F412 Ø

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.