PI55587: DB2 ADMINISTRATION TOOL CAT NAV TO PANELs ADB21(T,S,D..) MAY FAIL WITH MSGIEC130I IEC130I DD STATEMENT MISSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool Cat Nav to Panels ADB21(T,S,D..)
  may fail with msgIEC130I IEC130I DD STATEMENT MISSING
  when the product is invoked with CUST(N) parameter
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for            *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following is fixed:                 *
  *                                                              *
  *                      1. When specifying parameter            *
  *                         CUST(N) to invoke CLIST ADBL         *
  *                         or specifying CUST(Y) but there      *
  *                         are no parameters specified under    *
  *                         the DB2 Libraries on panel           *
  *                         CCQPDB2 - 'DB2 Parameters:           *
  *                         DB2 Admin Tool' in the previous      *
  *                         IBM Tools Customizer for z/OS        *
  *                         process, the following messages      *
  *                         and ISPF Dialog Error will occur     *
  *                         when using the Catalog Navigation    *
  *                         function after invoking CLIST ADBL:  *
  *                                                              *
  *                      IEC130I  :   ::: DD STATEMENT MISSING   *
  *                      IEC130I  :   ::: DD STATEMENT MISSING   *
  *                      IEC130I  :   ::: DD STATEMENT MISSING   *
  *                      IEC130I  :   ::: DD STATEMENT MISSING   *
  *                                                              *
  *                      ADB2ER in ------ISPF Dialog Error ----  *
  *                      Command ===>                            *
  *                      Max no of rows reached                  *
  *                      .                                       *
  *                      .                                       *
  *                      Function : TBDISPL &$TABLE              *
  *                                       PANEL(&CPANEL)         *
  *                                       CSRROW(&$CSRROW)       *
  *                                       POSITION( *            *
  *                                      $CSRROW) ROWID($ROWID)  *
  *                                      AUTOSEL(NO)             *
  *                        Retcode  : 20                         *
  *                                                              *
  *                       Zerrmsg  : ISPP133                     *
  *                       Zerrsm   : Panel 'ADB21T' error        *
  *                       Zerrlm   : Invalid statement found     *
  *                                  within /INIT, /REINIT, or   *
  *                                  /PROC section.              *
  *                                                              *
  *                      2. There is a typo 'AD2BPLIB' in the    *
  *                         ADBEDIAG report. It should be        *
  *                         ADB2PLIB.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following is fixed:
  
  1. When specifying parameter CUST(N) to invoke CLIST ADBL or
     specifying CUST(Y) but there are no parameters specified
     under the DB2 Libraries on panel CCQPDB2 - 'DB2 Parameters:
     DB2 Admin Tool' in the previous IBM Tools Customizer for
     z/OS process, messages 'IEC130I : :::  DD STATEMENT MISSING'
     and an ISPF Dialog Error will occur when using the Catalog
     Navigation function after invoking CLIST ADBL.
  
  2. There is a typo 'AD2BPLIB' in the ADBEDIAG report.
     It should be ADB2PLIB.
  

Problem conclusion

• Problems have been resolved.
  
  1. Installation/Customization setup is a requirement to ensure
     values from the General Customization table ADBTPARM
     generated by IBM Tools Customizer for z/OS are utilized by
     DB2 Admin Tool.  Hence, the parameter setting CUST(Y) must
     not be changed nor disabled when invoking CLIST ADBL.  If
     an external EXEC or CLIST attempts to override/change the
     setting to CUST(N), it will be ignored to ensure
     Customization is used due to requirements.
  
  2. ADB2PLIB instead of AD2BPLIB in seen in the ADBEDIAG
     report.
  

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:

  UI36348

Modules/Macros

•    ADBEDIAG ADBL     ADBR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI36348

     UP16/03/24 P F603

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.