I have a problem. :)
I have a big SQL statement with about 20 LEFT JOINS. When I run explain on
it it gives me a total cost of about 500, but when I run the query it runs
for about two minutes.

I have a DB2 connect PE ver 8.2 installed in my windows client which
tries to connect to AS/390 Database Instance via CCA.It uses TCP/IP.
While trying to connect the Server from the windows client
SQL30081N  A communication error has been detected.  Communication

We have several machines currently running the DB2 V7 Run-time Client
that we would like to actually be running the App Dev Client.  To
'upgrade' (within the same version) this client software can we simply
install the App Dev Client on 'top of' the Run-time Client?  Will the

i replace the program file in $db2path/sqllib/function with a new one
,
and call the  procedure . it turns out to be the old one , since i
print a massage for notice .

I have couple of questions some one plzz help
1.I have a query which run for 2 hours on my production machine, it
returns 1.5 millon rows, i looked at the explain plan it is picking up
the indexes on big table. The query joins 5 tables ( 1 has 30 million

At the company I work job applicants are required to do a little test.
The human resource manager recently had a candidate who claimed one of
the questions was ambiguous.
Dependent upon the version of DB2 one or the other answer of a multiple

I reviewed a similar post on an older version of DB2.  I was wondering
if there was anything available now that is more precise in gathering
the db2 version for the new v8 calls.
I am running DB2 v8 FP9 and was wondering if anyone knows if there is

In Sybase global variable @@transtate keeps track of the current state
of a transaction. Sybase server determines what state to return by
keeping track of any transaction changes after a statement executes.
@@transtate may contain the following values:

When I create a new user in DB2, can I set the default schema to an
existing schema?  The reason I want to do this is that I want to later
connect to db2 as this user and access tables WITHOUT the schema name
prefix.  In addition to that, I want to use ADO.NET to connect as this

I am trying to redirect-restore a backup of a DB2 V6.x system (AIX 4.x)
on DB2 V8.2 system (AIX 5.2). I get the above error with no other
details. db2diag.log has a series of error messages, starting with
following message -

Well, I've finally gotten UDB 8.2 FixPak 3 up and running on my HP-UX
11i system, thanks to Mr McBride and IBM support.  :)
I created a 32-bit instance and that's running just fine. However, I
learned today that I need to have a 64-bit instance.  So, can I create

Hi!  I need to migrate a UDB 7.1 32-bit database on one HP-UX system to
a 8.3 (FP3) 64-bit database on a new HP-UX system.
I found this newsgroup post which indicates this not possible using
backup/restore utilities:

Does anyone know if any IBM branch across the country offers Store
procedure classes?.
Thanks
Marc

[cross-posted on .databases.informix and .databases.ibm.db2]
Hello
I have an application using an internal database (user doesn't know
about it) and I would like to know if I can use some IBM product with a

I'm a oracle DBA who wants to learn DB2 also.
I've installed DB2 V8.1 Personal Edition to play around.
Now I wonder whether there is a tool similar to sqlplus in the db2
world. This because I like a command line a little more then a GUI.