db2缓冲池维护

《db2缓冲池维护》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、DB2性能监控和调优Bufferpool篇1，打开监视器记录开关>db2updatemonitorswitchesusingBUFFERPOOLON数据库2,查看BUFFERPOOL相关指标db2=>getsnapshotforbufferpoolson数据库BufferpoolSnapshotBufferpoolname=IBMDEFAULTBPDatabasename=数据库Databasepath=/home/数据库/db2inst1/NODE0000/SQL00001/Inputdatabasealias=数据库Snaps

2、hottimestamp=2012-08-2914:26:56.680488Bufferpooldatalogicalreads=9352343767Bufferpooldataphysicalreads=7842064458Bufferpooltemporarydatalogicalreads=1394631Bufferpooltemporarydataphysicalreads=1003790Bufferpooldatawrites=14196736Bufferpoolindexlogicalreads=984092635Bu

3、fferpoolindexphysicalreads=18007186Bufferpooltemporaryindexlogicalreads=0Bufferpooltemporaryindexphysicalreads=0Totalbufferpoolreadtime(ms)=189662232Totalbufferpoolwritetime(ms)=67254105Asynchronouspooldatapagereads=7655365979Asynchronouspooldatapagewrites=12202419Buf

4、ferpoolindexwrites=6803875Asynchronouspoolindexpagereads=573236Asynchronouspoolindexpagewrites=5770911Totalelapsedasynchronousreadtime=171898253Totalelapsedasynchronouswritetime=52416888Asynchronousdatareadrequests=487634359Asynchronousindexreadrequests=364145Novictim

5、buffersavailable=185403798Directreads=10028Directwrites=0Directreadrequests=2858Directwriterequests=0Directreadselapsedtime(ms)=13793Directwriteelapsedtime(ms)=0Databasefilesclosed=0Datapagescopiedtoextendedstorage=0Indexpagescopiedtoextendedstorage=0Datapagescopiedfr

6、omextendedstorage=0Indexpagescopiedfromextendedstorage=0Unreadprefetchpages=1144034VectoredIOs=484334896PagesfromvectoredIOs=7641815885BlockIOs=0PagesfromblockIOs=0Physicalpagemaps=0Nodenumber=0Tablespacesusingbufferpool=6Alterbufferpoolinformation:Pageslefttoremove=0

7、Currentsize=1000Post-altersize=1000BufferpoolSnapshotBufferpoolname=BUF32KDatabasename=数据库Databasepath=/home/数据库/db2inst1/NODE0000/SQL00001/Inputdatabasealias=数据库Snapshottimestamp=2012-08-2914:26:56.680488Bufferpooldatalogicalreads=9226695Bufferpooldataphysicalreads=2

8、008888Bufferpooltemporarydatalogicalreads=0Bufferpooltemporarydataphysicalreads=0Bufferpooldatawrites=101384Bufferpoolindexl