I'm looking for a DB2 "explain plan" command on the As/400.
Anybody know if this exists and where to find it ?
TIA
    Chris

We've run into a concurrency issue I do not have a clear solution for.  In a
DB2 UDB 7.2 database, we have several tables with a chain of foreign key
relarionships:
Table1 primary key x

Just a quick note to report on the resolution of a problem that gave me
serious grief in January. I put it aside for a while and, largely by
accident, found the solution a few minutes ago.
In short, I found myself getting SQL4301N Reason Code 4 - "The Java

hi, we are using db2 udb v8.1 ESE with type 4 jcc driver. since DB2
can't support pessimistic locking , and our application required that,
which means when both users try to access the same record with intent
to update, the first one grab the record will create a row lock on the

I'm trying to find an easy, efficient and safe site-to-site
backup/failover solution.
The idea is to have anytime a remote copy of 99.99% of the data.
Productive db -> VPN (internet) -> Backup site

I am having trouble calling a UDF from a 'before update' trigger
whereas I have no problems calling it from the 'after update' trigger.
The trigger is as below :
CREATE TRIGGER foo

As I wrote last week, we have a problem with a DB2 V8 on Linux. Here is
what is in db2diag.log during online backup:
Starting a full database backup.
2004-04-01-02.33.54.760164   Instance:lzgneu   Node:000

Hi to all,
I’ve a table with an idendity column :
CREATE TABLE USRDB2.MYTABLE (
"ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 0,

Is anybody out there pushing the memory limits ( for shared memory )
with DB2 version 8 on LINUX.   The Advanced Admin IBM Press Book
claims that kernel 2.4 can only grab 1.75 GB. We have just gotten
RedHat Enterprise Linux AS release 3 ( kernel 2.4.21-9.0.1.ELcustom)

I am looking for the db2ptree program/utitlity on HP-UX. I have heard lot of
good reviews for db2ptree on Solaris.

IBM DB2 UDB 7.2
Red Hat Linux 7.3
Restore from backup image on tape returns:
db2 "backup db test to /dev/st0 buffer 32"

we're using DB2 7.2 FP 11 on WinNT machines, today one server was down,
because the complete directory E:\DB2\NODE0000\SQLDBDIR was gone.
Question: I restored this directory from a TSM-backup, but could I
have done something else?

I just installed FP 5 of UDB 8, and I don't know if that was what did
it, but under ctl-panel/admin tools/odbc, I don't see an entry in the
"drivers" section for DB2.
I'm losing my mind with all of these little "gotcha's".  ARRRGGGGHHHHH

Can you configure DB2 SMTP parameters after creation?
I need to change my SMTP server so my contacts will work
Using 8.1 in Windows Fixpak 5?

I'm getting this error when I submit the job:
DSNU000I    DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = LOADSQL
DSNU005I    DSNUGPRS -   EXEC SQL
DSNU082I    DSNUGPRS - INVALID KEYWORD - EXEC