1
Have 2 databases under the same db2 udb instance (aix 5.3.0.0, db2 udb V8.1, fixpak 9).
Able to run the db2advis command successfully against one database. On the other database, always receive the following error. Any ideas/info would be greatly appreciated. Thanks!
Using user id as default schema name. Use -n option to specify schema
CALL SYSPROC.GET_DBSIZE_INFO failed (workaround - use -l)
SQL0444N Routine "*IZE_INFO" (specific name "GET_DBSIZE_INFO") is implemented
with code in library or path "...sqllib/function/db2stmg", function
"get_dbsize_info" which cannot be accessed. Reason
*************************************
* CONTENTS OF SQLCA *
*************************************
SQLCABC = 136
SQLCODE = -444
SQLERRMC = *IZE_INFO▒GET_DBSIZE_INFO▒...sqllib/function/db2stmg▒get_dbsize_info▒4
SQLERRP = SQLERLIB
sqlerrd[0] = 0
sqlerrd[1] = 0
sqlerrd[2] = 0
sqlerrd[3] = 0
sqlerrd[4] = 0
sqlerrd[5] = 0
SQLWARN =
SQLSTATE = 42724
Critical SQLCODE. Exiting db2advis ...
The insert into the ADVISE_INSTANCE table has failed.
0 solutions were evaluated by the advisor
exiting with error code [-444]
