Hi i want to know exact  difference  between these two

1.db2 activate database db_name

2.db2 connect to db_name

Hello Kanakarajuy,

When you are executing  the db2 activate database db_name command, you are allocating all resource necessary(memory, etc) to the database receive all connections requested to it..

if the database is not activated and you execute the db2 connect to db_name, the db2 executes this in two steps(observe that the time to you connect to the database is longer than if you don´t activate the database previously):
1 - db2 activate database db_name
2 - db2 connect to db_name (open a connection with the database)

if the database is already activate and you execute the db2 connect to db_name, the db2 just connects to the database -  db2 connect to db_name (open a connection with the database)