Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Location
    Toronto, Canada
    Posts
    23

    Question 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?

    Please advise, thank you

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    No it is not the same. The on-line Knowledge Centre explains it, for your version of db2 and your operating-system. Study that first.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •