I had the happen a few times too. If I remember right there is a stored
procedure that needs to be dropped and recreated. Sorry, I can't
remember what the procedure is.
Jeremy Schleicher
ERP Database Administrator
Florida State University
-----Original Message-----
From: Mani Bhaskar
[mailto:db2udbdba-ezmlmshield-x16399036.[Email address protected]
Sent: Friday, April 04, 2008 11:31 AM
To: LazyDBA Discussion
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.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page