PK85833: SQLCODE551 DSNXOSC err1=-100 when DOING REBIND OF DBRMS BOUND DIRECTLY WITHIN A PLAN TO PACKAGES (FOLLOWING THE APAR PK62876)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer was following the APAR PK62876
  
   PREPARATION FOR A FUTURE RELEASE OF DB2 WHERE DBRMS BOUND
    DIRECTLY WITHIN A PLAN MUST BE CONVERTED TO PACKAGES
  
  and doing rebind of PLAN where DBRMs were directly bound to
  PLAN (without package), They faced:
  
  REBIND PLAN (xxxxxx) COLLID(C_yyyyy)
  DSNX200I  -D2Y2 REBIND SQL ERROR
             USING binder-user AUTHORITY
             PLAN=(NOT APPLICABLE)
             DBRM=yyyyyy
             STATEMENT=227
             SQLCODE=-551
             SQLSTATE=42501
             TOKENS=binder-user SELECT original-package-owner.TAB1
             CSECT NAME=DSNXOSC
             RDS CODE=-100
  
  Priviledge being checked is the binder, not the OWNER, as it
  should be.
  

Local fix

• REBIND with OWNER specified
  REBIND PLAN (xxxxxx) COLLID(C_yyyyyy)
         OWNER(original-package-owner)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users who use REBIND PLAN with       *
  *                 COLLID option.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using REBIND PLAN with COLLID      *
  *                      option to convert plan with DBRMs       *
  *                      into plan with package list, DB2        *
  *                      incorrectly issues out SQLCODE -551.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When converting DBRMs bound within a plan into packages, DB2
  uses the BINDER as primary authorization ID instead of the plan
  owner, and caused sqlcode -551 being issued out incorrectly.
  

Problem conclusion

• DB2 has been fixed to use the plan owner as the authorization
  check id when converting DBRMs bound within the plan into
  packages.
  

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:

  UK49049

Modules/Macros

• DSNTBCM2 DSNTBRB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK49049

     UP09/08/21 P F908

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.