Professional Web Applications Themes

DB2 log files on Linux - IBM DB2

Greetings, Is it safe to simply copy logs files out of the log directory when the database is running (but being done at night so there are no changes being made to the database) in order to make sure that I am able to restore from an online backup ? Or... should I be handling log files carefully using the USEREXIT procedure etc. User exit only copies off the "non-active" logs yes ? Leaving the active logs still in the directory, which means if I restore from the logs I will not get all of my database, only the commited ...

  1. #1

    Default DB2 log files on Linux

    Greetings,
    Is it safe to simply copy logs files out of the log directory when the
    database is running (but being done at night so there are no changes
    being made to the database) in order to make sure that I am able to
    restore from an online backup ?

    Or... should I be handling log files carefully using the USEREXIT
    procedure etc. User exit only copies off the "non-active" logs yes ?
    Leaving the active logs still in the directory, which means if I restore
    from the logs I will not get all of my database, only the commited
    transactions yes ?


    Cheers.
    Ben

    Benjamin Stewart Guest

  2. #2

    Default Re: DB2 log files on Linux

    See Below.

    Benjamin Stewart wrote:
    > Greetings,
    > Is it safe to simply copy logs files out of the log directory when the
    > database is running (but being done at night so there are no changes
    > being made to the database) in order to make sure that I am able to
    > restore from an online backup
    Quite simply YES.
    However, just to be on the safe side, I'd check which log are active
    before the backup and then do it again after the backup. If the active
    logs before the backup are no longer active after, then I'f copy those
    off and check to copy the ones that were active while the backup as
    taken and copy them asap.
    ?
    >
    > Or... should I be handling log files carefully using the USEREXIT
    > procedure etc. User exit only copies off the "non-active" logs yes ?
    > Leaving the active logs still in the directory, which means if I restore
    > from the logs I will not get all of my database, only the commited
    > transactions yes ?
    You're not quite right here. The exit will make ANY log eleigible for
    copy as soon as it is full, whether active or not. If full, the exit is
    called and if everything works right the log is copied. So, at best,
    the only log file that would not be in the archive would be the active
    log that is not yet full.
    It is highly recommended that if you have to take regular online backups
    of the db and that you depend on them for recovery all the time then you
    should use the exit and get DB2 to manage this issue with you (notice I
    did not say for you)!!
    HTH, Pierre.
    >
    >
    > Cheers.
    > Ben
    >
    P. Saint-Jacques Guest

Similar Threads

  1. CFMX7 cfserver.log and exception.log files on Linux
    By solutionfinder in forum Coldfusion Server Administration
    Replies: 0
    Last Post: December 27th, 05:28 PM
  2. Replies: 24
    Last Post: March 11th, 01:37 AM
  3. Linux cfmx7 files permissions
    By axisnet in forum Coldfusion - Getting Started
    Replies: 0
    Last Post: July 7th, 04:17 PM
  4. Coldfusion MX 6.1 - Verity on Redhat 9 Linux will notindex .doc (MS Word) files
    By Joe Black in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: April 2nd, 04:31 AM
  5. Opening Zip Files in Linux
    By John Herren in forum PHP Development
    Replies: 4
    Last Post: September 6th, 03:50 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139