[db2inst1@test ~]$ db2pd -d test -bufferpoolsDatabase Member 0 -- Database test -- Active -- Up 0 days 00:26:09 -- Date 05/20/2013 19:42:11Bufferpools:First Active Pool ID 1Max Bufferpool ID &n...
显示全部[db2inst1@test ~]$ db2pd -d test -bufferpools
Database Member 0 -- Database test -- Active -- Up 0 days 00:26:09 -- Date 05/20/2013 19:42:11
Bufferpools:
First Active Pool ID 1
Max Bufferpool ID 1
Max Bufferpool ID on Disk 1
Num Bufferpools 5
Address Id Name PageSz PA-NumPgs BA-NumPgs BlkSize NumTbsp PgsToRemov CurrentSz PostAlter SuspndTSCt Automatic
0x00002B24FB82C540 1 IBMDEFAULTBP 4096 1000 0 0 4 0 1000 1000 0 True
0x00002B24F8975BC0 4096 IBMSYSTEMBP4K 4096 16 0 0 0 0 16 16 0 False
0x00002B24F897E080 4097 IBMSYSTEMBP8K 8192 16 0 0 0 0 16 16 0 False
0x00002B24F8986540 4098 IBMSYSTEMBP16K 16384 16 0 0 0 0 16 16 0 False
0x00002B24FB824080 4099 IBMSYSTEMBP32K 32768 16 0 0 0 0 16 16 0 False
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%
4096 0 0 00.00% 0 0 00.00% 0 0 00.00% 0 0 00.00%
4097 0 0 00.00% 0 0 00.00% 0 0 00.00% 0 0 00.00%
4098 0 0 00.00% 0 0 00.00% 0 0 00.00% 0 0 00.00%
4099 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
4096 0 0 0 0 0 0 0 0
4097 0 0 0 0 0 0 0 0
4098 0 0 0 0 0 0 0 0
4099 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
4096 0 0 0 0 0 0 0 0
4097 0 0 0 0 0 0 0 0
4098 0 0 0 0 0 0 0 0
4099 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
4096 0 0 0 0 0 0 0 0 0
4097 0 0 0 0 0 0 0 0 0
4098 0 0 0 0 0 0 0 0 0
4099 0 0 0 0 0 0 0 0 0
[db2inst1@test ~]$ db2pd get snapshot for bufferpools on ksdbs
Invalid command line option get
[db2inst1@test ~]$
收起