473,386 Members | 1,652 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,386 software developers and data experts.

Database connection

Uma
HI..

Is there a way to prevent users to connect to database for specified
period of time . (Eg: If a user try to connect to Database between
1:00 am - 2:00 am , he shouldn't get the connection. But after 2:00 ,
he should)

Any ideas..

Thanks
Uma
Nov 12 '05 #1
4 3515
You could write some sort of script that quiesced the database at 1 am
(and/or connected to the db in exclusive mode) and then UNQUIESCEd the
db at 2 am.

Uma wrote:
HI..

Is there a way to prevent users to connect to database for specified
period of time . (Eg: If a user try to connect to Database between
1:00 am - 2:00 am , he shouldn't get the connection. But after 2:00 ,
he should)

Any ideas..

Thanks
Uma


Nov 12 '05 #2
Ian
Uma wrote:
HI..

Is there a way to prevent users to connect to database for specified
period of time . (Eg: If a user try to connect to Database between
1:00 am - 2:00 am , he shouldn't get the connection. But after 2:00 ,
he should)


In DB2 V8 on LUW, you can use the QUIESCE DATABASE and UNQUIESCE DATABASE
commands. You would need to schedule jobs to automatically do this on a
schedule.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #3
Uma
Hi Ian ..

Thank you very much for your response . I am using V7.2 with FP11 . I
can't use QUIESCE Database command . any other Ideas ...

Thanks
Uma

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...
Uma wrote:
HI..

Is there a way to prevent users to connect to database for specified
period of time . (Eg: If a user try to connect to Database between
1:00 am - 2:00 am , he shouldn't get the connection. But after 2:00 ,
he should)


In DB2 V8 on LUW, you can use the QUIESCE DATABASE and UNQUIESCE DATABASE
commands. You would need to schedule jobs to automatically do this on a
schedule.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Nov 12 '05 #4
You can use these commands in v7:

db2 force applciations

db2 connect to database <<dbname>> in exclusive mode

....that will keep non-SYSADM users off the system.
Uma wrote:
Hi Ian ..

Thank you very much for your response . I am using V7.2 with FP11 . I
can't use QUIESCE Database command . any other Ideas ...

Thanks
Uma

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...
Uma wrote:

HI..

Is there a way to prevent users to connect to database for specified
period of time . (Eg: If a user try to connect to Database between
1:00 am - 2:00 am , he shouldn't get the connection. But after 2:00 ,
he should)


In DB2 V8 on LUW, you can use the QUIESCE DATABASE and UNQUIESCE DATABASE
commands. You would need to schedule jobs to automatically do this on a
schedule.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----


Nov 12 '05 #5

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

Similar topics

3
by: Mudge | last post by:
Hi, My hosting provider only allows me to use 50 connections to my MySQL database that my Web site will use. I don't know what this 50 connections means exactly. Does this mean that only 50...
11
by: pradeep_TP | last post by:
Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...
3
by: R Reyes | last post by:
Hi, I'm trying to modularize my database connections a little better and get more out of my project with less code. First check out this common dbOpen() function inside class clsDatabase. I...
14
by: Nick Gilbert | last post by:
Hi, I have an asp.net application which runs from a CD-ROM using Cassini. As such, it is single user only. The application connects to an Access database when it is loaded, and keeps the same...
7
by: Lau Lei Cheong | last post by:
Hello, Actually I think I should have had asked it long before, but somehow I haven't. Here's the scenerio: Say we have a few pages in an ASP.NET project, each of them needs to connect to...
3
by: Martin B | last post by:
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...
35
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...
6
by: Arsalan Ahmad | last post by:
Hi all, I am creating a website in which in an Item detail page there are a number of web controls (7 or 8) and what is happening that inside each of control's Page_Load() function I am creating...
22
Frinavale
by: Frinavale | last post by:
How To Use A Database In Your Program Many .NET solutions are database driven and so many of us often wonder how to access the database. To help you understand the answer to this question I've...
1
Curtis Rutland
by: Curtis Rutland | last post by:
How To Use A Database In Your Program Part II This article is intended to extend Frinny’s excellent article: How to Use a Database in Your Program. Frinny’s article defines the basic concepts...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...

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.