回复 10# zhenda 相关文章:http://www.db2china.net/club/viewthread.php?tid=30787 [db2inst1@DB2_105 ~]$ db2 get snapshot for bufferpools on sample | grep "Buffer pool data logical reads "| head -1
Buffer pool data logical reads &nbs...
显示全部回复 10# zhenda 相关文章:
http://www.db2china.net/club/viewthread.php?tid=30787 [db2inst1@DB2_105 ~]$ db2 get snapshot for bufferpools on sample | grep "Buffer pool data logical reads "| head -1
Buffer pool data logical reads = 36
[db2inst1@DB2_105 ~]$ db2 "SELECT SUBSTR(DB_NAME,1,8) AS DB_NAME,SUBSTR(BP_NAME,1,15) AS BP_NAME,POOL_DATA_L_READS FROM SYSIBMADM.SNAPBP"
DB_NAME BP_NAME POOL_DATA_L_READS
-------- --------------- --------------------
SAMPLE IBMDEFAULTBP 65743
SAMPLE BB 0
SAMPLE IBMSYSTEMBP4K 0
SAMPLE IBMSYSTEMBP8K 0
SAMPLE IBMSYSTEMBP16K 0
SAMPLE IBMSYSTEMBP32K 0
6 record(s) selected.
[db2inst1@DB2_105 ~]$ db2 select * from syscat.tables > /dev/null
[db2inst1@DB2_105 ~]$ db2 reset monitor all
DB20000I The RESET MONITOR command completed successfully.
[db2inst1@DB2_105 ~]$ db2 get snapshot for bufferpools on sample | grep "Buffer pool data logical reads "| head -1
Buffer pool data logical reads = 0
[db2inst1@DB2_105 ~]$ db2 "SELECT SUBSTR(DB_NAME,1,8) AS DB_NAME,SUBSTR(BP_NAME,1,15) AS BP_NAME,POOL_DATA_L_READS FROM SYSIBMADM.SNAPBP"
DB_NAME BP_NAME POOL_DATA_L_READS
-------- --------------- --------------------
SAMPLE IBMDEFAULTBP 65779
SAMPLE BB 0
SAMPLE IBMSYSTEMBP4K 0
SAMPLE IBMSYSTEMBP8K 0
SAMPLE IBMSYSTEMBP16K 0
SAMPLE IBMSYSTEMBP32K 0
6 record(s) selected.
[db2inst1@DB2_105 ~]$
收起