Is there a place in the catalog tables where I can get info about non
recoverable loads performed on the tables. I use list history command
to get the info about loads but it's not granular (nonrecoverable or
not) but I can get the table names.

Folks:
Is there a DB2 version I can install on my laptop ? Single CPU (not
dual core/processor) with 1GB RAM -
DB2 9.1 Express-C - I thought needs 4GB or is it upto 4 GB and dual-

I have setup a HADR between two servers in different locations.
When I compare the application response time in standard environment
and in HADR environment,
I find the latter is more than twice slower than the former. I have

Is there a db2 tool or utility that will map Oracle structures and
data to DB2?
For instance, Microsoft has a tool called "Microsoft Sql Server
Migration Assistant for Oracle".

1.) What is the Compress option in Backup ? How can we find the size
of the compressed
    image ? What is the db2adutl command ?
2.) Suppose I take a backup image in DB2 UDB 8.1 Fixpak 7 and my O.S.

            Actually i was facing a very strange problem...
Can anyone let me know how can we compare the ids which i get from
"ps" and from "db2 list applications"...
Help me out regarding this...

didn't find a thread here, and a search of the Redbooks came up with
166; a bit too much to download.
Q:  if default isolation is Row, does DB2 escalate through Page before
going to Tablespace?

I have previously posted in this subject, but this is different, and,
I hope, easier:
Given I have a database in Win V9.1.2.
All data are relational.

               Some time back I got some good advice from this group.
Again got stuck with something.
I am using export utility to store data to flat files.
For now I am using the following:

I have write connection to remote database (DB2)  with the aid C/C++,
but i can not install DB2 client software (everything that will be
wanted for connection i must place in application, possibly - i can
add some libraries DLL in folder with application.

I am running V9 FP2 on DPF.  I understand that V9 LUW now lets you
rename a column.  I can't seem to get the sytax right.  Can anyone
point me to what is wrong?
db2 "ALTER TABLE myschema.mytable RENAME COLUMN  current_colname to

I previously posted this to the DB2-Express-C forum at ibm.com, but
this group seems to get more traffic so I've reposted it here. The
previous (off-group) post is at the URL below and unless anyone can't
access it I won't repost the attachments inline here.

I'm a sysprog who is new to DB2.  I've installed both QMF & SPUFI.
SPUFI seems far more flexible than QMF.  Could someone explain the
difference?  What does QMF do that SPUFI can't?
Regards,

I have DB2 8.1 Express edition installed on windows 2003.
When I start DB2 service using 'db2start' or 'net start db2' I'm
getting error code: SQL1042C.
The DB2 service returns -1022 code.

DB2 8.2 LUW FP14
Is there any real difference between
  select blahblahblah... where blah IN (select blah......)
versus