RE: DB2 BACKUP QUESTION

RE: DB2 BACKUP QUESTION

 

  

use ... "db2 deactivate db RRC"

after ...
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS..

Thanks

Amit Rai
-----Original Message-----
From: Younik Lee
[mailto:db2udbdba-ezmlmshield-x77146751.[Email address protected]
Sent: Tuesday, October 26, 2004 7:34 PM
To: LazyDBA Discussion
Subject: DB2 BACKUP QUESTION


I am trying to back up the DB and getting error "The database is currently
in use".

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
DB20000I The QUIESCE DATABASE command completed successfully.

CONNECT RESET
DB20000I The SQL command completed successfully.

BACKUP DATABASE RRC TO "D:\DB2_BACKUP\" WITH 1 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING
SQL1035N The database is currently in use. SQLSTATE=57019

Any idea ?


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================

DB2 & UDB email list listserv db2-l LazyDBA home page