Personal tools
You are here: Home DB2 How To's How to do a DB2 instance recycle on AIX
Navigation
Log in


Forgot your password?
 
Document Actions

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
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls