DB2 for i セッション（ジョブ）一覧

DB2のジョブ（セッション）一覧

SELECT
JOB_NAME,
AUTHORIZATION_NAME, 
JOB_TYPE,
SUBSYSTEM,
CLIENT_APPLNAME, 
CLIENT_IP_ADDRESS,
JOB_STATUS,
SQL_STATEMENT_TEXT
FROM TABLE (
  QSYS2.ACTIVE_JOB_INFO(
  DETAILED_INFO => 'ALL'
  )
)
where 1=1
and JOB_NAME_SHORT='QZDASOINIT'
--and client_applname='A5M2.exe'
ORDER BY JOB_NAME
;