473,372 Members | 993 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.

db2expln and federated

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
Nov 12 '05 #1
3 2935
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?
Nov 12 '05 #2
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


Nov 12 '05 #3
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
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
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...
1
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...
1
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...
4
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...
5
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...
5
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...
4
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...
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...
1
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...
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
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.