We are getting this error during a large large load.
2006-06-03-02.58.31.688266   Instance:sieinst   Node:000
PID:1286274(db2agent (SRMW) 0)   TID:1
Appid:GAFE423C.P4CE.0671B3070116

Hello I recently upgraded my db2 to 8.1 fixpak 11 and have been having
trouble setting up alias connections to the newly upgraded database.  I
believe I had this problem before and can't seem to find the commands
to bring the new database forward for connection purposes was ...

I have the a hypothetical DB2 DETAIL table which includes the following
columns:  TRANS_TYPE, TRANS_AMT.
All TRANS_AMTs are positive, but TRANS_TYPE of 1 indicates a credit
(positive), and TRANS_TYPE 2 indicates a debit (negative). I want to write a

hai everyone......
            Can anyone pls explain me what is this DAS exactly
for...... sorry i know this is a silly ques......... because i dropped
even then my Control center is working , my CA is working...... in my

I am trying to create a simple stored procedure:
CREATE PROCEDURE purgeTable(IN tname VARCHAR)
LANGUAGE SQL
BEGIN

I have a tablespace that contains the LOB data for 3 tables which exist
in other tablespaces.  Even after reorging the LOB tablespace with the
LONG option, the high water mark is still too high.  I want to be able
to shrink the tablespace below the current high water mark and return

Hi! I've been using Intelligent Miner for Data (IMD) since 1 week and I
was able to generate some results. However, I would like to know more
about the algorithms that are used by IBM (ie in the
Association/Clustering/Classification mining methods)

I am getting  -911 on online incremental or delta backup , anybody have
any explanation, backups go to tsm.
thanks

I am using DB2 Z/OS V 7.  I am setting up a REORG job for an OLTP
database.
If i am taking REORG with SHRLEVEL CHANGE with COPYDDN , can I use the
IMAGECOPY taken from the INLINE copy to restore the tablespace (TOCOPY)

My client is bugging me for a solution to this problem!
I am still getting "Password Invalid" with all new users I define on my
linux box. I have tried all the suggestions made here and they made
exactly no difference. I have server authorization set. I do have

Running DB2 8.2 on AIX 5.2
I have a question on reorgs and reorgchk results. My reorg script is
using the db2reorgchk (which I understand has certain limitations) to
determine if a table or an index needs to be reorged. The presence of

I have posted this question on IBM's DB2 forums without much success
and I hope I'll have success here.
I would like to know if there is a way to create a scheduled job in DB2
(I'm using DB2 8.1 on Linux) without having to use the DB2 Task Center

One of my query is comparing 2 columns in a 'where' clause: COL1 CHAR(3)
and COL2 CHAR(8).
Is there any overhead involved in performance as compared to if both
datatypes are CHAR(8)?

I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.

Dear IBM DB2 support,
I wish CLP would have been more functional. Without living the command
line I would like to get  sql return code explanations, scalar function
definitions etc..