Can any body tell me what is pureXml what r the advantages of this
technology
and for what resion is so usefull...

In our environment we have one RAID10 volume builded on 16 disks (IBM
EXP810 enclosoure) and 3 logical drives on this volume for our
databases.
All tablespaces in databases are created with 4 containers per

I am new to db2 so i am little bit confused. I have written a trigger
on a table on after insert. what is this doing -
22222,    "10066",                     2007-06-20-15.28.56.041000
33333,    "10066",                    2007-06-20-15.28.56.041000

I have a big DMS tablespace with large container span across 3
filesystem on DB2 v8.2/AIX5.2. Each container is of different size on
each of the filesystem. Looking for some suggestion/advice on how to
remove large container and create new one with the same size as the

I have a question regarding the CPUSPEED on the DBM config.
When I installed the DB2 the CPUSPEED came to be 3.818116e-07 ?
When did a update dbm cgf  using  CPUSPEED -1. It came up with a
higher number and when I did this again, it again came up with a

Good morning :)
I'm trying to get useful performance information from my DB2 v8.2
server on Linux.
I'm asking your help to see if it's possible to have this kind of

Occasionally, regular online backup fails with sql0911 reason 68,
"lock-timeout" seconds after the command is issued.
Normally a second try is successfull. The database is always in use.
Can someone technically explain why this happens, which locks (type,

we r getting Package "NULLID.SYSLN31E 0X5359534C564C3031" was not
found error in our production server..
when v check with  "select * from syscat.packages".. that package
SYSLN31E is not listed there..

   I inherited an AIX box (5300-06)  with Client install... (I think
it's only client).
How do I check the type of Client (Admin vs Runtime vs Application
development ) on AIX ?

All,
   We have revoked  all Sytem privleges (BINDADD,
CONNECT,CREATETAB,CREATE_NOT_FENCED,IMPLICT_SCHEMA etc)...from Public.
However Public continues to have select privleges on the system tables

Thank you.

If i want to disconnect all the connections to a particular database,
what should be done....
db2 force applications all....
will not be preferred since it'l close all the connections to all the

I have a reporting database running DB2 LUW 8.2 on a RedHat Linux. It is
configured to archive log files automatically. I notice that although no
activities on the database, it keeps archive the log files frequently. Each
archived file has the same size, which is about 12288 bytes. ...

Hi there, I am writing a query in DB2 which needs to return a result
set, i want to be able to use a couple of variables in query to speed
things up.
Please can anyone tell me how i may do this? Is it possible to do this

Folks,
 Where can I find documentation on developing stored procedure that works
 on DB2 Z/OS and LUW?
 I am also looking for documentation on how to create/use cursors in stored