PM98049: SUPPORT THE PROGAUTH BIND IN DB2 11 DB2I AND FIX BUGS IN DB2 10

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This APAR addresses the following problems in the DB2
    Interactive (DB2I) panels in DB2 10 and 11
    (1) DB2 11: DB2I does not support the new PROGAUTH for BIND PLAN
    (2) DB2 10 and 11: DB2I outputs the following messages and
        terminates When binding a package through the Program
        Preparation option:
          IKJ56479I COMMAND BPKGAPRE NOT FOUND OR REXX IDENTIFIER IS
                    MISSING+
          IKJ56479I SUPPLY '/* REXX */' AS THE FIRST RECORD TO
    (3) DB2 10 and 11: JCL generated by the DB2I Program Preparation
        option terminates with return code 8 and the following
        message from the BIND PLAN phase:
           IKJ56702I INVALID PACKAGE NAME, )
    

Local fix

  • For problem (2), edit SDSNCLST(DSNEBC02), locate the line
    that contains the string 'BPKGIMME,' and change it to
    'BPKGIMME, -'.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the PROGRAM PREPARATION and     *
    *                 BIND/REBIND/FREE options of the DB2          *
    *                 Interactive (DB2I) facility in DB2 10 for    *
    *                 z/OS and DB2 11 for z/OS are affected by     *
    *                 this change.                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR addresses the following       *
    *                      errors in the PROGRAM PREPARATION       *
    *                      option of DB2I in DB2 10 and 11:(       *
    *                      (1) When BIND PACKAGE or BIND PLAN (or  *
    *                          both) is selected, DB2I displays    *
    *                          the following messages and halts:   *
    *                                                              *
    *                          IKJ56479I COMMAND BPKGAPRE NOT      *
    *                                    FOUND OR REXX IDENTIFIER  *
    *                                    IS MISSING+               *
    *                          IKJ56479I SUPPLY '/ * REXX * /' AS  *
    *                                    THE FIRST RECORD TO       *
    *                                    EXECUTE AS A REXX EXEC    *
    *                                    OR, FOR AN EXPLICIT EXEC, *
    *                                    SUPPLY THE EXEC KEYWORD   *
    *                                    ON THE EXEC COMMAND       *
    *                      (2) When PREPARATION ENVIRONMENT is set *
    *                          to EDITJCL and BIND PLAN Perform    *
    *                          Function is set to Y, the generated *
    *                          JCL job terminates with return code *
    *                          8 and the following message:        *
    *                                                              *
    *                          IKJ56702I INVALID PACKAGE NAME, )   *
    *                                                              *
    *                      In DB2 11 only, this APAR also provides *
    *                      support in the BIND/REBIND/FREE option  *
    *                      of DB2I for the PROGAUTH option of BIND *
    *                      PLAN and REBIND PLAN.                   *
    ****************************************************************
    * RECOMMENDATION: Apply the fixing PTF for this APAR.          *
    ****************************************************************
    The DB2I facility provides a convenient DB2 interface for
    running ad-hoc SQL queries (SPUFI), generating host language
    data structures for tables and views (DCLGEN), preparing and
    executing host applications (PROGRAM PREPARATION and RUN),
    managing packages and plans (BIND/REBIND/FREE), processing
    commands (DB2 COMMANDS), and running utilities (UTILITIES).
    
    Currently, in DB2 10 and 11, the PROGRAM PREPARATION option
    has two bugs as noted in the Problem Description section.
    
    In DB2 11 only, the BIND/REBIND/FREE option does not support
    PROGAUTH, a new option of the BIND PLAN and REBIND PLAN
    commands.  For more information about PROGAUTH, see the DB2 11
    for z/OS Command Reference.
    

Problem conclusion

  • In response, this APAR modifies DB2I:
      * In DB2 10 and 11, the PROGRAM PREPARATION option is fixed to
        prevent the two errors noted in the Problem Description
        section.
      * In DB2 11 only, the BIND/REBIND/FREE option adds support
        for the PROGAUTH option of BIND PLAN.
        - On panel DSNEBP10 (DEFAULTS FOR BIND PLAN), enter DISABLE
          or ENABLE in the new PROGRAM AUTHORIZATION field to
          specify the PROGAUTH option for BIND PLAN. Or enter blanks
          to prevent the PROGAUTH option from being included in the
          generated BIND PLAN statement.
        - On panel DSNEBP11 (DEFAULTS FOR REBIND PLAN), enter
          DISABLE or ENABLE in the new PROGRAM AUTHORIZATION field
          to specify the PROGAUTH option for REBIND PLAN.  Or enter
          blanks to prevent the PROGAUTH option from being included
          in the generated REBIND PLAN statement.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM98049

  • 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

    2013-09-29

  • Closed date

    2014-01-28

  • Last modified date

    2014-03-03

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

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

    UI14598 UI14599 UI14600 UI14601

Modules/Macros

  •    DSNEBC02 DSNEBC03 DSNEBC11 DSNEBC13 DSNEBP10
    DSNEBP11 DSNEPC01 DSNESKL1 DSNH     DSN0BP10 DSN0BP11
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI14598

       UP14/02/13 P F402

  • RB10 PSY UI14599

       UP14/02/13 P F402

  • RB11 PSY UI14600

       UP14/02/13 P F402

  • RB14 PSY UI14601

       UP14/02/13 P F402

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 #:

PM98049

Modified date:

2014-03-03

Translate my page

Machine Translation

Content navigation