PM59521: BUILD JOB ENDS WITH RC=6 AFTER -805 SQL ERROR ( SQLCODE805 )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An Automation Tool build job ends with RC=6 after a -805 SQL
  code.  RC=6 should indicate that the job completed normally,
  but no objects were selected.  Application of this APAR will
  result a RC=8 in batch if the 'Generate Job when Errors
  encountered' parameter is set to 'Y' and RC=12 if the parameter
  is set to 'N'.  An online build that receives a -805 error
  will result in RC=12
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: An Automation Tool build job ends with  *
  *                      RC=6 after a -805 SQL code.  RC=6       *
  *                      should indicate that the job completed  *
  *                      normally, but no objects were selected. *
  *                      Application of this APAR will result a  *
  *                      RC=8 in batch if the 'Generate Job when *
  *                      Errors encountered' parameter is set    *
  *                      to 'Y' and RC=12 if the parameter       *
  *                      is set to 'N'.  An online build that    *
  *                      receives a -805 error will result in    *
  *                      RC=12                                   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK78915 UK78916

Modules/Macros

• HAA#UPRI
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK78915

     UP12/05/25 P F205

• R410 PSY UK78916

     UP12/05/25 P F205

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.