The database buffer pool setting is too large. System downtime is caused when connecting to the database
< pre > ibmdefaultbp is set too large (1300000 * 4K), resulting in system downtime when connecting to the database. So let's try to make IBM default BP smaller. Operating steps: db2set DB2_ OVERRIDE_ BPF = 10000 # make ibmdefaultbp use this value DB2 terminated b2stopdb2startdb2 connect to db# connect to dbdb2 alter bufferpool ibmdefaultbp numblockpages 0# the original block size is too large, we disable it here DB2 force applications alldb2 connect to dbdb2 alter bufferpool ibmdefaultbp immediate size 50000 # change the size to smaller db2set DB2_ OVERRIDE_ BPF = # set to null, restore to DB2 terminated B2 force applications alldb2stopdb2start
Interested Blogs More
What is the difference between incremental backup, differential backup and incremental backup?
WHAT'S NEW in Vinchin Backup & Recovery v6.0 - Introduction
Big data storage and backup
What should we do when the data lost in the cloud?
The difference between information security and network security