PI08596: UNLOAD SUCCESSFUL EVEN THOUGH USER DOES NOT HAVE THE SELECT PRIVILEGE ON THE TABLE TO BE UNLOADED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Although the user does not have the SELECT privilege on the
  table to be unload, the data from the table is unloaded if the
  unload is performed in native mode.
  
  This occurs if the user has the EXPLAIN privilege. In such a
  case, the same unload run in SQL mode (with DB2 FORCE option)
  fails after having issued the following messages :
  
  DSNT404I SQLCODE = 4726, WARNING:  THE STATEMENT WAS
           SUCCESSFULLY PREPARED, BUT
           IT CANNOT BE EXECUTED BECAUSE SST1 DOES NOT HAVE SELECT
  PRIVILEGE
           ON OBJECT PDBA.T_DAILY_SUMMARY BUT HAS EXPLAIN
  PRIVILEGE
  DSNT418I SQLSTATE = 0168Z SQLSTATE RETURN CODE
  DSNT415I SQLERRP  = DSNXOSC SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD  = 0  0  13599739  1166633382  0  0 SQL DIAG
           INFORMATION
  DSNT416I SQLERRD = X'00000000'  X'00000000'  X'00CF83FB'
                                                  X'458969A6'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  
  and
  
  DSNT408I SQLCODE  = -514, ERROR:  THE CURSOR C1 IS NOT
           IN A PREPARED STATE
  DSNT418I SQLSTATE = 26501 SQLSTATE RETURN CODE
  DSNT415I SQLERRP  = DSNXERT2 SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD  = -305  0  0  -1  0  0 SQL DIAGNOSTIC INFO
  DSNT416I SQLERRD  = X'FFFFFECF'  X'00000000'  X'00000000'
                                                 X'FFFFFFFF'
  INZU260I GENERATING LOAD STATEMENT FOR SELECT STARTING AT
           POS(4, 1)
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x109a007)
  
  PB12120  SQLCODE514 SQLCODE4726
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Although the user does not have the     *
  *                      SELECT privilege on the table to be     *
  *                      unload, the data from the table is      *
  *                      unloaded if the unload is performed in  *
  *                      native mode.                            *
  *                      This occurs if the user has the         *
  *                      EXPLAIN privilege. In such a case, the  *
  *                      same unload run in SQL mode (with DB2   *
  *                      FORCE option) fails after having        *
  *                      issued the following messages :         *
  *                                                              *
  *                      DSNT404I SQLCODE = 4726, WARNING:  THE  *
  *                       STATEMENT WAS SUCCESSFULLY PREPARED,   *
  *                       BUT IT CANNOT BE EXECUTED BECAUSE      *
  *                       SST1 DOES NOT HAVE SELECT PRIVILEGE    *
  *                       ON OBJECT PDBA.T_DAILY_SUMMARY BUT     *
  *                       HAS EXPLAIN PRIVILEGE                  *
  *                      DSNT418I SQLSTATE   = 0168Z SQLSTATE    *
  *                       RETURN CODE                            *
  *                      DSNT415I SQLERRP    = DSNXOSC SQL       *
  *                       PROCEDURE DETECTING ERROR              *
  *                      DSNT416I SQLERRD    = 0  0  13599739    *
  *                        1166633382  0  0 SQL DIAGNOSTIC       *
  *                               INFORMATION                    *
  *                      DSNT416I SQLERRD    = X'00000000'       *
  *                        X'00000000'  X'00CF83FB'  X'458969A6' *
  *                        X'00000000'  X'00000000' SQL          *
  *                       DIAGNOSTIC INFORMATION                 *
  *                                                              *
  *                      and                                     *
  *                                                              *
  *                      DSNT408I SQLCODE = -514, ERROR:  THE    *
  *                       CURSOR C1 IS NOT IN A PREPARED STATE   *
  *                      DSNT418I SQLSTATE   = 26501 SQLSTATE    *
  *                       RETURN CODE                            *
  *                      DSNT415I SQLERRP    = DSNXERT2 SQL      *
  *                       PROCEDURE DETECTING ERROR              *
  *                      DSNT416I SQLERRD    = -305  0  0  -1    *
  *                        0  0 SQL DIAGNOSTIC INFORMATION       *
  *                      DSNT416I SQLERRD    = X'FFFFFECF'       *
  *                        X'00000000'  X'00000000'              *
  *                        X'FFFFFFFF'                           *
  *                      INZU260I GENERATING LOAD STATEMENT FOR  *
  *                       SELECT STARTING AT POS(4, 1)           *
  *                      INZU366I UTILITY RETURN CODE 8          *
  *                       (REASON CODE 0x109a007)                *
  *                      pb 12120                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzctrlh and inzqryv8 modules were changed.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

• ž**** PE15/01/05 PTF IN ERROR. SEE APAR PI32089  FOR DESCRIPTION
  

APAR Information

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

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

  UI15725 UI15726

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UI15725

     UP14/03/08 P F403

• R420 PSY UI15726

     UP14/03/08 P F403

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.