Nobody has ever had this error in the history of the internets, except this
IBM page talking about update 1.1 to something called "User Groupies"
   http://tinyurl.com/zlbyo
On our JDBC connection we get a list of the currently reported warnings

Hi to all !!!
I am new working with  DB2.
I have one table with 4 primary key (CLIENTID,
TIMESTAMP,ENTITYTYPE,ENTITYID)

Is it possible to figure out which db a db2fmt process is running
against? If so, how?
Thanx
/Lennart

could you please advice on how to measure replication performance
in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ?
I've got two servers with databases installed and configured,
I prepared set of data using DBGEN from TPC and I already imported them

I'm having a tough time trying to run this stored procedure in DB2 UDB
8.1 environment. Can someone help me out here. All I'm trying to do
here is update an indicator 'N' if it is a NULL. Approximately 8
million rows will be updated as a result. I'm a newbie to DB2 and

When I do a LIST HISTORY BACKUP, the following is shown the O/P.
----------------------------------------------------------------------------
   Comment: DB2 BACKUP ABCD ONLINE
Start Time: 20060823230001

I get the following error in the query
SQL0415N  The data types of corresponding columns are not compatible in
a
fullselect that includes a set operator or in the multiple rows of a

I am trying to do the following from within a procedure.
set vcsql = 'Call SYSPROC.ADMIN_CMD(' || '''load from /dev/null of del
replace into bi.Provisioned_Spam''' || ')';
    execute immediate vcsql;

Some time ago I asked in this conference, - How to use an ONLINE BACKUP to restore database onto another system? - but got no answers. Therefore I can conclude it is not possible.
But... what can I do with "online backup", really ? What is it needed for ?  I do not see any ...

We are prototyping an application that is inserting 500 rows into a
table.  One method is to using batching and make one database call to
insert all 500 rows, the other method is to make 500 database calls
insert 1 row each time.  The problem is that the batching method is

Thanks.

Well folks, I didn't heed the warnings (that excessive monitoring,
statistics, etc. can cause a performance hit) and I have been playing
around with all kinds of monitors, snapshots, especially with the gui.
BUT! Performance has dropped 70%! The monitors show that the the most

Is there a way to determine if a backup image includes logs, i.e. was
produced by BACKUP DB command with INCLUDE LOGS option
Thanks,
-Eugene

I am using DB2 UDB v 8.2 , OS: RHEL . Now, How to get the Bufferpool
Hit Ratio?

Friends:
I have a query similar in structure to the following:
SELECT
    T1.IBMREQD