Вышел новый drop Stinger.

Появилась прикольная утилита db2pd аналог onstat в Informix.
Некоторые снапшоты и параметры стало удобнее смотреть :)

Небольшие Примеры

db2inst1@linux:~> db2pd -db sample -dynamic

Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:34:10

Dynamic Cache:
Current Memory Used 208899
Total Heap Size 1271398
Cache Overflow Flag 0
Number of References 8
Number of Statement Inserts 8
Number of Statement Deletes 1
Number of Variation Inserts 7
Number of Statements 7

Dynamic SQL Statements:
Address AnchID StmtID NumEnv NumVar NumRef NumExe Text
0x30961220 119 1 1 1 1 1 insert into test (a,b) values (3,3),(4,4)
0x3095E440 139 1 2 2 2 1 create table test (a int, b int)
0x3095B8A0 157 1 1 1 2 2 select * from syscat.tables
0x30958810 171 1 1 1 1 1 select * from employee
0x3095FE50 184 1 1 1 1 1 insert into test (a,b) values (1,1),(2,2)
0x309585B0 191 1 0 0 0 0 SET CURRENT LOCALE LC_CTYPE = 'ru_RU'
0x3095A2A0 205 1 1 1 1 1 select* from department

Dynamic SQL Environments:
Address AnchID StmtID EnvID Iso QOpt Blk
0x309612F0 119 1 1 CS 5 B
0x3095E500 139 1 1 CS 5 B
0x3095F310 139 1 2 CS 5 B
0x3095B960 157 1 1 CS 5 B
0x309588D0 171 1 1 CS 5 B
0x3095FF20 184 1 1 CS 5 B
0x3095A360 205 1 1 CS 5 B

Dynamic SQL Variations:
Address AnchID StmtID EnvID VarID NumRef Typ Lockname

0x30961C30 119 1 1 1 1 4 0100000001000000010
0770056
0x3095EE40 139 1 1 1 1 1 0100000001000000010
08b0056
0x3095FC50 139 1 2 1 1 1 0100000001000000020
08b0056
0x3095C2A0 157 1 1 1 2 3 0100000001000000010
09d0056
0x30959210 171 1 1 1 1 6 0100000001000000010
0ab0056
0x30960860 184 1 1 1 1 4 0100000001000000010
0b80056
0x3095ACA0 205 1 1 1 1 6 0100000001000000010
0cd0056


db2inst1@linux:~> db2pd -db sample -bufferpool

Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:18:08

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 ES NumTbsp PgsLeft CurrentSz PostAlter SuspndTSCt
0x302DBA90 1 IBMDEFAULTBP 4096 1000 0 0 N 3 0 1000 1000 0
0x302DB010 4096 IBMHIDDENBP4K 4096 16 0 0 N 0 0 16 16 0
0x302DB2B0 4097 IBMHIDDENBP8K 8192 16 0 0 N 0 0 16 16 0
0x302DB550 4098 IBMHIDDENBP16K 16384 16 0 0 N 0 0 16 16 0
0x302DB7F0 4099 IBMHIDDENBP32K 32768 16 0 0 N 0 0 16 16 0


db2inst1@linux:~> db2pd -db sample -log

Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:19:01

Logs:
Current Log Number: 0
Pages Written: 1

Address StartLSN State Size Pages Filename
0x301E806C 0x000000FA0000 0x00000000 1000 1000 S0000000.LOG
0x301E80FC 0x000001388000 0x00000000 1000 1000 S0000001.LOG
0x301E818C 0x000001770000 0x00000000 1000 1000 S0000002.LOG



db2inst1@linux:~> db2pd -db sample -locks

Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:19:59

Locks:
Address TranHdl Lockname Type Mode Sts Owner Dur HldCnt Att Rlse
0x302702F0 2 53514c43324530339b575ba841 Internal P ..S G 21 0 0 0x0

db2inst1@linux:~> db2pd -db sample -tablespaces

Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:21:30

Tablespaces:
Address Id Type Content PageSize ExtentSize Prefetch BufID BufIDDisk State TotPages UsablePgs UsedPgs PndFreePgs FreePgs HWM MinRecTime NQuiescers NumCntrs MaxStripe Name
0x3033A900 0 SMS Any 4096 32 32 1 1 0x00000000 0 0 0 0 0 0 0 0 1 0 SYSCATSPACE
0x3033B040 1 SMS SysTmp 4096 32 32 1 1 0x00000000 0 0 0 0 0 0 0 0 1 0 TEMPSPACE1
0x3033B780 2 SMS Any 4096 32 32 1 1 0x00000000 0 0 0 0 0 0 0 0 1 0 USERSPACE1

