Db2 v8.1.3 ,Windows
I am seeing this message quite often in db2diag.log
ADM5502W  The escalation of "1205" locks on table "SYSIBM  .SYSCOLDIST" to
lock

I am trying to laod 2 tables and set integrtiy on them, but the second
tables fails ( both are related and SET INTEGRITY ion first table
succeeds) saying constraint violation....is there a way to find out
which records are violating....?? may be through try catch a

People I am getting the following error in the db2diag.log file
repeated over and over again with no apparent reason or souce.
2006-04-03-22.17.10.279000-240 I6310H330          LEVEL: Error (OS)
PID     : 2372                 TID : 2012

now we have some troubles with restoring a db with the vendor apis of
the backup and restore utility.
We upgraded from db2 version 7 to version 8.2 (windows 2000
environment).

i have a batch file db.bat which will create the database and objects
with in it.
inside that batch file i'm trying to execute  two more batch fiile
which will be pointing to producation data file as bellow.

I am writing Import\Export routine in DB2 using stored procedure and
front end as JAVA.
For this I have two option
1) Writing five different stored procedure returning one cursor

This is probably a really dumb question but I have a table containing a
varchar 4000 column.  The app team is asking me to index this column to
improve performance.  I know this can't be done but I'm looking for
proof of the max length of the index key column in the DB2 doc and I

I  want to catalog a database and I have the follwoing information with
me.
Node name                      = abcdef
Comment                        =

DB2 8.1 FP 7a on AIX 5.2.0.
Can anyone tell me how best to reduce high CPU (and subsequent high IO)
associated with db2pfchr processes?
NUMIO_SERVERS is set to the default 3. A grep on these prefetchers

Our company is now trying to make a "standard" of creating a base
view for each user table. This initiative is suggested as a good
practice by a data modeling consultant who is helping us to build DW
logical/physical model.  He pointed out that the work and risk of

My question is a follow up on a recent thread (db2_evaluncommitted)
If I have a table with say a  million rows and a predicate of my update
clause matches say 8000 records,
does db2 only lock 8000 records or does it lock records that it evaluates

I am facing the problem while inserting the spanish characters in the
DB2 UDB v8.2 database. We are pulling the data from SQL server through
informatica and then pushing the same in the DB2 database. Codepage for
DB2 database is UTF-8, which is Unicode. Whenever it is encountering

I am creating a procedure A which is creating a global temporary table
DECLARE GLOBAL TEMPORARY TABLE session.temp (Service CHAR(2),
CustomerServiceTypeId INTEGER)
 WITH REPLACE

Linux RedHat AS4 running DB2 V8 FP11.
I have followed the docs at http://tinyurl.com/qckrn and enabled
automatic statistics collection. It has been 2 days since I updated my
DB cfg and I don´t see any activity regarding auto runstats.

Can anyone tell me why a EEE system might be created to have two
separate tablespaces with the same 4k pagesize ?  They both appear to
be in use as I can see the underlying files being modified.
These were created with SMS and reside on the same disk and filesystem