473,320 Members | 2,027 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Quiesce behavior

Hi,

When executing a quiesce immediate on a database does the command
wait for all connections to be off the database before completing or
does it act asynchronously?

Lew

Jun 19 '06 #1
1 1381
If you look up DB2 documentation, you will see that it has an option to
"force connections". If you do specify it, then it will force
connections. Your options are -
(1) wait for all transactions to commit
(2) wait a specified time for transactions to commit (if they do not
commit then force the connections)
(3) force them immediately
se*****@yahoo.com wrote:
Hi,

When executing a quiesce immediate on a database does the command
wait for all connections to be off the database before completing or
does it act asynchronously?

Lew


Jun 20 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: JS | last post by:
Can somebody explain how to get the tablespace out of quiesce mode? I am executing on each node of my EEE Win2K system: db2 quiesece tablespace for table schema.tablename RESET I get the...
1
by: Dale Franklin | last post by:
WRITE(YES) externalizes buffers to disk. WRITE(NO)does not. My question: why externalize to disk WRITE(YES) when WRITE(NO) will do the job when recovering to the quiesce point? Thanks!
0
by: beneisenstein | last post by:
We have a requirement for an application point in time recovery. This is basically a point before processing data that we would like to be able to rcover to. The environment is db2 v8.1 aix. We...
1
by: BobTheDatabaseBoy | last post by:
LUW/8.1.6 dropped a table at the behest of others. turned out it was in use. the drop seemed to go normally, and the table disappeared from the displays (control center and aqt), but the...
19
by: E. Robert Tisdale | last post by:
In the context of the comp.lang.c newsgroup, the term "undefined behavior" actually refers to behavior not defined by the ANSI/ISO C 9 standard. Specifically, it is *not* true that "anything can...
1
by: AVICENTE | last post by:
First, I´m sorry for my English... Always I quiesce a database, the instance crashes. This occurs only with one database, I can quiesce other databases in the same instance and nothing occur....
2
by: kaissoun | last post by:
hi, i have DB2 8.2 on linux and when i start a script to backup the DB , i receive this message on db2diag.log; ADM7508E Database quiesce request has failed. The sqlcode is "-1044" and there no...
1
by: sethwai | last post by:
Hi, I can't think of a reason one might need to use the quiesce tablespace for tables command. Can anyone come up with a scenario when it might be beneficial or even mandatory to use the...
1
by: bic1ster | last post by:
I have a script to do this: CONNECT TO mydb; QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS; CONNECT RESET; backup database mydb to e:\sqlbackups\mydb compress; CONNECT TO mydb; UNQUIESCE...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.