Its not on the DB2 supported environment page, but is anyone
running DB2 LUW 8.2 on Red Hat Advanced Server 2.1 (kernel 2.4)?
DB2 LUW 8.1 /is/ validated for Red Hat Advanced Server 2.1.
On OS upgrade is in the works, but I need to upgrade to DB2

I am having a problem with using calculated values in a WHERE clause.
My query is below.  DB2 gives me this error message: Error: SQL0206N
"APPRAISAL_LESS_PRICE" is not valid in the context where it is used.
SQLSTATE=42703

I know that on DB2 V8.2 (on Linux) it wasn't possible to "upgrade" without
reinstalling.
But on V9.1, can I initially install Workgroup, and then if we need
additional functionality can we buy Enterprise and apply the keys to an

Hi hi everyone.
We have upgraded our DB2 LUW 8.2.1 which was directly installed from our
DB2 CD's to DB2 LUW 8.2.6 (FP13). (system: HP DL385 (AMD64), single
socket, dual core. 8GB memory. SLES 10. NetApp FAS250 storage array).

Anybody knows should I also implement Automatic Client Reroute if I did
HACMP and DB2 HADR on AIX?
Thanks in advance,

Iam using the db2load API to write data to a table. I see that by
default the load process creates/overwrites the msgfile. Is there a way
to change this behaviour so that messages are appended to an exisiting
msg file.

I installed DB2 V8.2 on aix 5.3.0.0. When I start DB2, i get the
following error :
2007-01-02-09.51.37.522047-360 E6889C1471         LEVEL: Error (OS)
PID     : 21176                TID  : 1           PROC : db2hmon 0

We are using UDB 8 with net drivers, and trying to set the connection
timeout, by calling DriverManager.setLoginTimeout()
It seems that this setting is not being honored.  We set it with the
following code:

HELLO EVERY ONE !  I  HAVE TO SCHEDULED A TASK TO RUN EVERY DAY AT 4PM,
TO CHECK THE SIZE OF THE NOTIFICATION LOG FILE , IF IT EXCEEDS 5MB,
THEN I NEED TO RENAME THE FILE AND START WITH A NEW ONE .? ANY ONE HAVE
A SOLUTION HOW TO DO THIS ?

How to time the duration of a SQL statement issued in DB2 command CLP?
Aaron

Can i create two instance with same user id in AIX ?
I just need what should be the params to be passed in db2icrt utility..
Thanks in Advance
Ashish Prasad

I am attempting to move data between 2 DB2 Linux databases using a
pipe. I can't seem to get it working.  Any assistance is appreciated.
I first issue:
mkfifo -m777 mypipe

Hi and happy new year
I search a news group for DB2 sql language .
(I need to find primary key on a table name and delete it)
Thanks

Whether is there any way to find stopped/started timestamp of a db2 udb
instance other than the db2diag.log files.Is there any catalog table
available to get the timestamp informations or by using stored
procedures we can get the information's.