Sirs,
We are using DB2 UDB 8.2.5 for AIX 5.3. Everytime when we perform a
online incremental backup to Tivoli, the system will hang for about 10
mins or more at the begining of backup due to no update possible.

Does anyone know where I could get my hands on one or more old DB2
certification exams? I'm especially interested in Exams 700 and 701 but
would like to look at others as well.
There are links for sample exams at the IBM website but they don't actually

What are the possible ways to change the data type of a column from
BigInt to Integer?
the normal command
Alter table <tabname> alter column <colname> set data type Integer

I have some questions about DB2 certification.
1. Are the DB2 V8 exams still available, specifically in the Toronto area? I
went to the certification portion of the IBM website and it took me to a
site for Thomson Prometrics who seem to be administering the certification

ID     CODE
-------------
1     XD23414
2     LKJ454678

Can you have muliple DB2 instances that are at different code levels on the
same computer? For example, can I have an instance of DB2 V8 and an instance
of DB2 V9 on the same Windows machine?
I know it is possible to have multiple DB2 instances on the same computer if

I have some scripts that drop columns in DB2 9. This leaves the table
in a REORG PENDING state:
[IBM][CLI Driver][DB2/NT] SQL0668N  Operation not allowed for reason
code "7" on table "tablename".  SQLSTATE=57016

Quick question in the hopes of getting a quick response... : )
When you take a snapshot after activating a monitor switch counters
such as rows read... is the value shown cumulative from time of
database activation or from the time the switch was turned on.

I am  facing an issue here.
I had to drop a number of columns (around 20) from a table, which I
tried to do all at the same time using the following command.
Alter table table_name drop column <column1> drop column <column2>

Is there any way to do the following pattern match in db2?
LIKE '[CK]ars[eo]n' searches for Carsen, Karsen, Carson, and Karson
(Carson).
In other words, the brackets around CK will match anything with a C or

recently we migrated on our zOS-System the DB2 from V7 to V8, after
the migration we should be able to use the JDBC type 4 driver but we
get the following error:
DB2

I'm having a performance issue with a Windows CLI/ODBC application
that connects to a DB2 rel 7.1 on a mainframe of a bank.
I have to say I'm pretty new with this kind of environment.
The application is working, but it is much slower than when I run

We are seeing strange behaviour for queries on a table we need to
convert data from. We try to find out whether table A(B_CONV_ID)
contains data that does not exists in table B(CONV_ID). We expect that
there is data missing in table B, thus finding a positive number of

I use db2 9 express-c
Hi... I'm having that problem...
....every less-than-10-seconds, a entry like that (I displayed that
entry with the command db2evmon -db 'MYDATABASE' -evm

I have installed the Run Time Client Lite on a WIn XP computer for the
ODBC driver
and it works fine, I get an connection.
When I installed the Client on a Win2003 computer I get this error