该xx库有11个bufferpools,但执行db2pd -d xx -bufferpools为什么只能看到IBMDEFAULTBP的信息,其他的bufferpools怎么没显示出来?$ db2pd -bufferpools -d xx
Changing data structure forced command termination.
Database Partition 0 -- Database xx -- Active -- Up 0 days 00:45:46
Bufferpools:
First Active Pool ID 1
Max Bufferpool ID 7
Max Bufferpool ID on Disk 7
Num Bufferpools 11
Address Id Name PageSz PA-NumPgs BA-NumPgs BlkSize NumTbsp PgsToRemov CurrentSz PostAlter SuspndTSCt
0x07700007B6409780 1 IBMDEFAULTBP 32768 31250 0 0 6 0 31250 31250 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
收起