I've got the solution for this problem.



Try using db2rbind <DBNAME> all;



This has solved the problem



Regards,



Bhaskar Mani



________________________________

From: Mani, Bhaskar
Sent: Friday, April 04, 2008 9:01 PM
To: '[Email address protected]
Subject: db2advis is not working......



I'm trying to use db2advis and it does not work. The errors received are
as follows:

Using user id as default schema name. Use -n option to specify schema
CALL SYSPROC.GET_DBSIZE_INFO failed (workaround - use -l)

SQL1042C An unexpected system error occurred. SQLSTATE=58004

*************************************
* CONTENTS OF SQLCA *
*************************************

SQLCABC = 136
SQLCODE = -1042
SQLERRMC =
SQLERRP = SQLERFED
sqlerrd[0] = 0
sqlerrd[1] = 0
sqlerrd[2] = 0
sqlerrd[3] = 0
sqlerrd[4] = 0
sqlerrd[5] = 0
SQLWARN =
SQLSTATE = 58004
Critical SQLCODE. Exiting db2advis ...
The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-1042]

1) I tried dropping the explain and advise tables then also its not
working

2) I tried to bind the packages then also its not working

3) I tired to give execute permission to GET_DBSIZE_INFO routine
then also its not working.


Can any only help on this. Thanks in advance.



Regards,



Bhaskar Mani

eBBS DB Dev Team









This email is confidential. If you are not the addressee tell the sender immediately and destroy this email
without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay,
interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for
damage caused by this email and may monitor email traffic.


DB2 & UDB email list listserv db2-l LazyDBA home page