Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2007-11-13
3
Medium Priority
?
7,875 Views
Last Modified: 2008-02-01
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
Comment
Question by:Enuda
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Expert Comment

by:ocgstyles
ID: 20277453
Hi Enuda,

Try rebinding the following system package:

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

Keith
0
 
LVL 5

Accepted Solution

by:
ocgstyles earned 500 total points
ID: 20294709
Sorry, that should be:

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

Keith
0
 

Author Comment

by:Enuda
ID: 20296421
ocqstyles,
Thank you for your response. Your suggestion did solve my problem.

Again, thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question