接続中アプリケーションを確認
コマンド
DB2 LIST APPLICATION [SHOW DETAIL]
実行結果
C:\>DB2 DB2 LIST APPLICATION SHOW DETAIL
CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coord
Handle Agents partition number pid/t
---------------- -------------------- ---------- ---------------------------- ----- ---------- ---------------- -----
DB2ADMIN db2fw1 13 *LOCAL.DB2.130112065908 00001 1 0 1304
DB2ADMIN db2fw0 12 *LOCAL.DB2.130112065907 00001 1 0 528
DB2ADMIN db2jcc_application 44 127.0.0.1.1333.130112071359 00001 1 0 3104
DB2ADMIN db2lused 11 *LOCAL.DB2.130112065906 00001 1 0 260
・
・
・
SQL
SELECT * FROM SYSIBMADM.SNAPAPPL_INFO