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?
DB2 v126.96.36.199", "s120629", "IP23414", and Fix Pack"6".
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 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be