Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012

    Unanswered: Deactivate database


    We have set up a fail over system for our production server( table partitioned). where we have to purge our old data . when we tried to detach the tables the AIC is not initiating of its own. Hence whenever we face this issue we used to do an instance bounce which will initiate the AIC clean up but we have to freeze the DB to prevent it from jumping into failover.
    do we really need an instance recycle for this or just a deactivate and activate of the database is enough .

    incase of deactivating the DB will it move to a failover server?

    AIX -
    DB2 v9.7.0.6", "s120629", "IP23414", and Fix Pack"6".

    Thanks in advance

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    can you specify a little more detail about setup and scenario and messages..
    what has failover todo with partitioned table ? hadr ? tsa ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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