I am having difficulty understanding the relationship between the dbm
event monitor switches and the db event monitor switches.
If a monitoring application (Quest, BMC etc) turns on an dbm event
monitor switch it is able to collect information about the database,

So, we've got UDB 7.1 installed on our HP 9000 L1000 server running
HP-UX 11i and I'm trying to install UDB 8.2.  The installation process
dies somewhere between the 50% and 75% completion point with an error
and the generated error log:

I have a problem, and would like you input...
I need to evaluate to columns and then base a third column on their
values. But, I need to include NULL values and this statement isn't
working, what am I doing wrong?  Is this possible?

With the MERGE statement I am using in DB2 it rolls back all the way if
an error is encountered. Is there a way to save each of the encountered
exception but proceed to the next data record rather than a complete
rollback? Any help regarding this would be appreciated.

despite the disk is not full but i have this message :Media controller
-- Disk full encountered

I have a problem with moving the backup of my database from machine to
machine.  The size is 17 Gig and my network keeps timing out when I try
to ftp it from machine to machine.  I have had the situation where I
ended up with a backup that was in several pieces.  the files were

I am trying to use the IBM DB2 Universal Database driver (IBM JDBC
package). How do I wrap an Oracle connection within an IBM connection?
Is it possible ?
I tried searching through the documentation and the Internet, but

An ORDER BY a simple-integer inside a FUNCTION, results in SQL0440N,
unless the FUNCTION expects an INTEGER as its parameter. For example:
DECLARE GLOBAL TEMPORARY TABLE A(A CHAR(1))
INSERT INTO SESSION.A VALUES ('a'), ('b')

All I can see that viper adds is XML handling. Is there a list of other
new features in
Viper?

Pure curiousity. Can DB2 run on a Sun Fire T1000-server machine with
the new  UltraSPARC T1-processor (Niagara) and if so what kind of
performance is to be expected and what pricetag would it have for let's
say an Enterprise Server Edition?

I tried to backup a database with
db2 backup database mydb, and (after a few minutes) received this
error:
SQL2048N  An error occurred while accessing object "Tablespace: 0,

DB2 V8.1
I find out there are some non-existing tables from
ASN.IBMSNAP_REGISTER. Why did this happen? Can I just delete them from
ASN.IBMSNAP_REGISTER?

I have a AIX backup of DB2 (8.2) and i was told i needed to have a unix
OS installed to be able to restore this database. So now i have
installed Solaris 10 (x86 hardware). I copied the DB2.tar file to a
folder i created in /export/home/db2, and unzipped everything. My issue

I have a column of type VARCHAR, storing some generally character data.
A few of the values in that column are in fact numbers represented as
strings (e.g., "12345").
At some moment I need to select those numbers, cast them to INT and do

I have a following issue in DB2 UDB v8.2. How can I build some data and
store it in a temp table and return as a TABLE to a function.. This
function will be called in a SELECT stmt. something like
SELECT .... FROM TABLE(GetRecursiveCDOs()) AS RecursiveCDOs()