Link to home
Start Free TrialLog in
Avatar of Enuda
Enuda

asked on

How do I resollve a [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010.

I have a simple SQL that I want to explain using UDB Control Center command editor explain feature. Regardless of what environment that I tried (system test or product or UAT), I get error
"[IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010" This error occur only when I tried to generate a visual explain of the access path. If run the SQL without asking for the e3xplain plan, the sql execute successfully. I am running DB2 UDBv8.2 fixpak 14.
How can I go about resolving this problem with control center explain functionality.
 
Avatar of ocgstyles
ocgstyles

Hi Enuda,

Try rebinding the following system package:

db2 ~/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue

Keith
ASKER CERTIFIED SOLUTION
Avatar of ocgstyles
ocgstyles

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Enuda

ASKER

ocqstyles,
Thank you for your response. Your suggestion did solve my problem.

Again, thanks