Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18

    Unanswered: regarding db rollforward (error msg:SQL1117N)

    Hello friends,

    In restoring process when i rollforward the db by using

    """db2 rollforward db XPRDBB to end of logs"""

    i got the following error message:

    "SQL4970N Roll-forward requery on database "XPRDBB" cannot reach the specified. stop point (end-of-log 'or' point-in-time) because of missing log file(s) on node(s) 0."

    can any post how to solve this plz...

    thanks & regards

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    it means that the log files, needed for rollforward are not present/accessible
    check log directory / archive log directory or tsm
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Alternatively, do not roll forward to the end of the logs or do not roll forward at all. The consequence will be, however, that you will not have the latest version of your data.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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