Monday, 19 May 2014

How to ckeck the application priority

How to ckeck the application priority

db2pd -agents | get snapshot for applications

Using db2pd


db2pd -agents

Database Partition 4294967295 -- Active -- Up 0 days 00:04:43

Agents:
Current agents:      7
Idle agents:         0
Active coord agents: 7
Active agents total: 7
Pooled coord agents: 0
Pooled agents total: 0

Address    AppHandl [nod-index] AgentEDUID Priority   Type     State       ClientPid  Userid   ClientNm Rowsread   Rowswrtn   LkTmOt DBName  
0x10466890 204      [000-00204] 18                   Coord    Inst-Active 9732       db2inst1 db2bp    0          0          NotSet n/a     
0x1046DE60 235      [000-00235] 34      -10         Coord    Inst-Active 9732       db2inst1 db2bp    59497      0          NotSet SAMPLE  
0x10467A60 236      [000-00236] 45         0           Coord    Inst-Active 9732       db2inst1 db2stmm  0          0          NotSet SAMPLE  
0x10468C30 237      [000-00237] 46                   Coord    Inst-Active 9732       db2inst1 db2taskd 2          0          NotSet SAMPLE  
0x10469E00 238      [000-00238] 47         0           Coord    Inst-Active 9732       db2inst1 db2wlmd  0          0          NotSet SAMPLE  
0x1046AFD0 239      [000-00239] 48         0           Coord    Inst-Active 9732       db2inst1 db2evmg_ 0          0          3           SAMPLE  
0x1046CC90 257      [000-00257] 33         0           Coord    Inst-Active 9623       db2inst1 db2govd  0          0          0           n/a 

db2pd -agents 34
Database Partition 4294967295 -- Active -- Up 0 days 01:23:54

Agents:
Current agents:      9
Idle agents:         1
Active coord agents: 7
Active agents total: 7
Pooled coord agents: 1
Pooled agents total: 1

Address    AppHandl [nod-index] AgentEDUID Priority   Type     State       ClientPid  Userid   ClientNm Rowsread   Rowswrtn   LkTmOt DBName  
0x1046DE60 235      [000-00235] 34         -10         Coord    Inst-Active 9732       db2inst1 db2bp    2145470    0          NotSet SAMPLE 

Using snapshot for applications


db2 get snapshot for application agentid 235 | grep -i prioriry

Priority at which application agents work  = -10
Priority type                              = Dynamic

No comments:

Post a Comment