our Customer used to take backup all the tables of a particular schema
using export utility,
previously the export operation used to finish within 30 Minutes. As
of now it is taking

I am very surprised to see that after doing a Reorgchk followed by reorg of
selected tables and concluding with a runstats of the reorged tables, all of
the tables continue to be identified and selected as reorg candidates in
subsequent/followup reorgchk.

How to reduce the highwatermark for a DMS tablespace in V8.2? I have
tried doing classic reorg on the table in the tablespace twice, but
the highwatermark is lowered. Any ideas?

when i want to set the value of  CPU_PARALLELISM of LOAD at AIX
5.3,the value is base of physical CPU number OR logical CPU
number(SMT)???
thanks!!!

Am using DB2 UDB ESE on AIX platform. I used to take a full/
incremental online backup regularly. This process used to go on since
years. But recently, whenever am trying to take the same, am receiving
the  911 error msg. I have understood that the 911 errors are due to

I have a situation where one of the app server thread is executing an
update statement on A record and at the same time another thread is
trying to read it by executing a select query. Now we are seeing
timeouts - Update query is holding the lock and the select statement

I have the following three tables
DROP TABLE CALLTRAK.SERVICE_CODES
@
CREATE TABLE CALLTRAK.SERVICE_CODES (

I need to convert a bunch of DB2 triggers to Oracle.  Is there any
kind of tools for this?

Using 8.2 on Windows.
I have a situation where I have a db backup, which I want to deploy to
a group of developer workstations.
The target directory for the database files will be consistent, but

I have a table that is based on a client_cd,
client_cd, client_nm ..........
It has 1.7 billion rows with varying cardinality for each client.
All I want to do is to set up a sample table having exactly 100 rows

How would I execute two independent SQL statements in the same stored
procedure?  I have a business process that requires a number of long-
running procedures to be executed.  The procedures themselves are not
related and can be run simultaneously.  The pseudo-code would look

i have a problem when creating a trigger on DB2 ver 7.2 on WINDOWS.
I have two tables MOVIMAG and BARCODE, the trigge when INSERT INTO
MOVIMAG
will be UPDATE a MOVIMAG field BARCODE taken the value from the table

Anyone know if MQ Functions (made available by "enable_MQFunctions" System
Command) are included in DB2 Workgroup Edition, or is Enterprise Edition
required? This would be for DB2 LUW 8.2 or 9.1.

I have table with CLOB column length of ~65K. application is searching
from this table  by CLOB and i can not create index on it.
I know IBM recommends using DB2 Net Search Extender or DB2 UDB Text
Information Extender for searching CLOBS but what are the other

I have 6 tables inside a MS Access 2003 mdb file.
I want to convert them as DB2 version -8 tables in AIX 5.2.
I have exported them as 6 XML files.
The XML files look fine.