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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM82662

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-12

  • Closed date

    2013-03-15

  • Last modified date

    2013-04-02

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Tools for z/OS
DB2 Administration Tool

Software version:

10.2.0

Reference #:

PM82662

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation