I'm pretty sure I know the answer to this but as a last ditch effort I  
pose the question to this group...Is there a Runtime client for MacOs X  
for DB2 UDB 8.1? I certainly can't find one anywhere but I'm hoping I just  
missed something. We have some developers that need Macs ...

  Is there a possibility to make a delay between two sql statements,
namely one sql statement is performed, then there is a delay of some
seconds and then rhe next statement is performed.
In sybase database, there is  a possibility to do such thing by using

I need to monitor a db2 database from a java application. Everytime any
other application changes a table in the database an event should be
fired containing information which table an which dataset has been
changed/inserted/deleted. I am not allowed to use triggers.

Fails after installation (without error, on XP Pro)) whenever I try to
start it in either Set-up Tools/Configuration Assistant or Set-up
Tools/First Steps with the following message.
'The procedure entry point

I'm now working with DB2, and I can't find out how to execute the
contents of a string Statement, without using a Java/... procedure,
only using SQL statements.
I know that some SQBDs such as SQL Server allows it as the exemple

I have a Windows 2000 Server machine that runs DB2 UDB v7 fixpak 11. I
also have a Java program that uses JDBC to insert data into the
database.
Sometimes, the program encounters SQL0302N error ("The value of a host

This is for SQL stored procedures on OS/390. UDB (for LUW) has a
SIGNAL clause that can be used in SQL Stored procedures. There seems
to be no equivalent on DB2 for OS/390.
For example, I want to roughly emulate the following algorithm on DB2

Does this message mean something to someone? I am receiving it during a
CREATE SQL PROCEDURE statement and am wondering if this could be the
source of the error:
IBM CLI DRIVER SQL30020N   EXECUTION FAILED BECAUSE OF A DISTRIBUTED

I'm having a hard time getting ESE 8.1 to run on a freshly installed
SuSE 9.0 linux box. It was actually up and running, but after a reboot
(one disk in the RAID 5 had to be replaced) it wouldn't start, saying
SQL6048N (communication error, see below).

Our database (DB2 Workgroup 7.2 FP12) is constantly under heavy load.
Most time CPU usage (1 Pentium3 1Ghz) is more 50% busy.
We have 3GB RAM memory
Our normal workload is 200-300 dyn.sql/s.

I'm sure this is really really easy but I do need some help.
I'm writing a java stored prcedure to manage the assignment of IP
addresses to mac addresses for a network device database I've got.
Basically a user fills in a template detailing information about

I want to copy data from our production database to the development
database. I want to move only the data. I do not need the table structure,
constrains or anything else.
I think I can use the db2move command to export out all the data like the

The bind error messages below are returned when running the db2batch
command on Windows NT against an AS/400 database. Most batch scripts
are running without error.
What files and and command need to be run to fix this error?

what's the main scripts and ritual actions besides checking backup,
and db2diag.log you do everyday to manage your DB2 environment on
Solaris or AIX ?
How can check connections, load, tablespaces, catalogs, hit ratios?

DB2 7.2 (7.1.0.68) on AIX 5.2.
I have a query that does a table scan on one database, and an index
scan on another.
The statistics on both databases are up-to-date. Indexes are