I found this article in DB2 magazine and learned about the Problem
Determination Mastery Exam. I am very interested in taking the exam,
however, following the links in the article leads to DB2 tutorials and
exams, but no mention of the Problem Determination Mastery Exam. Now,

I was wondering if there is a way to intercept the SQL query before it
gets send to DB2 query processing. The problem I am facing is that I
want to add context information into the query. For example, when a
user queries "select price from yahoo where ticker ='ibm'. If this

Hi Group,
I have a problem in restoring my tablespace, my database is running in
ARCHIVAL logging, I created a tablespace, did some transaction, then
took the ONLINE BACKUP of the tablespace. Then I dropped the tablespace

I can create a dumpfile to see the rows rejected by the load.  How can
I see the rows deleted in the delete phase?

A join query is running against my db which is logically partitioned.
The join involves a partitioned table (has around 300 Million rows)
which is spread across 7 partitions and a small non-partitioned table
(has around 2000 rows). Joining the table based on the partitioning key

I am trying to create a stored procedure with following functionality.
I need to select a table where status = 'G' and return the row to the
application and then update all those rows that I just selected to
change status to 'P'.  This table is being inserted all the time.

I have created a SQL stored procedure on DB2 V7 on Z/os. I have defined
it and compiled it wit no errors . When I try to run it from a Db2 V8
Fp12 client, its giving :
SQL0440N  No authorized routine named "SQLPROCEDURECOLS" of type ""

I created all the tables in my database (about 100 of them) a while ago
without enforcing the RI constraints.
Now, most of them are loaded with data and I need to execute those RI DDLs
on the entire database.

hai everyone ...
                     can anyone tell me how to compile db2uext2.cdisk
file inorder to make use of it.......... Pls send me the link frm where
i can download the compiler if any..........

DB2 for LUW fixpack 11.
If I create a SP with only a select (no insert, updates, or deletes), and do
NOT use MODIFIES SQL DATA clause in the SP, the column SQL_DATA_ACCESS in
SYSCAT.ROUTINES is set to 'M';

The current issue of "Oracle Magazine" has an article on creating
custom aggregate functions, which naturally got me thinking about how
to do this in DB2.
I found some articles on creating custom aggregate functions in DB2,

LUW V8 FP 11 running Linux RH AS4 Update 3.
In regards to performance and IO parallelism, does it matter if I
create a tablespace with a single big container, or is it better to
create it with several smaller containers ?

Following Ian's passionate postings on problems with ALTOBJ and the
alter table wizard in the control center I'll try to explain how to use
ALTOBJ with this thread. I'm not going to get into the GUI because it is
hard to describe in text.

I'm building a web based auction system for multiple clients. I have
auctions, items, and invoices I need to assign generated keys for. Since
each of these entities is represented by a table, the keys are assigned
as GENERATED BY DEFAULT. While this works, and is easy to ...

I have a db2 server running on solaris v8, which we have recovered from
tsm backup onto another machine which has the same hostname/ip as the
live server, but on a different lan (non connected)
When I start the db2 processes via /etc/rc.db2 i appear to get the same