Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    59

    Unanswered: difference between rollforward db to end of logs and complete..endof logs stop

    Hi,
    Whats the difference between
    rollforward database to end of logs and complete
    and....
    rollforward database to end of logs and stop

    Command reference :
    http://wwwdoc.sp.cesca.es/db2/db2n0/....htm#HDRCMD096

    As usual db2 fails to clarify the difference.

    thanks
    rgds
    brat.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The web site you mentioned seems to have version 5 manuals. This is what the DB2 7.2 Command Reference Maunual says:

    COMPLETE / STOP

    Stops the rolling forward of log records, and completes the rollforward recovery process by rolling back any incomplete transactions and turning off the rollforward pending state of the database. This allows access to the database or table spaces that are being rolled forward. These keywords are equivalent; specify one or the other, but not both. The keyword AND permits specification of multiple operations at once; for example, db2 rollforward db sample to end of logs and complete.

    Note: When rolling table spaces forward to a point in time, the table spaces are placed in backup pending state.

  3. #3
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    59
    thanks for the info..... but i am still confused why have 2 different commands doing the same job??

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Don't know, maybe at one time there was a difference (or maybe not).

    BTW you can get free soft copies of manuals at:
    http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

Posting Permissions

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