PI13475: ERROR PARSING UNLOAD TABLE STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS ERROR PARSING UNLOAD TABLE
  STATEMENT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who uses the IMAGE COPY             *
  *                 utility with an invalid ADMIN UNLOAD         *
  *                 statement.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: An error message is displayed upon      *
  *                      unsuccessful completion of an invalid   *
  *                      ADMIN UNLOAD statement and does not     *
  *                      describe a meaningful message to        *
  *                      assist with troubleshooting.            *
  *                                                              *
  *                      The DB2 Admin tool generated            *
  *                      option FROM LAST_IC, BEFORE_IC,         *
  *                      or AFTER_IC is deleted from the         *
  *                      job, and the error ADB5299E is          *
  *                      issued:                                 *
  *                                                              *
  *                      ADB5299E Unexpected error in            *
  *                      image copy processing. Reason           *
  *                      code = >rc<                             *
  *                                                              *
  *                      Invalid syntax example:                 *
  *                      ADMIN UNLOAD TABLESPACE                 *
  *                      >dbname<.>tablespace_name<              *
  *                        FROM TABLE                            *
  *                      "SYSIBM"."SYSTABLES"                    *
  *                        PUNCHDDN(UTLPUNCH)                    *
  *                        UNLDDN(UTLREC)                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An error message is displayed upon unsuccessful completion of
  an ADMIN UNLOAD statement and does not describe a meaningful
  message to assist with troubleshooting.
  

Problem conclusion

• The error message ADB5299E is updated:
  
  Original message:
  ADB5299E Unexpected error in image copy processing.
  Reason code = >rc<
  
  Updated message:
  ADB5299E
  An error occurred while processing the ADMIN UNLOAD
  statement for the image copy process. Reason code = >rc<
  Explanation
  The image copy cannot be processed because the ADMIN
  UNLOAD failed. The possible cause of failure is indicated by
  the reason code.
  Return code(s) :    8
  Reason code(s) :
     9995 The image copy database or table space was not found.
     9996 The image copy source was not found.
     9997 The image copy date or time was is wrong format.
     9999 ADMIN UNLOAD statement is incomplete or contains a
          syntax error.
  
  System Action
  Processing stops.
  User Response
  Correct the ADMIN UNLOAD statement according to the reason
  code and rerun the job.
  

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:

  UI17026 UI17027

Modules/Macros

• ADB5000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI17026

     UP14/04/16 P F404

• RB10 PSY UI17027

     UP14/04/16 P F404

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.