DB2 v8 FP5 WSE LUW
Red Hat Linux 2.1AS
I'm like to add a new column to an existing table that will be
NOT NULL and have a WITH DEFAULT value.

I dropped the db2detaildeadlock event monitor without flushing the
events that were full hoping dropping it will clear the messages also.
I now understand this is a default monitor that I should not dropped.
Now there are "SEVERE" error messages occuring everyday -few times.

I've read the former postings but was not able to solve my problem:
I have a Summary Table (or MQT as you like it) and the query optimizer
does not seem to use the summary table.
I run the following commands:

I'm doing a project on database benchmarking, and I have to convert a MSSQL
database to DB2 v8.2. The database is 800MB and origins from a message+news
board.
I followed all the steps as described in the guide & on the IBM site, but I

I have to start working on DB2 administration for my new
responsibility. I had done some hands on administration about 2 years
back, but I was managing a very small Database.
I would like to start over, I wanted to know where I can start, I am

when i'm trying to type a db2 command, it cause problem and the system
hang.. previously there is no problem on it, but after i had install the
"FixPak 8", it have this problem.. And the error come out like this :
"DB21015E  The Command Line Processor backend process request queue ...

I am preparing a database that will store 10 n * GBs - 100 n * GBs of data.
I calculated to have 1,2 GB of bufferpools. I run the DB2 v. 8.2.1 alone on
4 GB box.
I obtain :

I feel really embarassed asking this.
However, ask I will.
When we say that:
(1) "CLP in Db2 V8.2 still imposes a limit of 64K on the stored proc

I have to create a report with drill down and I can only think of
crosstab
report to achieve this task. However 2 things I am lacking, first is I
dont know how to enable drill-down on cross tab and secondly how to get

I am told that Oracle has this "data compression" feature that allows
you to store online data ina compressed format.
This is different from archived data - you compress only that data
which is infrequently accessed but is still available in the online

I am going to insert a large amount (200,000 records) of data into a table
Is there a way that I can temporarily disable the log? so that the insertion
run faster
Thanks in advance

I'm new to DB2 and our team is in the process of
migrating from Oracle to DB2.
Assuming new.created_date is now a TIMESTAMP,
what would be the DB2 translation of this Oracle

Folks,
I'm wondering if anyone out there actually has a working implementation of
the MQ SQL functions, and if so if they can offer some advice to a poor
struggling MQ novice.

I'm new to DB2 and our team is in the process of
migrating from Oracle to DB2.
Assuming new.created_date is now a TIMESTAMP,
what would be the DB2 translation of this Oracle

The same dynamic sql statement at the same database needs from one
application seconds and from another milliseconds.
Isolation level and optimization level are the same.
What else could be different.