PI18883: INZU020E DSNT408I SQLCODE = -551 USERID DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT SYSIBM.SYSKEYS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Regardless of the setting for ACTLGUSR, the unload fails with
  completion code 8 after having issued messages as follows:
  
  DSNT408I SQLCODE = -551, ERROR:  userid DOES NOT HAVE THE
  PRIVILEGE TO PERFORM
           OPERATION SELECT ON OBJECT SYSIBM.SYSKEYS
  DSNT418I SQLSTATE   = 42501 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXOSC SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -100  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF9C'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  INZU020E ERROR WHILE RETRIEVING TABLE SPACE INFO FROM THE
  CATALOG
  
  where userid is the name of the user that submitted the unload
  job.
  
  This occurs when:
  - The user that submitted the unload job does not have
    the SELECT privilege on the DB2 catalog tables
  - SQLACCES is set to MINIMAL
  - The direct access to the catalog table spaces failed
  
  PB12354 MSGINZU020E MSGINZU020 INZU020E INZU020 SQLCODE551
  DSNT408
  

Local fix

• set SQLACCES to YES
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Regardless of the setting for ACTLGUSR, *
  *                      the unload fails with completion code   *
  *                      8 after having issued messages as       *
  *                      follows:                                *
  *                      DSNT408I SQLCODE = -551, ERROR:         *
  *                        userid DOES NOT HAVE THE PRIVILEGE    *
  *                        TO PERFORM OPERATION SELECT ON        *
  *                        OBJECT SYSIBM.SYSKEYS                 *
  *                      DSNT418I SQLSTATE   = 42501 SQLSTATE    *
  *                        RETURN CODE                           *
  *                      DSNT415I SQLERRP    = DSNXOSC SQL       *
  *                       PROCEDURE DETECTING ERROR              *
  *                      DSNT416I SQLERRD    = -100  0  0  -1    *
  *                        0  0 SQL DIAGNOSTIC INFORMATION       *
  *                      DSNT416I SQLERRD    = X'FFFFFF9C'       *
  *                        X'00000000'  X'00000000'  X'FFFFFFFF' *
  *                        X'00000000'  X'00000000' SQL          *
  *                        DIAGNOSTIC INFORMATION                *
  *                      INZU020E ERROR WHILE RETRIEVING TABLE   *
  *                       SPACE INFO FROM THE CATALOG            *
  *                      where userid is the name of the user    *
  *                      that submitted the unload job.          *
  *                      This occurs when:                       *
  *                      - The user that submitted the unload    *
  *                       job does not have the SELECT           *
  *                       privilege on the DB2 catalog tables    *
  *                      - SQLACCES is set to MINIMAL            *
  *                      - The direct access to the catalog      *
  *                       table spaces failed                    *
  *                      PB 12354                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzcat module was changed.
  

Problem conclusion

• APPLY the PTF.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI19067

     UP14/06/26 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.