Unanswered: Is ACTIVATE db the same as CONNECT TO DB ?
Is db2 ACTIVATE DB <dbname> the same as db2 CONNECT to <dbname> ? What is the difference in terms of back-end behaviour? I don't think they are the same because when we activate DB, STMM turns on, mem tunning turns on. Do Logs start to archive when DB is activated. What if it is deactivated, the logs won't archive?