Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    82

    Unanswered: Restricting access to a DB in an isntance

    Hi I am running DB2 9.5 on zlinux server. I have five DB under one instance.

    I need to deactivate 3 DBs so that no one can connect to them. I can do that by revoking privileges but I want to keep the privileges intact because we need to use the DB in future.

    Is there a command like the deactivate db which will down the DB and no one will be able to connect it until I activate it again..

    I think the deactivate command doesn't work here because the db automatically starts when you connect to it.

    the purpose is that when the DB is activated it takes memory. We want the DB to stay down so the memory is available for the other DBs

    ????
    Last edited by junaid377; 04-05-12 at 10:52. Reason: missed information

  2. #2
    Join Date
    Nov 2011
    Posts
    334
    May be you can try the clp command: quiesce db.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you do not want the database to be used - an easy way is to uncatlog it ..

    db2 list db directory

    For your database you will have a line "local database directory" . Make a note of it.

    db2 uncatalog db <dbalias>

    When you want to make use of it again

    db2 catalog db <dbalias> on <local dir name>

    Quiesce works ... but if the connection id has super-user privilege, it gets through.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •