IBM Support

PM49142: LARGE NUMBER OF BIND OR REBIND COMMANDS ( 1000+ ) RESULTS IN NO JCL AND NO MESSAGES MULTIVOLUME ZTEMPN EXEC ADB2W1

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Administration Tool for z/OS does not provide any
    error messages to indicate that the ZTEMPN dataset used to hold
    JCL for BIND and REBIND commands was allocated onto a
    multi-volume dataset and the LMINIT command in EXEC(ADB2W1)
    had failed.
    
    Customers issuing the BIND or REBIND command from panel ADB21K
    'Packages' will see the panel ADB2PST@ 'Statement Execution
    Prompt' warning customers "DB2 Admin is about to execute
    multiple statements. The number of statements exceeds 20, which
    is too large to be executed immediately." if they then select
    option '1 - Create a batch job with the statements' they
    will eventually return to panel ADB21K 'Packages' with no
    messages.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS who use the BIND or REBIND command on   *
    *                 panel ADB21K 'Packages' to bind or rebind    *
    *                 all packages in batch when there are more    *
    *                 than 20 packages in the list, and choose     *
    *                 Option '1 - Create a batch job with the      *
    *                 statements' on panel ADB2PST@ 'Statement     *
    *                 Execution Prompt'.                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
    *                      when issuing BIND or REBIND command     *
    *                      on panel ADB21K to bind or rebind more  *
    *                      than 20 packages, and choose option 1   *
    *                      on panel ADB2PST@ to create a batch     *
    *                      job with the statements, panel ADB2UE   *
    *                      'Edit Generated JCL' does not show as   *
    *                      expected.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    In DB2 Administration Tool for z/OS, when issuing the BIND or
    REBIND command on panel ADB21K to bind or rebind more than 20
    packages, and choose Option 1 on panel ADB2PST@ to create
    a batch job with the statements, panel ADB2UE does not show
    as expected, due to an RC=8 error when invoking the ISPF
    service LMINIT if it is used against a multi-volume dataset
    by ddname.
    

Problem conclusion

  • Program has been updated to invoke the DB2 Administration Tool
    error panel ADB2ER 'ISPF Dialog Error' when experiencing the
    ISPF service LMINIT error. Messages shows as below:
    
    Function : ADB2W1, LINE 3518: LMINIT DDNAME(MULTI)
    DATAID(DATAID)
    Retcode  : 8
    Zerrmsg  : ISRZ002
    Zerrsm   : Invalid data set
    Zerrlm   : Multivolume data sets are not supported by
    LMINIT by DDNAME, or when the VOLUME parameter
    is used.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM49142

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    720

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-30

  • Closed date

    2012-02-13

  • Last modified date

    2012-03-01

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

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

    UK76127 UK76128

Modules/Macros

  •    ADB2W1
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK76127

       UP12/02/15 P F202

  • R720 PSY UK76128

       UP12/02/15 P F202

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 March 2012