• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7915
  • 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.
 
0
Enuda
Asked:
Enuda
  • 2
1 Solution
 
ocgstylesCommented:
Hi Enuda,

Try rebinding the following system package:

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

Keith
0
 
ocgstylesCommented:
Sorry, that should be:

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

Keith
0
 
EnudaAuthor Commented:
ocqstyles,
Thank you for your response. Your suggestion did solve my problem.

Again, thanks
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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