SELECT columns
  FROM t1
  JOIN t2
  .

hi, we are using db2 udb v8.1 on 64 bit windows, this message is in
the db2diag.log file
ADM5502W  The escalation of "38200" locks on table "xxx.xxx" to lock
intent "X" was successful.

I'm having trouble running IBM DB2 under Red Hat Linux 9.0. More
specifically, the IBM JDK 1.3.1 (needed for UDF's and the graphical
installer) crashes. After some googling I tracked the reason down to the
new Native Linux Threads (NLT) included in Red Hat 9.0. Apparently, Java

i am using db2 udb v8.1 , so if parameter retain log records is off ,
i am assuing it use circular logging, in the doc it explains the log
records fill the log files and then overwrite the initial log records
in the initial log file, so if so, why we still have transaction log

i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?

the formula for package cache hit ratio is
1 - (package cache inserts/package cache lookups), what the result
would be a effective ratio? currently we have cache inserts=25, cache
lookups=35, so i get ratio =0.28, is this a good number?

I has experienced a backup/restored problem and need some help.  After
mydb is restored and roll-forwarded, I received this message:
SQL1271W  Database "mydb" is recovered but one or more table spaces
are off-line on node(s) "0".

We have a stored procedure that returns a result set.  We call this
stored procedure from an RPG program using SQL CLI.  The first call is
successful and we can fetch rows, etc.  The RPG program ends with
*INLR set on.  The second time the program is called and the stored

i have db2 udb v8.1 on windows 64 bit 2003 server, after db2 server
start , i found this in the db2diag.log, is this error?
2004-05-05-15.28.30.780000   Instance:DB2   Node:000
PID:1692(db2syscs.exe)   TID:2860   Appid:AC10040A.GD5F.00FC56D8BEC5

We had an application which uses Java and Oracle. We have written some
procedure in oracle which accepts VARRAY as a parameter. Now we
migrated the same application to Java and DB2 UDB. The procedures
where we used VARRAY, replaced with VARCHAR(10000) for parameters.

I am running V8 fp 4a on a W2K Server.
I generated a script from CC to backup up my database and got the
following:
CONNECT TO EDPACKD;

I loaded a flat file into an SQL table and verified the data. Now I want
to move the data from the input table to the real table. I thought to
use a SQL statement like:
update is2.animals t1 join nullid.nalfherd_in t2

I have a Client (DB2 V7.2 Fix 11 Server Fix 11) both on Windows 2000.
After the installation of new software the user (normal user) can no more
connect to db2.
In the db2 log there are following error codes:

I can not seem to get a good answer to these questions:
I have a DB2 database that we run DB2 6.1 workgroup Edition. We had
purchased upgrade protection up until 2002. So I have my cd's for
Workgroup Edition 7.1. Really what I would like to do is upgrade to

Anyone know of any ETL or DataMapping software that
can be used to migrate to IBM DB2 from Oracle?
Thanks,
DWB