PK70341: VARIOUS ABEND04E RC00E20006 DSN3AUCM DSNSVBK +0976 ADMF AGL VAR STORAGE ISSUES INVOLVING RUNTIME UPDATE & DELETE FROM RID WKFILE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Various ABEND04e RC00E20006 DSN3AUCM DSNSVBK +0976 Storage
  contraction abend issues in ADMF AGL agent local variable pool
  involving Runtime Update & Delete from Rid Workfile is on with
  cub null issue and old orphaned cub.
  .
  Additional Symptoms:
  .
  ABEND04E RC00E20003 DSNIWRCC DSNSVBK  +0602
  ABEND04E RC00E20003 DSNICUBD DSNSVBK  +0602
  ABEND04E RC00E20016 DSNSLD1  DSNSVSTK +05B8
  ABEND04E RC00E2002A DSNSLD1  DSNSVBK  +0882
  DSNXRUID UK28899 +04DE <<
  .
  DB2OVRLAY/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS       *
  *                 users of self-referencing UPDATEs.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E20006 from                *
  *                      DSN3AUCM.DSNSVBK+0976                   *
  *                      was observed while running many         *
  *                      self-referencing UPDATEs.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Abend04E-RC00E20006 from DSN3AUCM.DSNSVBK+0976
  was observed while running many self-referencing UPDATEs.
  
  The following SQL demonstrates the type of query that might
  cause the problem (i.e. access path dependent):
  UPDATE T2 A
  SET INTCOL =  INTCOL + 1
  WHERE INTCOL IN (SELECT INTCOL FROM T2 WHERE A.INTCOL = INTCOL)
  
  The statement must be run multiple times (i.e. in a loop) for
  the storage abend to occur.  Extra accumulation of Cursor
  Blocks (CUBs) cause the storage abend.
  
  A self-referencing DELETE may also be susceptible.
  

Problem conclusion

• Code was changed to properly reuse storage for
  a self-referencing UPDATE and DELETE.
  
  ADDITIONAL KEYWORDS: SQLUPDATE SQLDELETE SQLSTORAGE
  

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:

  UK42417 UK42418

Modules/Macros

• DSNXRDL2 DSNXRUID DSNXRUP2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK42417

     UP09/01/06 P F901

• R910 PSY UK42418

     UP09/01/06 P F901

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.