Outstanding!
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Mani Bhaskar
[mailto:db2udbdba-ezmlmshield-x41483234.[Email address protected]
Sent: Tuesday, April 22, 2008 6:26 AM
To: LazyDBA Discussion
Subject: Re: db2advis is not working......
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.
---------------------------------------------------------------------
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