We are currently installing a DB2 V9 ESE on a Linux server
(RHEL4U4-x86_64). Installation runs successfully on each node. Database
user environment is OK and the instance is well created. To be sure,
we've started the database with db2start => successfull. And then shut

I am hoping to get your opinions about "Tivoli Monitoring for
Databases". Our enterprise environment is AIX/Red Hat Linux, running a
lot of IBM P series and E servers. We need to monitor LUW UDB
performance and some MS SQLSERVER performance going forward.

Is it possible to install DB2 ESE v9 using only console without
graphical wizard and Xwindows ? The command db2setup DB2.ESE (used in
v8.2) doesn't work.
Thank you for any information.

Plz help.
1. how can we give tsm as overflowlogpath in rollforward command, if
it is not being used as logarchmeth1 (db2 searches this dir)
2. how can we change the load copy file's directory, since I dont have

My application connects to a DB2 V8.2 EE database running on AIX. I
need to now lookup a table in SQL SERVER via the DB2 connection.   I
also need to run an sql that joins a DB2 table with an Oracle table.
How can I accomplish this ?  Do i need a seperate product ?

I have encountered a very strange situation.
I just changed my laptop and installed db2 Administration client.
I run a db2 CLP ranning  statistic on 500 tables from my db2 command
window on my laptop and the

I'm using DB2 database on one server and ORACLE database on the second one.
I want to move some data from ORACLE database to DB2 database and update
some columns on ORACLE database so I know what rows were transfered. I'd
like to do this in a distributed XA transaction and Java. :)

I'm having problems connecting to my new v9 db box. The pertinent
information is below:
DB2_db2inst1    60000/tcp
DB2_db2inst1_1  60001/tcp

DB2 LUW 8.2
We would like to implement a trigger to stop an insert or "empty
row" (under certain conditions), but not to throw an exception back to
calling application i.e the calling application would be unaware that

I've hit an interesting trap trying to migrate data off an OS/2 server
running version 7.2 (fp14) over to 8.2 on Linux.  Seems that one table has
a column defined in the DDL as "BIGINT NOT NULL GENERATED ALWAYS AS
IDENTITY (START WITH +1, INCREMENT BY +2, NO CACHE)".  Any rows in ...

How to convert the ZRC code to "-902 rc = 28"? Thanks in advance!
ZRC=0x8136001C
That maps to a -902 rc = 28
James

Anyone know how to monitor db2 trigger activity ?
We suffer some trigger issue , and we try to monitor trigger's
behavior use event monitor and db2audit, but both tools can not get
trigger's sql statment and cost, have other tools can get trigger's

Problem: after inser trigger encounter error sql0348
Env:db2 v8 + fp 13 + win xp
Description:
we build two after insert triggers DB2.TRG1, DB2.TRG2 on base table

I have a number of SQL PL stored procedures (DB2 UDB 8.2 on Windows)
that were created in the DB2 Development Center.  From there I can run
them just fine.
When I use another tool (WinSQL) and attempt to run while connected to