[2011-08-18] DB2 Member 간 List Applications 를 확인해보자!

보통 DB2에서 현재 DB에 connection 되어 있는 application의 list 를 보려면 아래와 같이 확인을 한다.

db2 list applications <show detail>

하지만 9.8 PureScale 상의(2개의 member 가정) 의 list 조회는 member별 혹은 global 하게 list 를 조회할 수 있다

아래는 멤버별 조회를 하는 내용을 보여준다.
--------------------------------------------------------------------------------------
 member0:/dongbucni> db2 list applications at member 0 <show detail>

 

Auth Id  Application    Appl.      Application Id                                                 DB       # of

         Name           Handle                                                                    Name    Agents

-------- -------------- ---------- -------------------------------------------------------------- -------- -----

DONGBUCNI      db2bp          4658       *N0.db2.110825071212                                           DONGBU    1  

member1:/dongbucni> db2 list applications at member 1 <show detail>

Auth Id  Application    Appl.      Application Id                                                 DB       # of

         Name           Handle                                                                    Name    Agents

-------- -------------- ---------- -------------------------------------------------------------- -------- -----

DONGBUCNI      db2bp          67417      *N1.db2.110825070744                                           DONGBU    1 

member0:/dongbucni> db2 list applications global <show detail>
 

Auth Id  Application    Appl.      Application Id                                                 DB       # of

         Name           Handle                                                                    Name    Agents

-------- -------------- ---------- -------------------------------------------------------------- -------- -----

DONGBUCNI      db2bp          4658       *N0.db2.110825071212                                           DONGBU    1   

DONGBUCNI      db2bp          67417      *N1.db2.110825070744                                           DONGBU    1   

*주의점 TIP 

db2 "force applications all" 은 member 모두 다 kill하는 경우에 쓰인다.

db2 "force applications(67422)" ID 지정 시 멤버별로 application Kill 한다.