DB2 FOR LUW / DB2FORLUW / 970 - DB2

When there is a problem during the execution of the 
SYSPROC.GET_DBSIZE_INFO procedure, 
the current error handling may obscure the real error and return 
a misleading error SQL0493 : 
 
 Routine "<routine-name>" (specific name "<specific-name>") has 
      returned a date, time or timestamp value which is 
syntactically or 
      numerically invalid. 
 
 
A common problem is a lack of select privileges on table 
"SYSTOOLS.STMG_DBSIZE_INFO" 
This should return error SQL0551 instead.

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

Try : grant select on table SYSTOOLS.STMG_DBSIZE_INFO to user 
"username"    to see if the problem is resolved.

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

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

14.11.2013
19.01.2015
19.01.2015

9.7.FP10