PH19648: DB2 LOAD LOG NO RESUME YES COPYDDN RESULT BUFFERPOOL FULL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After LOAD RESUME YES SHRLEVEL NONE execution with the COPYDDN
  job ends,the number of IN-USE/UPDATE BUFFERPOOL (from MESSAGE
  DSNB402I after -DIS BPOOL) gets dirty/fixed.
  Here is an example:
  .
  LOAD RESUME YES SHRLEVEL NONE with COPYDDN run against objcet
  using BP11.
  ,
  1st run:at job end, DIS BPOOL(BP11) shows IN-USE/UPDATED = 0
  
  2nd run: at job end, DIS BPOOL(BP11) shows IN-USE/UPDATED = 99
  
  3rd run: at job end, DIS BPOOL(BP11) shows IN-USE/UPDATED = 198
  ...
  .
  As the number INCREASE at next execution. It could eventually
  result in buffer pool full (LRU chain empty and fail to get
  buffer) - DSNB601I and DSNT500I with RC00C200E9.
  .
  10.23.56 S0315148 DSNB601I -DBD0 BUFFER POOL BP11 FULL
  10.23.58 S0315148 DSNT500I -DBD0 DSNUGRAR RESOURCE UNAVAILABLE
  081
  081 REASON 00C200E9
  081 TYPE 00000700
  081 NAME BP11
  .
  

Local fix

• BYPASS/CIRCUMVENTION:
  1.) avoid LOAD RESUME YES SHRLEVEL NONE execution with the
  COPYDDN keyword to create a sequential copy. Either FlashCopy
  inline image copy can be used.
  2.)user can run the LOAD job without SYSCOPY/COPYDDN and rely on
  a subsequent COPY utility execution to create the recovery base
  (also consider turning on NOCOPYPEND on the LOAD job to avoid
  the intermediate COPY pending status to be set).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 for z/OS and Db2 12 for z/OS                      *
  * users of LOAD SHRLEVEL NONE RESUME YES                       *
  * COPYDDN                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2 buffer pool became full with                             *
  * RC00C200E9 after LOAD SHRLEVEL NONE                          *
  * RESUME YES COPYDDN execution                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  User ran a LOAD SHRLEVEL NONE RESUME YES COPYDDN which created
  a sequential inline image copy against the table space or
  partitions being loaded into.  The LOAD job completed
  successfully, but it was noticed that the number of buffers
  reported under the IN-USE/UPDATE counter in message DSNB402I
  by the -DIS BPOOL command showed a large non-zero value due
  to page fixing in the buffer pool resided by the table space
  operated by LOAD.  This eventually led to a buffer pool full
  with RC00C200E9 in subsequent access of this table space.
  The reported problem was caused by incorrect program logic
  where the space map pages gotten for the LOAD SHRLEVEL NONE
  RESUME YES COPYDDN image copy processing were not released
  correctly, resulting in a page fixed condition that led to the
  RC00C200E9.
  Additional keyword: MSGDSNB402I
  

Problem conclusion

• Code has been modified to correct the aforementioned problem so
  that LOAD SHRLEVEL NONE RESUME YES COPYDDN execution would
  release the space map pages getpaged correctly.
  

Temporary fix

Comments

• ×**** PE20/11/29 FIX IN ERROR. SEE APAR PH32096  FOR DESCRIPTION
  ×**** PE20/11/27 FIX IN ERROR. SEE APAR PH32096  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI68769 UI68770

Modules/Macros

• DSNUBASP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI68769

     UP20/04/09 P F004

• RC10 PSY UI68770

     UP20/04/09 P F004

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.