PM51314: SQLCODEN104 IF SAMPLE JOB ADBPRHIS IS RUN ON DB2 RELEASE LOWER THAN 10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS apar PM36033 introduced new
  function implementation for support of DB2 v10. Included in the
  PM36033 ptf was a new sample job member, ADBPRHIS , which is
  intended to be run only in the DB2 v10 environment.
  .
  Running sample job ADBPRHIS in DB2 v9 or lower will result in
  errors running the following statement:
   CREATE TABLE ADBTABLES_PROF_HIST
  with error messages similar to the following:
  .
  SQLERROR ON   CREATE    COMMAND, PREPARE   FUNCTION
   RESULT OF SQL STATEMENT:
   DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "INLINE". SOME
  SYMBOLS
  THAT MIGHT BE LEGAL ARE: CHECK UNIQUE PRIMARY CCSID
            AS UPDATE IMPLICITLY CONSTRAINT
  .
  Additional symptoms: sqlcode104 msgdsnt408i
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the sample job member ADBPRHIS  *
  *                 to create DB2 profile history objects.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      APAR PM36033 introduced a new function  *
  *                      implementation for suport of DB2 10.    *
  *                      In the PM36033 PTF, there was a new     *
  *                      sample job member ADBPRHIS, which is    *
  *                      intended to be run on the DB2 10 New    *
  *                      Function Mode environment.              *
  *                                                              *
  *                      Running ADBPRHIS on DB2 9 or lower      *
  *                      will result in an error at the          *
  *                      following statement:                    *
  *                                                              *
  *                      CREATE TABLE ADBTABLES_PROF_HIST        *
  *                                                              *
  *                      A SQLCODE==104 / SQLCODEN104 error      *
  *                      message is displayed:                   *
  *                                                              *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL "INLINE". SOME           *
  *                      SYMBOLS THAT MIGHT BE LEGAL             *
  *                      ARE: CHECK UNIQUE PRIMARY               *
  *                      CCSID AS UPDATE IMPLICITLY              *
  *                      CONSTRAINT                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS delivered a sample job
  member ADBPRHIS for DB2 10 support.  Running this job on DB2 9
  or lower will result in an SQLCODE=-104 / SQLCODEN104 error.
  The sample job documentation needs to be enhanced to state
  ADBPRHIS should be run on DB2 10 New Function Mode or higher.
  

Problem conclusion

• The sample job member ADBPRHIS has been modified to state it
  is to be run on DB2 10 New Function Mode or higher.
  

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:

  UK75307

Modules/Macros

•    ADBPRHIS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK75307

     UP12/01/12 P F201

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.