469,609 Members | 1,687 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

DB2ADVIS Error: SQL0444N Routine "*IZE_INFO" (specific name "GET_DBSIZE_INFO")

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]
Oct 19 '06 #1
0 1959

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by yogesh | last post: by
12 posts views Thread by Jean-Marc Blaise | last post: by
3 posts views Thread by siva | last post: by
reply views Thread by suniltcs | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.