PI09723: DSNTRVFY RECEIVES RC=8 SQLCODE -443 FOR ADMIN_TASK_LIST WHEN DB2 ZPARM FOR ADMTPROC IS SET TO NULL

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • WLM stored procedure verification program DSNTRVFY fails with
    RC=8 and SQLCODE -443 when attempting to validate stored
    procecudures for ADMT when it is not installed. ZPARM ADMTPROC
    is set to NULL but DSNTRVFY validates the stored procedure
    and abends as described.
    .
    DSNT031I DSNTRVFY VALIDATION FOR DSNADM.ADMIN_TASK_LIST FAILED
    DSNT028I DSNTFVFY - WLM ENVIRONMENT DETAILS
                 NAME       DB08WLMG
                 PROC       DB08WLMG
                 STATE      AVAILABLE
                 NUMTCB     40
    DSNT034I DSNTRVFY - AN ERROR WAS ENCOUNTERED DURING CALL TO
    ROUTINE,
    SQLCODE = -
     DSNT408I SQLCODE = -443, ERROR: ROUTINE ADMIN_TASK_LIST
    (SPECIFIC NAME
    ADMIN_TA
    TIC TEXT DSNA653I  DSNADMTL CANNOT FIND ZPARM ADMTPROC
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DSNTRVFY, the validation tool   *
    *                 for DB2-supplied stored procedures and       *
    *                 user-defined functions (UDFs) in DB2 10      *
    *                 for z/OS and DB2 11 for z/OS, are affected   *
    *                 by this change.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: One or both of the following symptoms   *
    *                      occurs when running job DSNTIJRV, job   *
    *                      step DSNTRVFY (program DSNTRVFY):       *
    *                      (1) DSNTRVFY terminates with return     *
    *                          code 8 and these messages when      *
    *                          validating the stored procedures    *
    *                          for the DB2 administrative task     *
    *                          scheduler:                          *
    *                            DSNT031I DSNTRVFY VALIDATION FOR  *
    *                                 SYSPROC.ADMIN_TASK_xxxxxxxx  *
    *                                 FAILED                       *
    *                            DSNT034I DSNTRVFY - AN ERROR WAS  *
    *                                 ENCOUNTERED DURING CALL TO   *
    *                                 ROUTINE, ERROR = DSNA653I    *
    *                                 DSNADMxx CANNOT FIND ZPARM   *
    *                                 ADMTPROC                     *
    *                      (2) DSNTRVFY terminates with return     *
    *                          code 8 and these messages when      *
    *                          validating the user-defined         *
    *                          functions (UDFs) for the DB2        *
    *                          administrative task scheduler:      *
    *                            DSNT031I DSNTRVFY VALIDATION FOR  *
    *                                 DSNADM.ADMIN_TASK_xxxxxxxx   *
    *                                 FAILED                       *
    *                            DSNT034I DSNTRVFY - AN ERROR WAS  *
    *                                 ENCOUNTERED DURING CALL TO   *
    *                                 ROUTINE, SQLCODE = -443      *
    *                            DSNT408I SQLCODE = -443, ERROR:   *
    *                                 ROUTINE ADMIN_TASK_xxxxxxxx  *
    *                                 (SPECIFIC NAME ADMIN_TASK_-  *
    *                                 xxxxxxxx) HAS RETURNED AN    *
    *                                 ERROR SQLSTATE WITH          *
    *                                 DIAGNOSTIC TEXT DSNA653I     *
    *                                 DSNADMxx CANNOT FIND ZPARM   *
    *                                 ADMTPROC                     *
    ****************************************************************
    * RECOMMENDATION: Apply the fixing PTF for this APAR.          *
    ****************************************************************
    Job DSNTIJRV executes program DSNTRVFY which can be used to
    validate installation and configuration of DB2-supplied stored
    procedures and user-defined functions (UDFs), including those
    for the DB2 administrative task scheduler.  Currently, if the
    administrative task scheduler is disabled, that is if DB2
    subsystem parameter DSN6SPRM.ADMTPROC is not set, DSNTRVFY
    fails validation of all administrative task scheduler routines
    and outputs the messages noted in the problem description of
    this APAR.  However, the validation should not fail because the
    use of the administrative task scheduler is optional.
    

Problem conclusion

  • In response, DSNTRVFY is modified so that, when the DB2
    administrative task scheduler is disabled, validation of the
    administrative task scheduler routines will now set return code
    4 and output these messages:
      DSNT029I DSNTRVFY VALIDATION FOR schema.ADMIN_TASK_xxxxxx
               COMPLETED WITH WARNINGS
      DSNT018I DSNTRVFY - A WARNING WAS ENCOUNTERED DURING CALL
               TO ROUTINE, WARNING = DSNA653I  DSNADMxx CANNOT
               FIND ZPARM ADMTPROC
    unless actual errors are detected for those stored procedures.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI09723

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-17

  • Closed date

    2014-02-22

  • Last modified date

    2014-04-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI15380 UI15381

Modules/Macros

  •    DSN@RVFY DSNTRVFY
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI15380

       UP14/03/11 P F403

  • RB10 PSY UI15381

       UP14/03/11 P F403

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 for z/OS

Software version:

A10

Reference #:

PI09723

Modified date:

2014-04-02

Translate my page

Machine Translation

Content navigation