Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Rollforward database returns error: There are no pages currently available in bufferp

    Hi,
    I have two computers both having DB2 Enterprice v8.2 FP11 on Linux. One has 2 GB of RAM and one has 1 GB of RAM. I made an on-line backup on first 2 GB computer and restore it to 1 GB computer.

    When restoring on second computer I did the following:
    Code:
    db2 restore database mydb from /BackupDir to /RestoreDir into mydb
    DB20000I The RESTORE DATABASE command completed successfully.

    Code:
    db2 rollforward db mydb to end of logs and stop
    SQL1218N There are no pages currently available in bufferpool "".
    SQLSTATE=57011

    I would like to decrease bufferpool:
    Code:
    db2 connect to mydb
    db2 alter bufferpool ibmdefaultbp size 1000
    SQL1117N A connection to or activation of database "mydb" cannot be made
    because of ROLL-FORWARD PENDING. SQLSTATE=57019
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1024N A database connection does not exist. SQLSTATE=08003



    The rollforward process returns error probably because there is not a enough free memory on second computer. So idea is make a restore + rollforward and then decrease number of pages in bufferpool. But restore fails because bufferpool is too big.

    What I don't like is this procedur is written in bash skript and one day it rollforwards OK, some day doesn't.
    The funny thing is if a command rollforward is executed second time in 99% it executes successfully.

    Two questions:
    1. Is there any way I could reduce bufferpools before rollforward is executed?
    2. We are planning to migrate to DB2 v9.5 and we are planning to establish automatic maintenance for bufferpools. Will this problem of rollforward disappear in v9.5 if bufferpools are automatically maintained? If v9.5 solves the problem I will not bother to have some immediate solution for v8.2.

    Thanks,
    Grofaty
    Last edited by grofaty; 10-01-08 at 02:50.

  2. #2
    Join Date
    Oct 2008
    Posts
    11
    SQL1218N There are no pages in BP.

    Did you try to increase the size of hidden bufferpool using DB2_OVERRIDE_BPF?

    Thnx,
    Eldho

  3. #3
    Join Date
    Oct 2008
    Posts
    11
    db2set DB2_OVERRIDE_BPF=1000

    Then recycle the instance and try to rollforward again. Please refer the info center for more details.

Posting Permissions

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