(DB2 LUW 8.2)
I'm just trying to write a little widget to capture lock wait details
(when they occur).
i.e when a lock-wait occurs, simply record the 2 statements involved

With a large database with many tablespaces, primarily on raw devices, how
do I convert it to a sms-based-only database?

DB2 LUW 8.2 FP14 Red Hat AS 2.1
I went to restore a backup of my production DB on my test/developmental
server.  The backup on the prod system was taken /before/ alt_obj() was
used there to do some schema evolution.

We have clients who have not been exposed to SQL and have built a few
thousand queries using the iSeries Query tool via their 5250 sessions.
Is there any way to gather the code behind these queries that they have
saved?  Rather than opening each of them to reverse engineer how they

Can anybody explain to me the relation between extentsize and pagesize.
When I am creating a new tablespace what do I need to be careful of?
Say pagesize is 8K is keeping extentsize(pages) 64 too large? What
exactly is the relation?

In the middle of page 231 on the book "Administration Guide -
Implementation" stated - "In addition to these package privileges, the
BINDADD database privilege allows users to create new packages or
rebind an existing package in the database."

Who knows how to retrieve the owner of SQL objects, such as SCHEMA,
TABLE etc.? Is GRANTOR within catalog view owner?
Thanks,
Laurence

I have an issue. When a developer tries to connect using an USERID and
a ped it gives
SQL30082N  Attempt to establish connection failed with security reason
"19" ("USERID DISABLED or RESTRICTED").  SQLSTATE=08001. He is getting

Just came across this one:
http://www.ibm.com/software/support/toolbar/
Cheers
Serge

How can I get getdate() (SQL similar) at DB2?

The (limited to propagatable since version 9) log records are described
in the API reference manual.
What is meant by: normal/undo/redo/compensation records, what are the
possible subtypes for each of these record, what events trigger there

DB2 installation: V. 8.1 LUW, fixpak 10.
In certain situations, I get strange error messages. Example: I want to
add a NOT NULL constraint to a column. Through db2cc, I try to do what
corresponds to

Hello, I am new to DB2, and I found myself get lost among the new
concepts, such as non-partitioned database/partitioned
database/database partition/partition group/node ,ect. Would you
explain to me the concepts(using db2 8.2  terms), and the relationship

 I had installed DB2 V9 Express-C on my server Ubuntu 6.10 and it runs
well. Now, I would like to open DB2 Control Center from my windows (I
use ssh and putty to connect with server ).In fact, I can do my
requests using the commands, but I think that it will be better with

I had a tablespace which ran out of space. Most of the tables contained in
the tablespace where then empitied, but the tablespaces kept being full
when viewed with "LIST TABLESPACES SHOW DETAIL", and users couldn't put
data in the (now empty) tables. Then, after some hours, LIST ...