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
{SQLDriverConne ct}
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\Se rvers 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 1 3118
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.c om (Sean C.) wrote in message news:<2f******* *************** ****@posting.go ogle.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
{SQLDriverConne ct}
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\Se rvers 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 a portion of,
say, an imported chart/document within the webbrowser control?
Otherwords, the bottom-right portion of the chart/document is what I
want to be centered when I import the chart/document.
Thanks...
|
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 to MySQL server during query".
I can connect from command line. If I do so, and change passwords by
using OLD_PASSWORD('<password>'), control center runs nicely, but then
ByteFX fails to connect with "Access denied for user...".
|
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:
Click on the 'Event Monitor' folder, and an error dialog box
appears containing the following text:
SQL0713N The replacement value for
|
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
|
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 with "Activity center" (Since I'm running the
italian version, I don't know the
english name of this tool, I mean db2tc.bat).
| |
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 of the
tabs has a subform showing order data (in datasheet view). On the same
tab there is an unbound textbox (next to the datasheet). I placed a
|
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 that, I display End_Date on the
DataList control. The output looks like 3/18/2005 12:00:00 AM . I'd
like to format data for this field to be 3/18/2005. Please help me.
Thanks in advance....
|
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 updated to .NET v2 and run Zone
Alarm Internet Sec Suite 2006 for firewall and av.
When I log off/shut down the computer a dialog box appears as follows:
End program-.NET-BroadcastEventWindow .1.0.5...
Shutdown hangs up and I must click End Now...
|
by: nate |
last post by:
the error returned is this:
Server Error in '/AnnAccRpt' Application.
--------------------------------------------------------------------------------
Could not find control 'DropDownList1' in ControlParameter 'DropDownList1'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |