db2 9.5
在syscat.tablespaces中查到表空间WCM_DAT对应的缓冲池id为2;
$ db2 "select substr(tbspace,1,20),bufferpoolid from syscat.tablespaces"
1 BUFFERPOOLID
SYSCATSPACE 1
TEMPSPACE1 1
USERSPACE1 1
WCM_DAT 2
SYSTOOLSTMPSPACE 1
SYSTOOLSPACE 1
6 record(s) selected.
在syscat.bufferpools中查到缓冲池id为2的是BP32K
$ db2 "SELECT * FROM SYSCAT.BUFFERPOOLS where bufferpoolid=2"
BPNAME BUFFERPOOLID DBPGNAME NPAGES PAGESIZE ESTORE NUMBLOCKPAGES BLOCKSIZE NGNAME
BP32K 2 - 5000 32768 N 0 0 -
1 record(s) selected.
但是在db2pd中看不到这个缓冲池,隐藏的缓冲池信息也都没有
$ db2pd -d trswcm7 -bufferpools
Changing data structure forced command termination.
Database Partition 4294967295 -- Database TRSWCM7 -- Active -- Up 2 days 19:27:22
Bufferpools:
First Active Pool ID 1
Max Bufferpool ID 2
Max Bufferpool ID on Disk 2
Num Bufferpools 6
Address Id Name PageSz PA-NumPgs BA-NumPgs BlkSize NumTbsp PgsToRemov CurrentSz PostAlter SuspndTSCt
0x07800000536E8F40 1 IBMDEFAULTBP 32768 31919 0 0 5 0 31919 31919 0
Bufferpool Statistics for all bufferpools (when BUFFERPOOL monitor switch is ON):
BPID DatLRds DatPRds HitRatio TmpDatLRds TmpDatPRds HitRatio IdxLRds IdxPRds HitRatio TmpIdxLRds TmpIdxPRds HitRatio
1 0 0 00.00% 0 0 00.00% 0 0 00.00% 0 0 00.00%
BPID DataWrts IdxWrts DirRds DirRdReqs DirRdTime DirWrts DirWrtReqs DirWrtTime
1 0 0 0 0 0 0 0 0
BPID AsDatRds AsDatRdReq AsIdxRds AsIdxRdReq AsRdTime AsDatWrts AsIdxWrts AsWrtTime
1 0 0 0 0 0 0 0 0
BPID TotRdTime TotWrtTime VectIORds VectIOReq BlockIORds BlockIOReq FilesClose NoVictAvl UnRdPFetch
1 0 0 0 0 0 0 0 0 0
$
不明白是什么原因