• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7982
  • Last Modified:

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.
  • 2
1 Solution
Hi Enuda,

Try rebinding the following system package:

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

Sorry, that should be:

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

EnudaAuthor Commented:
Thank you for your response. Your suggestion did solve my problem.

Again, thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now