PM76058: DB2 ADMINISTRATION TOOL FOR Z/OS GEN FUNCTION PASSES INCORRECT INFORMATION ABOUT DB2 MODE IN THE TARGET VERSION FILE HEADER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS GEN function passes incorrect
  information about DB2 mode in the target version file header.
  .
  Based on this information Object Comparison Tool for z/OS
  assumes that the target system
  is DB2 v10 new function mode and generates SQL statement with
  new syntax from DB2 v10 NFM
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare a source object in local    *
  *                 DB2 catalog on DB2 9 New Function Mode (NFM) *
  *                 to a target object in a remote DB catalog    *
  *                 on DB2 10 Conversion Mode (CM9).             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN function passes incorrect           *
  *                      information about the DB2 release       *
  *                      in the target VERSION file header.      *
  *                                                              *
  *                      Based on this information Compare       *
  *                      assumes that the target system is       *
  *                      a DB2 10 New Function Mode (NFM)        *
  *                      subsystem and generates a SQL           *
  *                      statement with syntax from DB2 10 NFM.  *
  *                      The APPLY job's ALTER statement fails   *
  *                      with a SQLCODE=-104 / SQLCODEN104:      *
  *                                                              *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL "TIMESTAMP". SOME        *
  *                      SYMBOLS THAT MIGHT BE LEGAL ARE:        *
  *                      FLOAT, DEC(IMAL), NUMERIC, DECFLOAT,    *
  *                      CHAR(ACTER), VARCHAR, G                 *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The program fails to set the correct DB2 release information
  based on the target remote DB2 subsystem in the header of the
  VERSION file.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK90390 UK90391

Modules/Macros

•    ADB2RE   ADB2REE  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90390

     UP12/12/19 P F212

• RA20 PSY UK90391

     UP12/12/19 P F212

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.