473,325 Members | 2,608 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,325 software developers and data experts.

how to shutdown only 1 database in a

Hi

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to
completely "shutdown" 1 database and the rest 4 databases should be
avaialable...the database should not be avaialable to anyone and
including the DBA...is there a way of achieving this??
************************

Pls advise.

Reg
Ram

Nov 19 '06 #1
6 1591
ra*******@gmail.com wrote:
Hi

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to
completely "shutdown" 1 database and the rest 4 databases should be
avaialable...the database should not be avaialable to anyone and
including the DBA...is there a way of achieving this??
************************
A bit of an odd request. The DBA is all about managing databases...
Anyway here is one idea that may work:
Create a second DB2 instance for which only "you" have access.
To lock a database from the regular instance, simply activate it using
your special instance.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Nov 19 '06 #2
Serge Rielau wrote:
ra*******@gmail.com wrote:
>Hi

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to
completely "shutdown" 1 database and the rest 4 databases should be
avaialable...the database should not be avaialable to anyone and
including the DBA...is there a way of achieving this??
************************
A bit of an odd request. The DBA is all about managing databases...
Anyway here is one idea that may work:
Create a second DB2 instance for which only "you" have access.
To lock a database from the regular instance, simply activate it using
your special instance.
On second thought. I'm not sure if/how you can lock other DBA's out
throught the instance. After all DBA privilege is a _database_ privilege..
Maybe soemone else has a better idea or a way to finish my thought.
Of course you could always simply revoke DBADM from your DBAs....

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Nov 19 '06 #3
First of all, this is a good reason to use the "one database per
instance" paradigm.

Secondly, there is some granular control of who can access a database
using the DB2 QUIESCE DATABASE command. Don't know, however, if you can
prevent a DBA from accessing it.

From the DB2 pubs:

"After QUIESCE DATABASE, users with sysadm, sysmaint, sysctrl, or dbadm
authority, and GRANT/REVOKE privileges can designate who will be able to
connect. This information will be stored permanently in the database
catalog tables.
For example,

grant quiesce_connect on database to <username/groupname>
revoke quiesce_connect on database from <username/groupname>"

Larry Edelstein

Serge Rielau wrote:
Serge Rielau wrote:
>ra*******@gmail.com wrote:
>>Hi

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to
completely "shutdown" 1 database and the rest 4 databases should be
avaialable...the database should not be avaialable to anyone and
including the DBA...is there a way of achieving this??
************************

A bit of an odd request. The DBA is all about managing databases...
Anyway here is one idea that may work:
Create a second DB2 instance for which only "you" have access.
To lock a database from the regular instance, simply activate it using
your special instance.

On second thought. I'm not sure if/how you can lock other DBA's out
throught the instance. After all DBA privilege is a _database_ privilege..
Maybe soemone else has a better idea or a way to finish my thought.
Of course you could always simply revoke DBADM from your DBAs....

Cheers
Serge
Nov 19 '06 #4
Hi,
the only thing I can think about is to uncatalog the DB.
If you want to use this DB again, you'll have to catalog it again (with
the same arguments - like the ones in the earilier catalog/create DB).

quiesce and connect in exclusive mode wont prevent a DBA to access the
DB...

ra*******@gmail.com schrieb:
Hi

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to
completely "shutdown" 1 database and the rest 4 databases should be
avaialable...the database should not be avaialable to anyone and
including the DBA...is there a way of achieving this??
************************

Pls advise.

Reg
Ram
Nov 20 '06 #5
"DACTIVATE DB db_name" might work for you. Else, uncataloging would be
a solution, as mentioned in another reply.

Cheers,
ra*******@gmail.com wrote:
Hi

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to
completely "shutdown" 1 database and the rest 4 databases should be
avaialable...the database should not be avaialable to anyone and
including the DBA...is there a way of achieving this??
************************

Pls advise.

Reg
Ram
Nov 20 '06 #6
If one does:
db2 connect to <dbnamein exclusive mode
I think trhat only that id can connect to the db and no one else, unless
they have the same id and pw.

This will mean that the db is activated but only that user can use it.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Larry" <la***@nospam.neta écrit dans le message de news:
t5*****************@newsfe11.lga...
First of all, this is a good reason to use the "one database per instance"
paradigm.

Secondly, there is some granular control of who can access a database
using the DB2 QUIESCE DATABASE command. Don't know, however, if you can
prevent a DBA from accessing it.

From the DB2 pubs:

"After QUIESCE DATABASE, users with sysadm, sysmaint, sysctrl, or dbadm
authority, and GRANT/REVOKE privileges can designate who will be able to
connect. This information will be stored permanently in the database
catalog tables.
For example,

grant quiesce_connect on database to <username/groupname>
revoke quiesce_connect on database from <username/groupname>"

Larry Edelstein

Serge Rielau wrote:
>Serge Rielau wrote:
>>ra*******@gmail.com wrote:

Hi

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to
completely "shutdown" 1 database and the rest 4 databases should be
avaialable...the database should not be avaialable to anyone and
including the DBA...is there a way of achieving this??
************************

A bit of an odd request. The DBA is all about managing databases...
Anyway here is one idea that may work:
Create a second DB2 instance for which only "you" have access.
To lock a database from the regular instance, simply activate it using
your special instance.

On second thought. I'm not sure if/how you can lock other DBA's out
throught the instance. After all DBA privilege is a _database_
privilege..
Maybe soemone else has a better idea or a way to finish my thought.
Of course you could always simply revoke DBADM from your DBAs....

Cheers
Serge
Nov 24 '06 #7

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

Similar topics

8
by: Jonathan Heath | last post by:
Hi all, I have created an ASP script that enters data into an Access Database. My problem is that I'd like this script to run when the computer is shutdown or the user logs off. I think...
0
by: KULJEET | last post by:
i face problem in oracle backup. i take oracle logical backup after 3-4 days. but now the database is run 24*7 days so i set the oracle on archive mode at last night i take the hot backup by...
7
by: Lynn | last post by:
I'm running Oracle 8.1.7.4.1 on W2K and have the services for my oracle instances set to automatically startup and shutdown with the W2K server. Unfortunately, neither is working. Nothing gets...
2
by: Asad Khan | last post by:
What is the proper way to start and shutdown a database? I'm asking this because of the following: C:\Program Files\MySQL\afterinstall\bin>mysqld --console 031028 12:25:25 InnoDB: Database was...
2
by: Yasaswi Pulavarti | last post by:
In one istance I have four different databases. If I use db2stop all databases will be shutdown. How can I shutdown each database individually in one instance? Thanks, Yasaswi
1
by: Peter Stojkovic | last post by:
I have the following configuration VS-Studio 2003 Application Local SQL-Database When the UPS starts a shutdown of the unattended PC the following happens. The local database SQL-Database...
1
by: Durai raj | last post by:
Hello All, After starting the postmaster, I just entered in database like: $ psql test Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms
1
by: Titeuf | last post by:
Hi, I work under VS2003 and I want to know how get the shutdown reason code ? On msdn nothing found...No api :( Have you an idea ? Thank's
0
by: Varan | last post by:
hai, now we are using batch file for take backup at time of start services and stop services. we need option for take database backup at time 1. System Start ...
4
ADezii
by: ADezii | last post by:
Passive Shutdown is a little known, Jet 4 enabled feature that allows you to prevent Users from connecting to a Database. It is also known as Connection Control. This feature is referred to as...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.