PI25510: -START DB(XXX) SP(*) TO RESOLVE LPL FAILED RC00C200EA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• -START DB(xxx) SP(*) was issued to resolve a few LPL pages on
  some partitions.
  This was on a data sharing system, where many concurrent short
  read/update transactions were running.
  The -start command was suspended for 40 seconds (and irlmrwt=40)
  and it failed with RC00C200EA . Also many transactions were
  suspended about 40 seconds.
  A DRAIN ALL was done for this scenario, causing the issue.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 for z/OS users                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: -START DATABASE command may fail        *
  *                      RC00C200EA (DRAIN FAILURE) when         *
  *                      resolving the LPL pages.                *
  *                                                              *
  *                      The output from -DISPLAY DATABASE LPL   *
  *                      command may unintentionally contain     *
  *                      the string 'DBETE' in the dashed line   *
  *                      under the column header 'LPL PAGES'.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When clearing the LPL pages, the page set type for a table space
  is not set correctly by the command processor, hence causing a
  DRAIN ALL to be issued when not all the pages of the page set
  are in LPL.  If there are other concurrent read claimers, -START
  command may fail RC00C200EA unnecessarily.
  
  When displaying the dashed line under the column header, the
  length is not set correctly by -DISPLAY command processor.  As a
  result, the string 'DBETE' may show up under the column header
  'LPL PAGES'.
  

Problem conclusion

• The code has been changed to correctly set the page set type and
  the length of the column header 'LPL PAGES'.
  

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:

  UI23287 UI23288

Modules/Macros

•    DSNILSTS DSNISREC DSNTDMUL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI23287

     UP14/12/06 P F412

• RB10 PSY UI23288

     UP14/12/06 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.