I am getting DB in use error when I try to backup using command line or GUI..
Here is the command I use and error....I am new to DB2..:-(
CONNECT TO AGILE;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE AGILE TO "D:\IBM\SQLLIB\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO AGILE;
UNQUIESCE DATABASE;
CONNECT RESET;

---------------------
SQL1035N The database is currently in use.

Explanation:

One of the following conditions exists:

o Exclusive use was requested, but the database is already in
use as a shared database by another user (in the same
process).

o Exclusive use was requested, but the database is already in
use as an exclusive database. (Two different processes are
trying to access the same database.)

o The maximum number of connections to the database has been
reached.

o The database is being used by another user on another
system.

o Activate/Deactivate database is in progress.



The command cannot be processed.

User Response:

Possible solutions include:

o Resubmit the command later when the database is not in use.

o Change the authorization to match the current user or wait
until the database is not in use.

o Wait until the database is not in exclusive use.

o Wait until other users on another system have disconnected
from the database.



sqlcode : -1035

sqlstate : 57019

-------------------

Use "DB2 LIST APPLICATIONS" to see users connected to DB2.
If you want to backup the database when users are connected, use "online backup" (log archive).

Just a note that QUIESCE only works for non-admin users, so if you have any users connected with SYSADM, DBADM, etc. they will maintain their connections.

The only sure way to force everyone off is FORCE APPLICATIONS as noted above.

If nothing else works,

db2 force applications all;db2 deactivate db xpsdb;db2stop force; db2start;db2 activate db xpsdb; backup command.

all in the same command line.

Thanks a lot guys. it works.