PK79776: -180 SQLERROR VIEWING JCL FOR RECOVERY JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLERROR -180 received when trying to View JCL for generated
  recovery plans.  The following can occur if recovering an object
  with a dependand DISTINCT TYPE.
  
  ARYZ049E--ARYCSI SQL code = -180, reason code = 00000000.
  SQL message text follows:
  DSNT408I SQLCODE = -180, ERROR:  THE DATE, TIME, OR TIMESTAMP
  VALUE *N IS INVALID.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLERROR -180 received when trying to   *
  *                      View JCL for generated recovery plans.  *
  *                      The following can occur if recovering   *
  *                      an object with a dependand DISTINCT     *
  *                      TYPE.                                   *
  *                      ARYZ049E--ARYCSI SQL code = -180,       *
  *                      reason code = 00000000.                 *
  *                      SQL message text follows:               *
  *                      DSNT408I SQLCODE = -180, ERROR:  THE    *
  *                      DATE, TIME, OR TIMESTAMP VALUE *N IS    *
  *                      INVALID.                                *
  ****************************************************************
  * 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:

  UK45895

Modules/Macros

• ARYALA   ARYLHEDT ARYLHGDT ARYLJESE ARYODG
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R210 PSY UK45895

     UP09/04/28 P F904

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.