Avatar of itsonlyme4
itsonlyme4 asked on

Quiesce Database and deactivate/active Database to free memory

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???????
DB2Databases

Avatar of undefined
Last Comment
itsonlyme4

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kent Olsen

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
itsonlyme4

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??
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes