PM82662: SQLCODEN104 IN PANEL ADB25TU WHEN VARIABLE TLOWNER OR LDOWNER CONTAINS RESIDUAL VALUE OF PERCENT SIGN %

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS report TEMPLATE panel
  ADB25TU can fail with sqlcode -104 with error messages similar
  to the following:
  .
   SQLCODE : -104          DSNTIAR CODE : 0
   DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "%". SOME
     SYMBOLS THAT MIGHT BE LEGAL ARE: ( <IDENTIFIER> XMLTABLE
     TABLE FINAL OLD
   DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = 3  0  0  -1  1451  502 SQL DIAGNOSTIC
      INFORMATION
   DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'
      X'FFFFFFFF' X'000005AB'  X'000001F6'
      SQL DIAGNOSTIC INFORMATION
  .
  Residual variable content may come from panel ADB25 or ADB25C .
  

Local fix

• Deleting affected variable or changing ISPF PROFILE to remove
  residual variable value will avoid the reported problem.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use LISTDEF and TEMPLATE functions  *
  *                 on panel ADB25 'Utility generation using     *
  *                 LISTDEFs and TEMPLATEs'.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of DB2 Administration Tool for    *
  *                      z/OS report the TEMPLATE panel          *
  *                      ADB25TU 'Utility Template Use' will     *
  *                      fail with a SQLCODE=-104 /              *
  *                      SQLCODEN104 error message:              *
  *                                                              *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL "%".             *
  *                      SOME SYMBOLS THAT MIGHT BE              *
  *                      LEGAL ARE:                              *
  *                      >IDENTIFIER< XMLTABLE                   *
  *                         TABLE FINAL OLD                      *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      if a residual variable content is       *
  *                      retained from panels ADB25 'Utility     *
  *                      generation using LISTDEFs and           *
  *                      TEMPLATEs or ADB25C 'LISTDEF            *
  *                      Control Table'.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The SELECT statement on panel ADB25TU3 'Specify UTILITY
  TEMPLATE Usage' does not convert SCHEMA and NAME of the
  TEMPLATE control table to the delimited SQL identifier.
  

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:

  UK92579 UK92580

Modules/Macros

•    ADB25    ADB25C   ADB25L   ADB25LA  ADB25LE
  ADB25LEA ADB25LUV ADB25T   ADB25TE  ADB25TU  ADB25TU3 ADB25TU4
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK92579

     UP13/03/19 P F303

• RA20 PSY UK92580

     UP13/03/19 P F303

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.