db2 8.1 fp13 on Linux for zSeries (64-bit)
Every invocation of db2pd except for the "-version" and "-osinfo"
options gives following message:
=======================================

I want to trap errors (RI errors), if any, that might turn up during
merge in DB2. Is there some feature like the one in Oracle:
MERGE INTO...
WHEN MATCHED THEN UPDATE...

I am not sure whether users can access data or insert new data into
tables who belong to a rebalanced table space after new containers are
added? (DB2 version is 8.x) What I know is user can not insert new
data into tables who belong to a rebalanced table space. Is the any

I m facing a weird problem when i m executing a procedure with
different IDs, The procedure has a select statement , and a codition.
when the conditon is met an update statement is ran to update the
selected records.

DB21085I  Instance "oltp" uses "32" bits and DB2 code release "SQL08027"
with level identifier "03080106".
Informational tokens are "DB2 v8.1.2.128", "s061108", "MI00176", and
FixPak "14".

we have a table with jobs and a table with job_history information.
Users can define jobs and let them run every X minutes/hours , like a
cronjob.
The jobs table has the following trigger:

I am going to install DB2 version 9 on Windows XP workstation. But I
can not continue the installation after I issue the command "setup /i
en". System shows me that "A major error occoured while installing DB2
on this computer".

I'm working as a DB2 UDB DBA.
I have some questions regarding SCP command...
Actually every week redirect restore takes place from one of my
production servers to test servers..

What is the best practise to migrate all data in a 4K User tablepace
to an 8K User tablespace for DB2 v8.2.7?
The idea i am toying with is to interrogate the system catalog and
EXPORT all data that is in the 4K user tablespace in IXF format. Then,

I got a problem on db2 for aix running a high workload messaging
system with more than 5,000,000 of deliveries per day. During high
peak hours it happens frequently that the application,
the application threads, are all waiting for a commit to complete.

Hi I am writing a select statement that has an arithmetic function
inside a case statement that uses logic to decide whether to divide or
multiply and when I run the arithmetic statements outside the case
statement they work fine, but blow up with an overflow error in the

Has anyone used STMM with multiple instances on the same machine in
V9?  From all the documentation I have read it looks like this should
work and that there is nothing 'special' that needs to be done.  Just
wondering if anyone has any experience they can share.

DB2v8.x - AIX64
what status is considered 'idle' by DB2?
Connect Completed
UOW Waiting

When I try adding a new partion to a database instance on a 4 processer
Linux server  I get a time out and a message like "host did not respond
within ...".
When I use the Control Center Wizard, the command runs thru after quite a

I have a column in a database which saves results from a remote
machine which is related to qty on hand.
The problem is that qty's are numeric if > 0, however some 0 results
are saved as "No" and if the part has never been stocked, it is