1. Problem: After transferring the online db2 backup file and logs from server A to server B for restoration, no error was reported during the restore process, but an error was reported during the rollforward process of the database, reporting sql1218n there are no pages currently available in bufferpool “”. sqlstate=57011 error, check db2diag report no available free pages, etc.
2. Analysis of the reasons: A server on the library bufferpool set relatively large, in B server is not so large memory, so it will report an error, in forward with topas or nmon for memory observation can be analyzed.
3. Solution: db2 has a global variable db2_override_bpf, you can set this variable, how much to set, according to the memory of the B server for planning, you need to restart db2 after setting to make it effective. Now, according to a backup file, it takes more than three months to rollforward the data, but now it takes one day to roll forward the data of less than 5 days.
4. Then observe the progress of rollforward.
Read More:
- How to Solve svn error: WC DB
- How to Solve DB2 uses Limit Error
- TypeError: db.collection is not a function
- DB::Exception: test: Authentication failed: [How to Solve]
- Room DB Error: AppDatabase_Impl does not exist [How to Solve]
- How to Solve “Error db.num is null” when starting Nacos
- Ranger Install Error: [E] ranger_core_db_mysql.sql file import failed!
- DB2 detects a syntax error in the DRDA data stream: 0x3 ERRORCODE= -4499, SQLSTATE=58009
- [Solved] Clickhouse Error: DB::Exception: Cannot lock file /var/lib/clickhouse/status
- [Solved] azkaban Upload zip Error :Error Chunking during uploading files to db
- How to Solve Azkaban Error Chung during uploading files to DB
- [Solved] Mac Install mongodb error: NonExistentPath: Data directory /data/db not found.
- [Solved] error: db5 error(11) from dbenv->open: Resource temporarily unavailable
- db2 purescale Install Error: ERROR: An error occurred while compiling IBM General Parallel File System (GPFS) Portability Layer (GPL) on host “cf1”. Return code “3”.
- error: rpmdb: BDB0113 Thread/process 14536/140712790841152 failed: BDB1507 Thread died in Berkeley DB library
- [Solved] FreeBSD PKG error: pkg: repository meta /var/db/pkg/FreeBSD.meta has wrong version 2
- [Solved] Tensorflow2.0 Error: Function call stack:distributed_function
- [Solved] Tensorflow-gpu Error: self._traceback = tf_stack.extract_stack()
- [Solved] ELK Log System Error: “statusCode“:429,“error“:“Too Many Requests“,“message“ Data too large