PI15996: ADB5014E AN RRS ERROR OCCURED. DIAGNOSTIC INFO: RSC= 00F30058.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT function ends with
  a message:
  ADB5044I *** INPUT STATEMENT:.
     DROP VIEW >schema<.>view_name<;.
  ADB5014E An RRS error occured. Diagnostic info: Function= AUTH
  SIGNON.
  ADB5014E An RRS error occured. Diagnostic info: RTC= 00000008.
  ADB5014E An RRS error occured. Diagnostic info: RSC= 00F30058.
  ADB5185E The run is ending due to errors..
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Authorization-switching.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The description of Authorization-       *
  *                      switching was not clear enough to       *
  *                      give users a solid understanding        *
  *                      of its functionality.                   *
  *                                                              *
  *                      RRS Auth-SIGNON failed with the         *
  *                      following error due to an improper      *
  *                      parameter:                              *
  *                                                              *
  *                      ADB5044I *** INPUT STATEMENT:.          *
  *                         DROP VIEW >schema<.>view_name<;      *
  *                      ADB5014E An RRS error occured.          *
  *                      Diagnostic info: Function= AUTH         *
  *                      SIGNON.                                 *
  *                      ADB5014E An RRS error occured.          *
  *                      Diagnostic info: RTC= 00000008.         *
  *                      ADB5014E An RRS error occured.          *
  *                      Diagnostic info: RSC= 00F30058.         *
  *                      ADB5185E The run is ending due to       *
  *                                                              *
  *                      The submitter's ID was set as a         *
  *                      secondary Auth_ID.                      *
  *                                                              *
  *                      SET CURRENT SCHEMA was not              *
  *                      handled properly and results in the     *
  *                      generation of an unrecognizable         *
  *                      SQL statement.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The description of Authorization-switching does not provide
  a solid understanding of its functionality to the user.
  
  RRS Auth-SIGNON failed due to an improper parameter.
  The submitter's ID was set as a secondary Auth_ID.
  
  SET CURRENT SCHEMA was not handled properly and results in
  the generation of an unrecognizable SQL statement.
  

Problem conclusion

• Problem has been resolved.
  
  The DB2 Administration for z/OS User's Guide and Reference
  Version 11, Release 1, Chapter 13 - Changing DB2 Objects,
  section "Using authorization switching" has been updated.
  
  If you use the authorization switch with DB2 sample sign on
  exit, you must complete one of the following steps:
  
  - Run the job by using an authorization switch ID that has
    SYSADM authority or that is connected to a group that has
    SYSADM authority.
  - Define the owner of the objects as a RACF group and then run
    the job by using an authorization switch ID that is connected
    to the group ID.
  
  For either of the preceding steps, define the authorization
  switch ID as a RACF user ID without a known password and
  with a password that never expires.
  

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:

Modules/Macros

•    ADBTEPA  ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI19190

     UP14/06/28 P F406

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.