We run DB2 udb version 8 on HP-UX 11.11. I am looking for some monitoring
scripts for perormance tuning and daily monitoring. Could some one point to
me a place where I can get them?

I'm replicating 65 tables and want to stop one of them from being
replicated. I thought all I had to do was uncheck the "Data capture for
propagation" option in the table properties, but that didn't seem to work.
Next I was going to try removing the table from the "Replication ...

Hi,
In a SQL SP we want to use the following predicate(to allow
for the case where the variable isn't passed/set).
WHERE

My database is suffering from poor performance of late. Reports that
used to run in a reasonable time, now take a while. The explain output
show that the query is fully indexed, and the statistics are up to
date. Using a statement monitor I was able to determine that a

W2K, DB2v7, FP11.
In ftp://adm-gw.vsi.ru/pub/barinstain/db2v7fp11bug
1. ixfs.zip - zip file (~50K) with *.ixf files.
2. load.txt - script for creating db, tables and views, loading tables.

We have some problems with DB2 V8 on Linux. DB2 showed SQL 1042. So we
restored the last online backup successfully. But because there are only
2 log files rollforward is not possible. Is it possible to tell db2 that
it should forget about the rollforward pending (not to care about

DB2 V7.2 WSE, Service Pack 10 on Windows 2000 Server.
Application access DB2 fail, I found this error message in DB2Diag.log.
String Title:locklist PID:956 Node:000
Check C:\PROGRA~1\SQLLIB\DB2\l51501.000 for additional data.

I'm quite new to DB2 and have the following problem:
I have binary data (ca. 70,000,000 entries per file) that needs to be
processed in a C-Program, afterwords it should be loaded directly into a db
table, which makes loading from a source file not an option.

How do we find the package that is created when a stored procedure is
built ?
If I want to rebind a package related to a stored procedure, what
command should I need to run ?