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 0 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 0 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