473,507 Members | 3,112 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can I put DB2 into maintenance mode for --

Can I put DB2 into maintenance mode to keep all connections closed
except the instance owner?.

DB2 7.2
--
LIGHTNING NEWS
Newsgroup access for as little as $5 per month
Private & Anonymous!
LIGHTNING fast Unscensored Downloads!
ALL THE NEWSGROUPS at www.lightningnews.com
Nov 12 '05 #1
2 1957
QUIESCE command added in V8.1 .

Larry Edelstein

Willard Farwark wrote:
Can I put DB2 into maintenance mode to keep all connections closed
except the instance owner?.

DB2 7.2

Nov 12 '05 #2
See "SQL Reference Volume 2" - CONNECT TO database IN EXCLUSIVE MODE

The description is contained in the explanation of the type 1 CONNECT
statement

Phil Sherman

Willard Farwark wrote:
Can I put DB2 into maintenance mode to keep all connections closed
except the instance owner?.

DB2 7.2

Nov 12 '05 #3

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

Similar topics

5
19459
by: Mark S | last post by:
I have a db maintenance plan which is set to backup (then truncate hopefully) the transaction log. In order to backup a transaction log the db must be in single user mode so the maint. plan fails. ...
1
1964
by: Alexey Aksyonenko | last post by:
I know that SQL Servers can be set up to forward alerts to a single SQL Server. I am wondering if same would be true for the Maintenance Plan Reports. Basically, I want to have only one SQL...
4
11597
by: serge | last post by:
Running SQL Server 2000 Enterprise Edition SP3. The database is also used by Microsoft Project Server 2002 and also has OLAP views, so the database is being used to view/run cubes in the Analysis...
5
1743
by: Jim Andersen | last post by:
Hi there, Used the wizard to create a maintenance plan for a db. But it fails most of the time. I checked the log-files. At 1.00 AM, it runs the "Optimizations" job for 6-9 seconds. It...
1
1514
by: JIM.H. | last post by:
Hello, What is the easiest way to give a system maintenance message to users who try to run an asp.net application. I do not have separate development and runtime environment, I just need to...
1
1676
by: mkhmer | last post by:
Hello, I want to have my site able to alert User and then Disconnect all current user from accessing the pages for website maintenance purpose. If anyone have any idea of this aiming? ...
3
11525
by: vikramp | last post by:
Hi, I want to know how to setup the "Under Maintenance" page for the website? Here is the thing: I have application setting in web.config called "MMode". I set it to "Y" when I need to do...
47
1668
by: editormt | last post by:
Software maintenance is an important part of the software development activity, but it is also the less discussed. A recent poll seems to show that the part of maintenance in software development...
4
3350
by: Mike Gleason jr Couturier | last post by:
Hi, What's a clean way to redirect users on an information page while doing site maintenance... Can we do it with urlMappings !? (wildcard "*"?) Thanks
0
7105
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7371
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7023
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
5037
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3188
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1534
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
757
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
410
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.