回复 6# han11jiji 1、db2 list active databases
[db2inst1@DBserverA ~]$ db2 list active databases
Active Databases
Database name = PAYMENT
Applications connected currently = 38
Database path = /data/payment/db2inst1/NODE0000/SQL00001/
2、db2 list applications
[db2inst1@DBserverA ~]$ db2 list applications
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2jcc_applica 6046 10.2.2.30.36794.141224071501 PAYMENT 1
DB2INST1 db2jcc_applica 53046 10.2.2.40.37449.141217121241 PAYMENT 1
DB2INST1 db2jcc_applica 53059 10.2.2.40.37457.141217121249 PAYMENT 1
DB2INST1 db2jcc_applica 53105 10.2.2.30.44707.141217122650 PAYMENT 1
DB2INST1 db2jcc_applica 53052 10.2.2.40.37453.141217121245 PAYMENT 1
DB2INST1 db2jcc_applica 53098 10.2.2.30.44701.141217122644 PAYMENT 1
DB2INST1 db2jcc_applica 40782 10.2.2.30.54547.141118081322 PAYMENT 1
DB2INST1 db2jcc_applica 53104 10.2.2.30.44709.141217122652 PAYMENT 1
DB2INST1 db2jcc_applica 10709 10.2.2.188.56399.141226034240 PAYMENT 1
DB2INST1 db2jcc_applica 53051 10.2.2.40.37451.141217121243 PAYMENT 1
DB2INST1 db2jcc_applica 9551 10.2.2.30.56528.141201011341 PAYMENT 1
DB2INST1 db2jcc_applica 53097 10.2.2.30.44704.141217122647 PAYMENT 1
DB2INST1 db2jcc_applica 40781 10.2.2.30.54529.141118081259 PAYMENT 1
DB2INST1 db2jcc_applica 53057 10.2.2.40.37456.141217121248 PAYMENT 1
DB2INST1 db2jcc_applica 53103 10.2.2.30.44708.141217122651 PAYMENT 1
DB2INST1 db2jcc_applica 53050 10.2.2.40.37450.141217121242 PAYMENT 1
DB2INST1 db2jcc_applica 5550 10.2.2.121.53417.141224024814 PAYMENT 1
DB2INST1 db2jcc_applica 40780 10.2.2.30.54528.141118081258 PAYMENT 1
DB2INST1 db2jcc_applica 53102 10.2.2.30.44706.141217122649 PAYMENT 1
DB2INST1 db2jcc_applica 6049 10.2.2.30.36795.141224071502 PAYMENT 1
DB2INST1 db2jcc_applica 53049 10.2.2.40.37448.141217121240 PAYMENT 1
DB2INST1 db2jcc_applica 38937 10.2.2.107.43227.141212040509 PAYMENT 1
DB2INST1 db2jcc_applica 53055 10.2.2.40.37455.141217121247 PAYMENT 1
DB2INST1 db2jcc_applica 53101 10.2.2.30.44705.141217122648 PAYMENT 1
DB2INST1 db2jcc_applica 6048 10.2.2.30.36796.141224071500 PAYMENT 1
DB2INST1 db2jcc_applica 5548 10.2.2.121.53421.141224024917 PAYMENT 1
DB2INST1 db2bp 11212 *LOCAL.db2inst1.141226053920 PAYMENT 1
DB2INST1 db2jcc_applica 53054 10.2.2.40.37452.141217121244 PAYMENT 1
DB2INST1 db2jcc_applica 53100 10.2.2.30.44703.141217122646 PAYMENT 1
DB2INST1 db2bp 10896 *LOCAL.db2inst1.141226030422 PAYMENT 1
DB2INST1 db2jcc_applica 40784 10.2.2.30.54552.141118081343 PAYMENT 1
DB2INST1 db2jcc_applica 53093 10.2.2.30.44700.141217122643 PAYMENT 1
DB2INST1 db2jcc_applica 38935 10.2.2.107.43228.141212040510 PAYMENT 1
DB2INST1 db2jcc_applica 41027 10.2.2.30.57405.141118102423 PAYMENT 1
DB2INST1 db2jcc_applica 53053 10.2.2.40.37454.141217121246 PAYMENT 1
DB2INST1 db2jcc_applica 53099 10.2.2.30.44702.141217122645 PAYMENT 1
DB2INST1 db2jcc_applica 42191 10.2.2.30.39274.141118205937 PAYMENT 1
DB2INST1 db2jcc_applica 40783 10.2.2.30.54530.141118081300 PAYMENT 1
3、db2 get instance_memory
[db2inst1@DBserverA ~]$ db2 get dbm cfg|grep instance
Monitor health of instance and databases (HEALTH_MON) = ON
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(14861677)
Discover server instance (DISCOVER_INST) = ENABLE
4、
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLogGetFileStats, probe:565
DATA #1 :
New STMM log file (/home/db2inst1/sqllib/db2dump/stmmlog/stmm.104.log) created automatically.
2014-12-26-00.53.32.606159+480 E28225E505 LEVEL: Event
PID : 34009 TID : 140386009868032PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : PAYMENT
APPHDL : 0-54624 APPID: *LOCAL.DB2.140910180043
AUTHID : DB2INST1
EDUID : 4719 EDUNAME: db2stmm (PAYMENT) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1187
DATA #1 :
STMM log file (99) removed automatically to maintain space constraint.收起