Results 1 to 6 of 6

Thread: Offline/Online

  1. #1
    Join Date
    Apr 2013
    Posts
    27

    Unanswered: Offline/Online

    Hi,
    I am new to DB2, can anyone tell me the process to make offline database to online. How does it works??

    Well thanks in advance.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't understand the question.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Apr 2013
    Posts
    27
    means bringing a database to archival logging from circular,
    what steps we need to carried out??
    which parameters need to set??

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    db2 update db cfg for <db-name> using LOGARCHMETH1 DISK:<path-name-for-archive-logging>
    db2 force application all


    You will need to take an immediate offline backup after this command is run.

    You will need to prune the archive logs on a periodic basis so that the path does not fill up. Usually, you can get rid of logs that were created before the last backup you have.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Apr 2013
    Posts
    27
    Thanks Marcus,
    bt can u please elaborate the necessity of taking offline backup after the steps u've mentioned..
    Can u please brief on 'LOGRETAIN' and 'USEREXIT' method??

    NItin

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    LOGRETAIN is depreciated (obsolete) and USEREXIT is only needed if you want to write your own user exit log archive program. Just use LOGARCHMETH1 (which is required if you ever want to use HADR).

    A single offline backup is needed right after setting LOGARCHMETH1. After that you can do offline or online backups. I don't have time to explain why an offline backup is needed, but it is needed in order to do SQL insert, update, or deletes to the database (this is enforced by DB2).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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