• +86-135-5029-3426
  • sales@vinchin.com
logo

Vinchin Blog

Vinchin Blog The database buffer pool setting is too large. System downtime is caused when connecting to the database

The database buffer pool setting is too large. System downtime is caused when connecting to the database

2021-07-31

< 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

  • Tag:
  • Backup

Interested Blogs More

DOWNLOAD NOW YOU CAN ENJOY A 60-DAYS FULL-FEATURED FREE TRIAL !