How to do a DB2 instance recycle on AIX

These are the steps you should execute when you need to do a DB2 instance recycle running on AIX

1 - Ask the application people to stop the application before you start with DB2 recycle
2 - Login with the instance owner id to run the commands:

db2 list applications show detail

3 - If there are applications left, double check with the application people if they stopped everything. If you still see applications left, you can do

db2 force applications all
db2 terminate
db2 deactivate db <db_name>
db2stop

4 - If the instance doesn’t come down because some application are still left, use

db2stop force

5 - If db2stop force cant bring the instance down run

db2_kill
ipclean –a

This will cleanup memory.

6 - Check if there are processes left using

ps –ef | grep <instance_name>

7 - Check if there are any ipc resources left for your instance using

ipcs –a | grep <instance_name>

If yes, try to kill them as root (use sudo):

sudo ipcrm –m resource_id (for m resources)
sudo ipcrm –s resource_id (for s resources)
sudo ipcrm –q resource_id (for q resources)

8 - Now that everything is clean, you should be able to start your instance

db2start