I have problem where a ETL team is trying to update a column in a very
large table.  They are  trying to do this in single query.  Also each
time they run it consumes all available space in the logs and this in
turn abends their process.  We are limited on log space.

Hi guys..
apart from the day-to-day monitoring, administring and perf tuning
activities, what are all the value added things than can be done by a
DB2 DBA?

I need some help with a problem I've encountered. I am a zLinux, WAS, and DB2
noob so please bear with me.
I am helping to support two WebSphere applications which utilize DB2 under
zLinux. One application is for Europe and the other for the US. Each

After I installed FP3 to an exiting DB2 V9 copy on windows 2003(32-
bit), issued db2updv9 to update ER1 database to current version, but
got the following error.

Our Mainframe DBA insists that the IDTHTOIN parameter be set to 600
so
that all idle threads timeout after 10 minutes.  This is causing a
particular packaged application that expects to hold idle threads

I am using AIX DB2 v8
we have tables so huge...when I do query...like the following:
db2 "select * from table fetch the first 10 rows with ur"
all the outputs are wrapped around the screens, and u are hardly to

I heard a rumor that compress is only availible in Enterprise Edition
in 9.5, can anyone confirm/reject this rumor?
/Lennart

I tired to run the following statement, but it does not work inside a BEGIN
ATOMIC. I assume this is a known limitation, but I could not find it
documented:
BEGIN ATOMIC

We had a load that failed.  Now we have a pending load.
When executing load terminate, we receive the following error:
db2 load terminate
SQL0104N  An unexpected token "terminate" was found following "LOAD".

Excuted the statement through a SSH connection:
db2 import from <filename.ixf> of ixf messages /database/stage/
acct_news_asc.txt insert into userid.acct_news_asc
And it worked fine.

It seems that I must pass a "SET ENCRYPTION PASSWORD =" to each stored
procedure that puts an encrypted value into a column.  Also seems that
I don't have to specify that password when using DECRYPT_CHAR().
Does that mean that a different password can be used for each entry

We were trying to run the following set of commands
Alter table----successfull
reorg table---successfull
Alter table---successfull

Database level is: DB2 v9.1.300.257
Operating system is windows 2003(32bit)
Account er1adm is instance owner, but when issued the following
command, got SQL0440N error, and was happening for other functions.

I am using column-level encryption (ENCRYPT_CHAR, DECRYPT_CHAR) to
protect selected columns in DB2 LUW v.9.1 and v.9.5 on Linux.  The
ultimate goal is to support the requirements put forward in Payment
Card Industry Data Security Standard (PCI DSS) which states: "Protect

I have a siebel crm application thats cutting and archiving logs every
minute.  Here is the db cfg
Log buffer size (4KB)                        (LOGBUFSZ) = 512
Log file size (4KB)                         (LOGFILSIZ) = 15000