473,372 Members | 1,063 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Control Center - current query opt error

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
1 3089
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: ThisIsAMess | last post by:
All! I posted a query a while ago as to how one can 'draw' lines on the webbrowser control (as on an 'imported' chart). I'm re-asking that query, plus another. The new one is - How can one Center...
0
by: marius | last post by:
Hi! I'm currently trying to move from MS SQLServer to MySQL, running on windows XP. When trying to connect to mysql on localhost with mysql control center I get the 2013-error "Lost connection...
4
by: Sean C. | last post by:
Helpful folks, I've just migrated our test server from V7.2 -FP11 to V8.1.3, on WinNT 4.0. Everything went pretty darn smoothly, however I get the following errors when using the Control Center:...
2
by: Lyn Duong | last post by:
Hi In SQL Server query analyser, I have the follwoing query if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table . GO
6
by: Franco Lombardo | last post by:
Hi all, I'm running DB2 8.1.5 on Windows 2000 professional SP4. When I try to start Control Center, I see the splash screen for a while, then it closes and nothing else happens. It happens...
3
by: Joshua Ammann | last post by:
Hi, (Using Access 2000) I have two tables, similar to Customers and Orders. (Not an exact parallel, but works for this example.) On a form showing customer data, there is a tab control. One...
8
by: bienwell | last post by:
Hi, I have a problem of displaying data bound by a datalist control. In my table, I have a field Start_date which has Short Date data type. I tried to update this field by Current Date. After...
11
by: Hoku | last post by:
I am using dual monitors on a dual head ATI AGP4x video card. I installed the Nov 11 2005 release of ATI's catalyst control center with Hydravision to manage the dual monitor setup. I recently...
0
by: nate | last post by:
the error returned is this: Server Error in '/AnnAccRpt' Application. -------------------------------------------------------------------------------- Could not find control 'DropDownList1' in...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.