By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,827 Members | 813 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,827 IT Pros & Developers. It's quick & easy.

Control Center - current query opt error

P: n/a
Helpful folks,

I have recently migrated our test server, which runs Win NT 4, from
V7.2 FP11 to V8.1.3. Just about everything works wondefully, except I
am having major problems getting the previously defined federated
servers/nicknames to work. But I will start a different thread about
that problem. I thought I'd ask about the less critical problem first.
It deals with the Control Center and the following error:

[IBM][CLI Driver][DB2/NT] SQL0713N The replacement value for
"CURRENT QUERY OPTIMIZATION" is invalid. SQLSTATE=42815

{SQLDriverConnect}

Explanation:

Either the value specified in the SET <special-register>
statement is not a valid value of the indicated special register,
or the value specified is NULL as a result of an indicator
variable.

The statement cannot be executed.

User Response:

Correct the replacement value and/or any indicator variables.
See the SQL Reference for an explanation of the valid values of
each special register.

sqlcode : -713

sqlstate : 42815
The sequence of actions, all done locally on the server, taken to
produce this error are as follows:

1) Open CC and connect to any of the 6 DB's defined on this instance,
say DBx.
2) Browsing any objects (tables, views, etc.) works correctly with no
errors
3) Connect to any other DB by clicking on the name in CC, say DBy
4) Trying to open or browse any of the objects related to DBy,
produces an error dialog box containing the above error.

Reversing the sequence of which DB I access first produces the same
problem. That is, no matter which DB I access first (after opening
CC), I am able to interact with, with no problem. Any subsequent
access to any other DB produces the error.

An additional, although perhaps unrelated, symptom is that when I
interact with the first DB successfully, if I choose the Federated
Objects\DRDA\Servers branch of the tree, the little gears spin
forever, but never come back to tell me that there are no servers
defined, which is the case.
Every DB has the following entry in its config:

Default query optimization class (DFT_QUERYOPT) = 5

The db2cli.ini file on the server contains the following parameter for
every database entry:
DB2OPTIMIZATION=5

I had thought there was a DBM config parameter for query optimization,
but I can't seem to see any.
Also, when I submit certain commands (like Create Server), from a
command window on the server I get the above error also. Invoking the
"SET CURRENT QUERY OPTIMIZATION 5" command then allows me to get past
this error, but only for the life of the command window session.

It seems as though some global register ot registry entry is missing,
but I have no idea how to permanently set it.

Any feedback or clues would be greatly appreciated.

Sean
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Has no one encountered this problem or know the solution? This makes
Control Center completly unusable for me. I was hoping it was a fairly
common and simple config parameter of some sort, that I was missing.
No insights?

Sean
db*****@yahoo.com (Sean C.) wrote in message news:<2f**************************@posting.google. com>...
Helpful folks,

I have recently migrated our test server, which runs Win NT 4, from
V7.2 FP11 to V8.1.3. Just about everything works wondefully, except I
am having major problems getting the previously defined federated
servers/nicknames to work. But I will start a different thread about
that problem. I thought I'd ask about the less critical problem first.
It deals with the Control Center and the following error:

[IBM][CLI Driver][DB2/NT] SQL0713N The replacement value for
"CURRENT QUERY OPTIMIZATION" is invalid. SQLSTATE=42815

{SQLDriverConnect}

Explanation:

Either the value specified in the SET <special-register>
statement is not a valid value of the indicated special register,
or the value specified is NULL as a result of an indicator
variable.

The statement cannot be executed.

User Response:

Correct the replacement value and/or any indicator variables.
See the SQL Reference for an explanation of the valid values of
each special register.

sqlcode : -713

sqlstate : 42815
The sequence of actions, all done locally on the server, taken to
produce this error are as follows:

1) Open CC and connect to any of the 6 DB's defined on this instance,
say DBx.
2) Browsing any objects (tables, views, etc.) works correctly with no
errors
3) Connect to any other DB by clicking on the name in CC, say DBy
4) Trying to open or browse any of the objects related to DBy,
produces an error dialog box containing the above error.

Reversing the sequence of which DB I access first produces the same
problem. That is, no matter which DB I access first (after opening
CC), I am able to interact with, with no problem. Any subsequent
access to any other DB produces the error.

An additional, although perhaps unrelated, symptom is that when I
interact with the first DB successfully, if I choose the Federated
Objects\DRDA\Servers branch of the tree, the little gears spin
forever, but never come back to tell me that there are no servers
defined, which is the case.
Every DB has the following entry in its config:

Default query optimization class (DFT_QUERYOPT) = 5

The db2cli.ini file on the server contains the following parameter for
every database entry:
DB2OPTIMIZATION=5

I had thought there was a DBM config parameter for query optimization,
but I can't seem to see any.
Also, when I submit certain commands (like Create Server), from a
command window on the server I get the above error also. Invoking the
"SET CURRENT QUERY OPTIMIZATION 5" command then allows me to get past
this error, but only for the life of the command window session.

It seems as though some global register ot registry entry is missing,
but I have no idea how to permanently set it.

Any feedback or clues would be greatly appreciated.

Sean

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.