DB2 FOR LUW / DB2FORLUW / 970 - DB2

Running procedure call sysproc.GET_DBSIZE_INFO(?, ?, ?, 0) as a 
user other than the instance owner, may return an error because 
of missing select privileges on table SYSTOOLS.STMG_DBSIZE_INFO. 
 
This is incorrect as the only privileges required to run this 
are : 
 
    SYSMON authority 
    EXECUTE privilege on the GET_DBSIZE_INFO procedure 
 
This is because the select on the SYSTOOLS.STMG_DBSIZE_INFO 
table is executed as dynamic sql within the admin stored 
procedure and the stored procedure has not been created with the 
DYNAMICRULES BIND option.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to V9.7 Fix Pack 10 or higher    * 
****************************************************************

This can be resolved in 2 ways, either grant select privileges 
on SYSTOOLS.STMG_DBSIZE_INFO to the user executing the procedure 
or alternatively go to $HOME/sqllib/bnd  and run : 
db2 bind st_admin.bnd dynamicrules bind

This problem was first fixed in V9.7 Fix Pack 10

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.11.2013
05.01.2015
05.01.2015

9.7.FP10