Any method to find out which SQL is being executed within a stored
procedure. St.proc has been written using SQL running on V8.2/AIX 5.3.
Application Snapshot only shows the stored procedure call statement and
not which SQL is being executing currently.

Can someone give an example of a query which produces the following
warning:
SQL0012W Correlation without qualification has occurred for the column
"<column>".

I did set up this thing and it worked well during my test so I invited the
users to test it before it would be put into production. I got no complaits
and thought it all was working.
So I decided to run the Configuration advisor in the Control center and

I'm trying to create and use Java singleton inside Java UDF just as
Mr Knut Stolze described in
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0404stolze/inde
x.html
. But I've the problem because each instance of UDF seams to run in

Hi, I have a couple of .db2 files and I'm wondering how I can view
their contents--maybe there's a program I can download? I've never
worked with ibm stuff, only mysql.

I have this multi-threaded perl program where I'm trying to do
independant database operations in separate threads.  I was getting an
error similar to the following:
DB2 has no driver CLONE() function so is unsafe threaded

I am trying to understand "client authentication" works.  My environment is
DB2/UDB LUW 8.2 on zSeries SLES9 as the database server and DB2 for VSE 7.4
as the client.  We currently have DB2/LUW set up as follows:
Client Userid-Password Plugin          (CLNT_PW_PLUGIN) =

I am using db2 udb 8.1 fixpack 3 on AIX 5
I am recieving ht e following message in my DIAGLOG  :::
==============================================================
2007-01-04-03.28.09.457980   Instance:db2inst1   Node:000

What is the difference (if any) between
  inspect check database
and
  db2dart

How do I clear the sql statements the design advisor gui picks up in
the default workload?

Hi hi... does anyone know how I can alter the maintenance window for
automatic maintenance from the CLP?
-R-

I get a lot of these messages in db2diag.log - seems like problems with
health Monitor:
2007-01-05-15.05.06.380000+060 I260759H331        LEVEL: Severe
PID     : 3860                 TID  : 4004        PROC : db2fmp.exe

When i try to drop a table, and this table have (for example) some
function related...db2 don't allow to drop the table
how can i enter a command to drop the table AND all the objects
(functions...triggers...views) that depends on that table?

I need a help creating a duplicate instance
* My DB2 is 8.2 and is in AIX 5.2
* I have a instance with 3 database , I need to make a clone for these
3 db to another instance.

I have a rather strange issue here connecting to the database on an ESE
environment. A little background on the issue. The cluster is an 8
server, 64 partition system. So when I try to do a rah or db2_all "db2
connect DBNAME", it works just fine. However, when i explicitly try to