Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Question Unanswered: Rollforward error

    Hi

    I tried to restore my DB(3.5 TB), restoration went successfully, But when trying to rollforward the db it is throwing an error.

    db2 "rollforward db dcecm40v to end of logs and stop overflow log path ('/appl/db2i1db/DCECM40V>
    it is processing for a while and then i get the below error

    SQL1224N The database manager is not able to accept new requests, has
    terminated all requests in progress, or has terminated your particular request
    due to a problem with your request. SQLSTATE=55032


    when i see list utilities i could see the instance is stopped .

    Please let me know how to proceed.

    My environemnt is AIX 6, with Db2 V9.1.6

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would recommend you call IBM support.
    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
    Aug 2010
    Location
    Singapore
    Posts
    197
    Thanks Marcus, for your response,

    I found an APAR related to that error.

    IBM IZ35045: ROLLFORWARD FAILS WITH SQL1042 OR CRASH RECOVERY FAILS WITH DB2DIAG.LOG ENTRY MESSAGE: DIA8709E. - United States

    Might be helpful for others,

    Now am restoring again to bring it point in time.

Posting Permissions

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