Results 1 to 6 of 6
  1. #1
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Angry Unanswered: ROLLFORWARD problem

    hi.

    db2 udb v. 8.1.4 for windows

    this is my problem:
    after a shutdown of power, I restore my db, but, when I run the ROLLFORWARD command:

    db2 => ROLLFORWARD DATABASE DWCORP TO END OF LOGS AND COMPLETE
    SQL1218N There are no pages currently available in bufferpool "".
    SQLSTATE=57011

    and the state of my db is:
    db2 => ROLLFORWARD DATABASE DWCORP

    Rollforward Status

    Input database alias = DWCORP
    Number of nodes have returned status = 1

    Node number = 0
    Rollforward status = DB working
    Next log file to be read = S0027181.LOG
    Log files processed = S0027173.LOG - S0027177.LOG
    Last committed transaction = 2004-04-28-12.05.04.000000


    any idea?
    TIA
    Abel.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you try increasing the bufferpool size? What is size defined right now?
    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
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    hi and thanks Marcus.

    I can´t connect to db.

    db2 => connect to dwcorp
    SQL1117N A connection to or activation of database "DWCORP" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019


    I can change the buffer pool size whitout connection?

    Thanks.
    Abel.

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by achiola
    hi and thanks Marcus.

    I can´t connect to db.

    db2 => connect to dwcorp
    SQL1117N A connection to or activation of database "DWCORP" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019


    I can change the buffer pool size whitout connection?

    Thanks.
    Abel.
    At this point, you should probably be calling support...

    There is a parameter DB2_OVERRIDE_BPF that can be used in this case. What it does is tell DB2 to ignore the bufferpool file, which has the definitions for your bufferpools.

    ie. db2set DB2_OVERRIDE_BPF=1000

    (It's in pages - more documentation for it in the Admin Guide for Performance)

    Don't forget to unset it once you're done!

    This *may* work, I've never seen it used before a ROLLFORWARD to be perfectly honest, usually it's used when someone cannot connect because they set their Bufferpool ridiculously large.
    --
    Jonathan Petruk
    DB2 Database Consultant

  5. #5
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Talking

    THANKS

    This work OK

  6. #6
    Join Date
    Oct 2007
    Posts
    10

    Thumbs up ROLLFORWARD problem

    Just wanted to say Thanks, since the post helped me during a restore.

    Also wanted to add that the instance has to be stopped and started for the db2set to take effect.

Posting Permissions

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