Hi All,
Im trying to run db2expln over some sql in order to find out why its
so slow.
I receive the following error message.
LINE MESSAGES FOR DYNEXPLN.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
1 SQL1185N FEDERATED "NO" is incorrectly used in binding the
package.
SQL0091W Precompilation or binding was ended with "1"
errors and "0" warnings.
SQL1185N is telling me that FEDERATED isnt set - "...In this case, you
must specify FEDERATED YES to bind the package.". The federated param
is set, as Im running sql at the command line using federated tables.
I set the federated value again, but wil no success.
"db2 update dbm cfg using federated yes"
Can anyone suggest how to resolve this, or a better way to analyse
slow running SQL.
Thanks
Terry 3 2952
In article <e8************ **************@ posting.google. com>, Terry
(te************ @yahoo.com) says... I set the federated value again, but wil no success. "db2 update dbm cfg using federated yes"
Did you stop/start the instance to activate the changed option?
Did you recycle DB2 after changing the Federated Parm to Yes?
Larry Edelstein
Terry wrote: Hi All,
Im trying to run db2expln over some sql in order to find out why its so slow.
I receive the following error message.
LINE MESSAGES FOR DYNEXPLN.sqc ------ -------------------------------------------------------------------- SQL0060W The "C" precompiler is in progress. 1 SQL1185N FEDERATED "NO" is incorrectly used in binding the package. SQL0091W Precompilation or binding was ended with "1" errors and "0" warnings.
SQL1185N is telling me that FEDERATED isnt set - "...In this case, you must specify FEDERATED YES to bind the package.". The federated param is set, as Im running sql at the command line using federated tables.
I set the federated value again, but wil no success. "db2 update dbm cfg using federated yes"
Can anyone suggest how to resolve this, or a better way to analyse slow running SQL.
Thanks
Terry
Smells liek a bind option to me, not the DBM CFG.
You may need to rebind the db2expln bind file with FEDERTED YES.
But you can also do things simpler:
cd sqllib/misc
db2 -tvf EXPLAIN.DDL
db2 EXPLAIN PLAN FOR <my query>.
db2exfmt -d dbname
(default everything else but the out-file)
You will never want to go back to db2expln :-)
Cheers
Serge This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: LazyAnt |
last post by:
Hello,
I have DB2 v8.1 for Linux for a class environment; each user has
his/her own database as dbadm and they are suppose to study queries
from another database.
They have the right permissions to this database so they can do the
SELECTS but they cannot alter the tables.
Now I want them to be able to study the query plans.
|
by: RdR |
last post by:
Hi,
I have a table in SQL Server with no keys, I point this as a federated table
in DB2 but in DB2 I have defined keys against this federated table in SQL.
Where will the key constraints be followed in DB2 or in SQL? How should a
select statement in DB2 for this federated table behave if there are
duplicates in SQL? The result I am getting is it is showing an actual
duplicate in DB2 for this federated table. Is there any setting in DB2...
|
by: Terry |
last post by:
Problem:
=========
Unknown column appearing in federated tables.
Description:
============
Local database (L) is an established 'federated' database, extracting
values from multiple remote databases.
Database server = DB2/LINUX 7.1.0
|
by: uthuras |
last post by:
Greetings all,
Is it possible to have federated db feature implemented among DB2
family? I intend to create federated within DB2 databases. I have 2
databases TestA and TestB. I have some base tables in TestA database
and the reference tables in TestB database.
Now i want to select data from TestB database referencing base table in
TestA database. One of the way would be Federated Database. I've seen
some red books on setting up...
|
by: Alias |
last post by:
Hi Guys ,
I am trying to create a federated database link between 2
UDB 8.1 databases running on AIX on the same box but under different
instances. When i tried this thru the control centre , I got this error
:
*****************************************************
SQL1013N The database alias name or
database name "SAMPLE" could not be found. SQLSTATE=42705
*****************************************************
| |
by: Klemens |
last post by:
I get SQL30090 reason 18 by trying to do an insert in a federated table and
an update in a local table in one transaction
Do I have to change some settings to get done or ist this not possible by
definition?
Thanks
Klemens
|
by: Praveen_db2 |
last post by:
Hi All
DB2 8.1.3,Windows
I have 2 databases in a single instance, say DB_1 and DB_2.I need to query
a table from DB_1 in DB_2.I am try to use a nickname for it.But nickname
creation is not possible until federated server is made.Please tell me how
to create a federated server.Moreover, is there any thing extra which I
need to buy for this?When I gave this command to create a server
CREATE SERVER "TEST1"
TYPE DB2/UDB
VERSION 8.1
|
by: jefftyzzer |
last post by:
Colleagues:
Can anyone tell me what the number to the right of "Index Prefetch:
Eligible" designates in the output from db2expln, e.g., "Index
Prefetch: Eligible 14409"?
I see such a number in many examples of dynexpln output on the web, but
can only find explanations such as this one, which lacks any mention of
the number:
|
by: Troels Arvin |
last post by:
Hello,
In a DB2 LUW v. 8.1.1.96, I have a hard time giving users access to the
db2expln utility.
Let's say that user FOOBAR needs to be able to run the db2expln utility. I
do:
- provide IMPLICIT_SCHEMA, CREATETAB, BINDADD, IMPLICIT_SCHEMA
to the user
- ask the user to run /home/db2inst1/sqllib/misc/EXPLAIN.DDL; this
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |