IBM Support

PM94690: SQLCODE-551 AND RC8 DURING REORG TABLESPACE DURING IMPLICIT MAPPING TABLE CREATION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQLCODE-551 and RC8 during REORG TABLESPACE during implicit
    mapping table creation
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users of REORG           *
    *                 TABLESPACE SHRLEVEL CHANGE utility           *
    ****************************************************************
    * PROBLEM DESCRIPTION: REORG TABLESPACE SHRLEVEL CHANGE failed *
    *                      with SQLCODE-551 due to authorization   *
    *                      failure on implicit mapping table       *
    *                      creation                                *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    User ran a REORG TABLESPACE SHRLEVEL CHANGE utility which
    performed implicit mapping object creation.  The utility failed
    with SQLCODE-551 due to the primary authorization id executing
    the REORG utility did not have the security privileges required
    to create the implicit mapping table objects.  The utility
    terminated with return code 8 as a result.
    
    It is also worth noting that the primary authorization ID
    belongs to a secondary RACF group that does have the required
    privileges to implicitly create the mapping objects, but REORG
    does not perform secondary authorization ID checkings.
    
    To address the aforementioned problem, REORG logic has been
    enhanced to make use of the install SYSADM IDs stored in the
    zParm as the primary authorization ID to implicitly create the
    mapping objects.  These IDs are stored in zParm SYSTEM ADMIN 1
    and SYSTEM ADMIN 2.
    

Problem conclusion

  • Code has been modified for REORG to use the install SYSADM
    authorization ID as indicated in the zParm for implicit mapping
    object creation.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM94690

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-07

  • Closed date

    2013-09-18

  • Last modified date

    2013-11-04

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

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

    UK97661

Modules/Macros

  • DSNURMPC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UK97661

       UP13/10/03 P F310

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":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 November 2013