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

Obtain the fix for this APAR.

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