PH02876: ABEND0C4 RC00000004 DSNGEPLC OFFSETED2A WHEN IFCID 400 TRACE IS ACTIVE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC00000004 DSNGEPLC OFFSETED2A when
  IFCID 400 trace is active .
  .
  Additional keywords: IFCID400
  

Local fix

• Turn off IFCID 400 trace
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 and 12 for z/OS and IBM           *
  *                 Db2 Analytics Accelerator users of           *
  *                 static accelerated Insert with               *
  *                 Subselect of an Accelerated-Only             *
  *                 Table (AOT).                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 at DSNGEPLC+ED2A may happen    *
  *                      when:                                   *
  *                      1. IFCID 400 Trace is active; and       *
  *                      2. A static accelerated Insert with     *
  *                         subselect statement into an          *
  *                         Accelerator-Only Table (AOT) is      *
  *                         executed.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When IFCID 400 Trace is active and a static accelerated
  Insert with subselect statement into an Accelerator-Only
  Table (AOT) is executed. Db2 took an incorrect code path
  resulting in the abend described.
  

Problem conclusion

• Db2 code is modified to take the right path.
  
  Additional Keywords:
  IDAAV4R1/K IDAAV5R1/K IDAAV7R1/K
  

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:

  UI60131 UI60132

Modules/Macros

•    DSNGEPLC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI60132

     UP18/12/22 P F812

• RC10 PSY UI60131

     UP18/12/10 P F812

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.