PI83150: ADB5031W MESSAGE AND SQLCODE -713 RUNNING ADBTEP2 RESTART

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ADBTEP2 restart of a job may end with rc=4, and the ADBDIAG
  output will show a sqlcode -713 error and the following message:
  
  ADB5031W No statements were found that can be run.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS who use Batch Restart               *
  *                 program ADBTEP2 to restart                   *
  *                 Work Statement List (WSL).                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running the Batch Restart          *
  *                      program ADBTEP2, restart of the         *
  *                      WSL displays warning message            *
  *                      ADB5031W / msgadb5031w.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the WSL is opened in edit mode, the CM Batch
  run process failed to setup SYSIN during restart of
  ADBTEP2. Lack of input in the SYSIN file makes
  ADBTEP2 assume that there are no statements
  to process, resulting in warning message ADB5031W /
  msgadb5031w in SYSPRINT
  
  ADB5031W No statements were found that can be run.
  

Problem conclusion

• The problem has been resolved.
  When the failure occurs while preparing SYSIN, the following
  message ADB9970E / msgadb9970e will be issued and the
  program will be terminated:
  
  ADB9970E Error setting up SYSIN file: >file name<
  

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:

Modules/Macros

•    ADB9000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI49875

     UP17/08/31 P F708

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.