PI78500: SQL CODE = -471 ERROR ATTEMPTING TO REVOKE PRIVILEGES EVEN THOUGH GET DB2 ZPARM IS SET TO NO

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If DSNWZP or its WLM environment is not set up to run
  correctly, a user attempting to revoke privileges on panel
  ADB2RZ may encounter the following error even if they have set
  Get DB2 ZPARM to NO on panel ADB2P2:
  
  Call to stored procedure DSNWZP failed. SQL code =
  -471
   DSNT408I SQLCODE = -471, ERROR:  INVOCATION OF FUNCTION OR
  PROCEDURE
  
            SYSPROC.DSNWZP FAILED DUE TO REASON
  00E7900C
  
   DSNT418I SQLSTATE   = 55023 SQLSTATE RETURN
  CODE
  
   DSNT415I SQLERRP    = DSNX9WCA SQL PROCEDURE DETECTING
  ERROR
  
   DSNT416I SQLERRD    = 0  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  
   DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'
  X'FFFFFFFF'
  
            X'00000000'  X'00000000' SQL DIAGNOSTIC
  INFORMATION
  ----------------------------
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the IBM DB2 Administration Tool     *
  *                 for z/OS who use the ADB2R* panels.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DSNWZP is called from the ADB2R*        *
  *                      panels even though 'GET DB2 ZPARM'      *
  *                      is set to NO.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The revoke impact function attempts to call DSNWZP
  even though 'Get DB2 ZPARM' on panels ADB2P2
  'DB2 Admin Defaults' was set to NO.
  

Problem conclusion

• Problem has been resolved.
  

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

•    ADBRI00
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI48283

     UP17/06/28 P F706

• RC10 PSY UI48284

     UP17/06/28 P F706

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.