Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2009
    Posts
    43

    Unanswered: Change LOGARCHMETH1 from TSM to Disk

    From this reference

    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

    point 3 in notes...

    "Enabling or disabling archive logging is an offline database activity. You must terminate all connections to the database before the new setting takes effect. Only changes in the logging path can be done online."


    It seems to me then, that I could change LOGARCHMETH1 while the database is online from TSM to somewhere on the server using the Disk parameter.

    Is this correct?

    I imagine I would have to get archive logs from two different places if I needed to use a backup that was over the time period of this change. That may be a challenge for me! But if it's not impossible...it just boils down to ones and zeros right?

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Interesting Question.

    DB2 is aware of Changes in the Logchains. I'ld guess that if the logfiles are still there and config (dsm.opt etc) did not change, then DB2 may be able to find the Logfiles in TSM.

    Did you test it meanwhile?

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    you can change the setting but execute
    get db cfg show detail and see the setting is delayed until all disconnected
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Dec 2009
    Posts
    43
    Thanks for the replies.

    I am going to try this out in our sandbox environment.

  5. #5
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    ... or you can take a db backup right after you change the parameter.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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