Containers:
Address TspId ContainNum Type TotalPages UseablePgs StripeSet Container
0x3033AEE0 0 0 Path 0 0 0 /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLT0000.0
0x3033B620 1 0 Path 0 0 0 /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLT0001.0
0x3033BD60 2 0 Path 0 0 0 /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLT0002.0

db2inst1@linux:~> db2pd -agents

Database Partition 0 -- Active -- Up 0 days 00:38:34

Agents:
Current agents: 7
Idle agents: 1
Active agents: 5
Coordinator agents: 5

Address AppHandl [nod-index] AgentPid Priority Type State ClientPid Userid ClientNm Rowsread Rowswrtn LkTmOt DBName
0x100E3800 0 [000-00000] 1559 0 Idle n/a n/a n/a 0 0 0 n/a
0x100E30A0 47 [000-00047] 1549 0 Coord Active 2637 db2inst1 db2bp 5 9 NotSet SAMPLE
0x10148040 26 [000-00026] 1560 0 Coord Active 1887 db2inst1 db2bp 116 0 NotSet SAMPLE
0x100E2840 10 [000-00010] 1112 0 Coord Active 999 db2inst1 db2dasst 1789 0 NotSet TOOLSDB
0x100E1FE0 9 [000-00009] 1111 0 Coord Active 999 db2inst1 db2dasst 2 0 NotSet TOOLSDB
0x100E1780 8 [000-00008] 1087 0 Coord Active 999 db2inst1 db2dasst 115 0 NotSet TOOLSDB
0x101488A0 0 [000-00000] 1958 0 Coord Pooled n/a n/a n/a 0 0 NotSet n/a

db2inst1@linux:~> db2pd -db sample -mempools

Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:23:48

Memory Pools:
Address MemSet PoolName Id Overhead LogSz LogUpBnd LogHWM PhySz PhyUpBnd PhyHWM Bnd BlkCnt CfgParm
0x300008D0 SAMPLE utilh 5 0 464 20496384 464 16384 20496384 16384 Ovf 3 UTIL_HEAP_SZ
0x30000844 SAMPLE undefh 59 0 0 12345678 0 0 12353536 0 Ovf 0 n/a
0x300007B8 SAMPLE pckcacheh 7 28480 208899 Unlimited 208899 262144 Unlimited 262144 Ovf 59 PCKCACHESZ
0x3000072C SAMPLE catcacheh 8 0 55936 Unlimited 55936 65536 Unlimited 65536 Ovf 22 CATALOGCACHE_SZ
0x300006A0 SAMPLE bph 16 6688 4307808 Unlimited 4307808 4325376 Unlimited 4325376 Ovf 2 n/a
0x30000614 SAMPLE bph 16 64 629824 Unlimited 629824 655360 Unlimited 655360 Ovf 2 n/a
0x30000588 SAMPLE bph 16 64 367680 Unlimited 367680 393216 Unlimited 393216 Ovf 2 n/a
0x300004FC SAMPLE bph 16 64 236608 Unlimited 236608 262144 Unlimited 262144 Ovf 2 n/a
0x30000470 SAMPLE bph 16 64 171072 Unlimited 171072 196608 Unlimited 196608 Ovf 2 n/a
0x300003E4 SAMPLE lockh 4 64 459168 491520 459168 491520 491520 491520 Ovf 2 LOCKLIST
0x30000358 SAMPLE dbh 2 42784 3238218 8175616 3238273 3293184 8175616 3293184 Ovf 385 DBHEAP

db2inst1@linux:~> db2pd -db sample -memsets

Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:24:20

Memory Sets:
Name Address Id Size Key DBP Type Ov OvSize
SAMPLE 0x30000000 1736724 45957120 0x0 0 1 Y 8929280
App47 0x248C9000 2949142 131072 0x0 0 3 N 0
App26 0x248C9000 1703955 131072 0x0 0 3 N 0

Да регистрируешься и качаешь. LEO только некоторые куски. Как я понимаю полностью он будет реализован в 9-ке т.е через год.