I'm DB/2 newbie. For few day we have performance problems into our DB/
2 Win 03 cluster. DB/2 is 8.1.7.xxx release. Hi CPU usage.
I see that thare are several db2fmp.exe process that use 5 MB for
each.

I use db2 v8 fp 14 on Aix.
I am facing problems with a stored procedure that is causing a lot of
locks and also goes in the lock wait state ending up hanging the
application.

Hi to all,
Can you make a (simple) example about logging table changes into a
"log" table?
It is possible using triggers?

Hi forum,
I would like to save in a file all istance and mode parameters...
howto ?
I would like to store in a document all actual "good" parameters.

I am running DB2 LUW 8.2.5 on AIX 5.3
I am being asked to rename an instance in Production which contains
several databases.
I am being told it would be difficult to shut the instance down.

I am getting a precompiler error which I don't understand.
In my Cobol program I have the following code
          01  TESTDB.
           03  ADDR.

Does anyone know what db2dascln is and what it does?

I am writing a program to read database logs using db2Readlog/
db2ReadLogNoConn API.
I am able to parse the data of "FIXED format data" and link them to
appropriate columns for a given UPDATE/INSERT/DELETE.

I just finished one "quickie Email consult" for an old friend where we
removed 70-75% of the lines of code and reduced the time from 98
minutes to 4 minutes for time-to-completion for a complex report using
CASE expressions instead of sub-queries.  It took three emails and ~15

the requirement that i have to meet is:
(pseudocode):
for each table in table_list
loop:

I all I am trying to go into a loop to insert data into a new table,
the loop is required because the select genearte to much data and the
transaction log gets full.
So i found a way to get this solved by spliting the data into smaller

  Can anybody help me in taking up the database backup. I don't have
any idea about db2 and know a bit in oracle. In oracle we can import
and export data  that may be in the same database server or a
different. here my problem is, i took backup of the database in db2

what is the internal difference between the following two truncate
table commands:
db2 import from /dev/null of del replace into <table_name>
and

Dear Gurus
Please help. I have installed DB2 8.2 on AIX 5.3. No apparent errors
while installing. I opted the defaults to create the instance db2inst1
But when I do a db2start, I get the following error

I'm having a big problem on one very important table in the system I'm
developing. Everything started when I tried to insert some columns to
this table, and AS400 DB2 told me that there was a corrupt trigger. So
I recreated the triggers for that table and nothing happened. I've