When i am trying to take offline backup of my production db .. it is
taking more time in db2stop command (around 15 min.) while earlier max
was 2 mins. what might be the reason for this delay.
To stop the db I am using following sequence of commands:-

Hy,
I am trying to understand how the prepare statement works.
I am using Qt C++ library to access db2:
{

I'm sorry if it sounds off topic but please help m, because your
replies will really effect on my decision:
I have been in touch with DB2 and its administrations tasks, and i
want to extend my abilities on administration part. meanwhile I have a

Is there a mechanism for manually marking routine packages as
inoperative in DB2LUW?
The problem I'm trying to solve is one of recreating interdependent
functions. My application creates a number of functions during its

So I have a good-sized db (~500GB) that's on only SMS tablespaces(ugh,
I know). I'm tight on space and keeping an eye using the
get_dbsize_info function - but the DATABASECAPACITY value keeps
changing. I know on DMS tablespaces, DATABASECAPACITY is tied to the

My Windows DB2 Server 9.x is connected, via federation, to a remote AS/
400 system:
I created several nicknames to remote tables and I can query them.
Problem is, during the night, my remote AS/400 is rebooted and DB2

I'm trying to read up on the possibility to migrate a db2 V9.5 server
to 64 bit, and continue running 32 bit application servers (via db2
runtime client, or otherwise). Does anyone have links to this kind of
information? I've google around a bit, and searched the db2 docs

The problem over  here is when i am  runing these query in test region
it is working fine. but when i run in the production region it fails
and giving error like :
434: An ON clause associated with a JOIN operator or in a MERGE

We have an older Suse linux server with DB2 v8.2 and PHP 4.4.2. The
PHP was configured --with-ibm_db2 and uses odbc_connect(),
odbc_exec(), odbc_fetch_row(), odbc_result().
We have a new Redhat (RHEL5) server with DB2 Workgroup Edition v9.5

I'm getting a large number of paragraphs like this in a db2diag.log:
2008-10-22-09.31.50.339542+120 I277626395A468     LEVEL: Warning
PID     : 1576968              TID  : 1           PROC : db2agntp (SST) 0
INSTANCE: db2inst2             NODE : 000         DB   : SST            

I'm installing DB2 9.1 on z/OS 1.9 and am trying to test DRDA.  Can
anyone tell me where to find documentation on SQL30082N, RC=22?
Thank you,
kk

Is there any way of tracking the isolation level of incoming queries
from the server;  not the client?  The client app is a third party
black box application.  Can't find anything in the snapshots or
activity monitor.

I have compressed table 442992 rows and when i run explain plan on
this table for some SQL using this table, i see table scan and
cardinality on top of table node as 18458. I am new to compression and
do not understand why cardinality is not the actual number of rows but

I was trying to make backup faster so After studying I used this cmd
for backup:-
db2 backup db <dbname>  to /bkup/dir1, /bkup/dir2 compress  without
prompting;

I encounted this error when i restored database.
but the usename and password is right.