We're considering the Power5 hardware platform.
Anybody out there have any experience positive or negative with DB2 in this
environment?
We're curious how much horsepower we need for a rather large data mart.

Hi all, I'm not new to DB2, but I am new to Version 8.  Does this mean I
should increase my CATALOGCACHE_SZ ?  The old diag log messages used to
mention which specific parameter was causing problems, so that's why I'm not
sure.

I have developed a medical application with php 4 linked to IBM DB2
database.
The database connection is right and i can access data with no
problem...but sometimes when i reload the page which has been already

DB2/NT  8.1.3
Sorry for stupid questions. I am newbe in DB2.
1. How can I read *.sql script (with table and function definitions) into a
database? Tool, command...

Is there an Equivalent in DB2 like an Identity Column in SQL Server?
Does it behave the same way  (if ever it exists?).
Thanks,
JWK

On DB2 ESE v8, AIX 5.2
Would it be correct for an application snapshot (global) to show a
status of UOW Waiting when it hasn't returned results but is waiting
for subagents to finish?

You can read the full announcement letter at http://tinyurl.com/3tkr9

I have a table (TAB1) withi has 4 child tables on COL1 with DELETE
CASCADE.
When I delete any row in TAB1, it will delete corresponding rows on
all child tables.

This is my first time here, so there may be earlier relevant threads of
which I am unaware.  Though my experience with DB2 is not extensive,
such as it is was under OS/390 or equ.  My main experience is IMS DB,
which leads to my question.

From a guy in Microsoft newsgroups:

We are on IBM DB2 7.1 ON WINDOWS. The db2diag.log is not working and
no new line written into it for few days. The last lines in
db2diag.log shows:
Warning: active log held by dirty pages.

I'm running DB2 PE on Windows XP Home edition.
I downloaded FP7 (DB2 8.2) from the IBM ftp site and try to create a
database. It fails when using the AUTOCONFIGURE option with the
following message:

We have a WebSphere application that quit working this week.  It was
trying to hit DB2 UDB Version 8 on Linux.  The Driver is DB2 V7.  This
is the message in the WebSphere logs. Does anyone know what may have
happened?

I while ago I posted a suggestion to the DB2 newsgroup:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=6281e9f8.0401120117.7
96c9e6%40posting.google.com&rnum=2&prev=/groups%3Fq%3Darrenbrecht%2BDB2%26hl%3De
n%26lr%3D%26ie%3DUTF-8%26selm%3D6281e9f8.0401120117 ...

When running LOAD with "ALLOW READ ACCESS", I get the following error
if select is running againt the table (isolation UR).
load.sql
---------