Is there recommended way to get the execution plan for queries involving
global temporary tables (from the UNIX command line or within a script)?
I run the queries in Perl scripts, and the only way that comes to my mind
is creating permanent tables that look like the temporary ones and run test
versions of the scripts that use the permanent tables; then I can let the
script stop wherever I want and start db2expln.
But this way looks a bit cumbersome and error-prone to me.
Joachim
Apr 23 '06
12  3108 
Knut Stolze wrote: Joachim Pense wrote:
Am Wed, 26 Apr 2006 11:19:15 -0400 schrieb Jan M. Nelken:
Joachim Pense wrote:
DB21085I Instance "xxxinst1" uses "32" bits and DB2 code release
"SQL08016" with level identifier "02070106".
Informational tokens are "DB2 v8.1.0.58", "s040914", "U800266", and
FixPak "6".
Product is installed at "/opt/IBM/db2/V8.1".
Joachim
So - your DB2 is 1 version, 5 fixpacks and almost two years older.
Upgrade to latest fixpack and you will find a lot of changes.
This would include Stinger, wouldn't it? We'd love going there, but some
other software we still depend on would break :-(
What's going to break? DB2 is backward compatible so everything should
"just" work.
They tell that our old Business Objects version doesn't run with Stinger.
DB2 is backward compatible? Well, I experienced that an ODBC procedure call
that ended with an (illegal) extra close bracket was accepted and
successfully executed with a 7.2 client, but rejected with an 8.* client.
Which is good, but not backward compatible.
Joachim
Joachim Pense wrote: DB2 is backward compatible? Well, I experienced that an ODBC procedure call
that ended with an (illegal) extra close bracket was accepted and
successfully executed with a 7.2 client, but rejected with an 8.* client.
Which is good, but not backward compatible.
*lol* Well guilty as charged...
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Joachim Pense wrote: Knut Stolze wrote:
What's going to break? DB2 is backward compatible so everything should
"just" work.
They tell that our old Business Objects version doesn't run with Stinger.
DB2 is backward compatible? Well, I experienced that an ODBC procedure
call that ended with an (illegal) extra close bracket was accepted and
successfully executed with a 7.2 client, but rejected with an 8.* client.
Which is good, but not backward compatible.
True. The compatibility reaches only so far as no errors/bugs are
concerned.
Also, other features and behavior may change between versions. But the
developers try hard to keep things stable. So if you encounter something
where things start to break (and are not a user-error as in your example),
you should take it to IBM support to get the problem fixed in DB2.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Dan |
last post by:
I am new to tuning and I am having some trouble with my Oracle
9.2.0.1. I have a database that I am trying to gain consistent
performance out of but I seem to have changing execution plans. Due
to a number of factors outside my control, I have to handle an
application that does not send bind variables, I handle them as they
come in. To do this, I have set the init.ora file to have an entry of
'cursor_sharing=similiar'. I know this is a...
|
by: Vinny |
last post by:
Can anyone help me with this strange problem please?
I have a stored procedure, with a parameter defined as a
uniqueidentifier. The procedure does a select with a number of joins,
and filters within the Where clause using this parameter.
(@orderHeader_id uniqueidentifier)
SELECT *
|
by: randi_clausen |
last post by:
Using SQL against a DB2 table the 'with' key word is used to
dynamically create a temporary table with an SQL statement that is
retained for the duration of that SQL statement.
What is the equivalent to the SQL 'with' using TSQL? If there is not
one, what is the TSQL solution to creating a temporary table that is
associated with an SQL statement? Examples would be appreciated.
Thank you!!
|
by: Christine Wolak |
last post by:
I'm looking for assistance on a problem with SQL Server. We have a
database where a particular query returns about 3000 rows. This query
takes about 2 minutes on most machines, which is fine in this
situation. But on another machine (just one machine), it can run for
over 30 minutes and not return. I ran it in Query Analyzer and it was
returning about 70 rows every 45-90 seconds, which is completely
unacceptable.
(I'm a developer, not...
|
by: mas |
last post by:
I have a Stored Procedure (SP) that creates the data required for a
report that I show on a web page. The SP does all the work and just
returns back a results set that I dump in an ASP.NET DataGrid. The SP
takes a product area and a start and end date as parameters.
Here are the basics of the SP.
1. Create temp table to store report results, all columns are created
that will be needed at this point.
2. Select products and general...
| | |
by: Jenny Zhang |
last post by:
Hi,
I am running OSDL-DBT3 test against PostgreSQL. I found performance
difference between the runs even though the data and queries are the
same. I tried to study this problem by getting execution plans at the
beginning of each test. The following script gets execution plan for 22
queries, except query 15.
i=1
while
|
by: Jenny Zhang |
last post by:
The osdl-dbt3 test starts with building and vacuuming the database.
The execution plans were taken after the vacuuming.
I did two tests with the same database parameters:
1. run two osdl-dbt3 runs on one box without rebooting the stystem.
Though the execution plans are the same, the costs are different. The
system status are different for the two runs, for example, some page
cache are not released after the first one. Does that make...
|
by: Ina Schmitz |
last post by:
Hi NG,
does IBM Universal Database 8.2 make any difference between actual and
estimated execution plans like in SQL Server ("set showplan_all on" for
estimated execution plan and "set statistics profile on" for actual
execution plan)? Does "explain plan selection for" generate the *estimated*
execution plan? Didn't find any distinction of actual or estimated execution
plans in the information center.
Thanks for help,
|
by: sqlgirl |
last post by:
Hi,
We are trying to solve a real puzzle. We have a stored procedure that
exhibits *drastically* different execution times depending on how its
executed.
When run from QA, it can take as little as 3 seconds. When it is
called from an Excel vba application, it can take up to 180 seconds.
Although, at other times, it can take as little as 20 seconds from
Excel.
|
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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...
| |
