We help IT Professionals succeed at work.

Quiesce Database and deactivate/active Database to free memory

itsonlyme4
itsonlyme4 asked
on
368 Views
Last Modified: 2015-12-31
Occasionally we have DB backups fail because of insufficient memory (Db2 9.7 running on a 32bit OS)

What I would like to do is force all connections and Deactivate/Activate the Database like this:

db2 CONNECT TO MYDB;
db2 list applications for database MYDB show detail

# QUIESCE the database to force all connections
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
db2 CONNECT RESET

# DEACTIVATE the database
DB2 Attach to DB2
DB2 DEACTIVATE DB MYDB

# ACTIVATE the database
DB2 Attach to DB2
DB2 ACTIVATE DB MYDB

My question is....   is the QUIESCE necessary or will the Deactivate command force connections???????
Comment
Watch Question

Data Warehouse / Database Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you!!!  

I just posted another question because I issued the db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS and it is hanging..    this is what I'm seeing in the log:

MESSAGE : ADM2017C  The Event Monitor "DB2DETAILDEADLOCK" has reached its file
          capacity. Delete the files in the target directory
          "C:\DB2\NODE0000\SQL00001\DB2EVENT\db2detaildeadlock" or move them to
          another directory.

There are a bunch of .evt file and one .cnt file in the db2detaildeadlock folder.

not sure if I should move them ALL??
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.