Until today I always thought as long as you see a lot of logical reads
as compared to physical reads, then you're good. But it looks like it
isn't so. But doesn't logical read mean it's being read from memory
and no I/O involved? So why is Logical Reads = CPU Consumption ?

Environment:
Only one database per instance however each application is given it's
own schema.
My objective is to compute the space utilized by each application on

Environment:
Only one database per instance however each application is given it's
own schema.
My objective is to compute the space utilized by each application on

we have os/400 db2 database at the backend.
i installed db2 v9 connect server on one windows server which is
locating the same network with database server.
now how to i configure the connect server and client, so client could

i am new to DB2, please be patient with me.   i have a lot of informix
experience and some oracle.
i am trying to do a "db2 rollforward database QA4 to end of logs OVERFLOW LOG
PATH (/db2/QA4/log_dir)"

UDB Version 8.2 FP7 (r"DB2 v8.1.1.128", "s061108", "U810098", and
FixPak
"14".) 64 bit running on AIX 5.3.
We were getting the SQL0668 error below so we put the status sql into

for the conext of this example imagine a simple part table where a
part can only have a single parent. try to express a cte where the
result set must be balanced. That is, the result set repeats node B
and E sufficient times that the tree is as deep as node G.

Is this possible?  I'm getting a 32bit/64bit compatiblity error when I
try to test the connection.
Thanks,
Eric

Has anyone done some tests/migration from a multi partioned db to non-
partitioned db? Any idea, hints, articles would be helpful.
Thanks in advance.
Bye,

I'm working on a DB2 project (my background is Oracle), and have been
approached by one of the developers with a problem. He claims he's
seen evidence of this problem before, in other circumstances, and I'm
curious whether anyone can suggest a reason for what's happening.

Whenever I am trying to run a program with our systest region our
program ends with the U1551 & system displays the following statement
      IEF450I Jobname Stepname - ABEND=S000 U1551 REASON=00153504
I couldn't able to find out any explanation from the job

while trying to drop a table, i am getting error that the function is
dependent on the table. hence it cannot be dropped.
Is there some way that i can get directly all the functions dependent
on the table, one shot.

The filestore is filling up rapidly, I'm not archiving logs.
It appears that the data files for the database are just growing.
This is some output from list tablespaces show detail:
 Tablespace ID                        = 2

how to identify whether duplicate identity column values existing on a
table or not.
i have four tables and all the table have row_sk defined a identity
column, the start and end values are different acroos all the tables.

I asked this question a slightly different way earlier and didnt get a
response so I thought I would rephrase it.  I contacted db2 support on
it also but never got a definite answer..I got a lot of "should be"
and "maybe".