Citação de Kindrazki em 14 de novembro de 2012, 17:34

O script abaixo deve ser executado no cmd (.bat)

@echo off

rem --- Scrpit: lista conexoes DB2
rem --- Objetivo: Listar as conexoes que estao executando atividades no database
rem ---
rem ---

rem --- Variaveis
set DB=teste
set INTVL=%1
set NTOP=10
set LR=0

rem --- Conexao com o banco de dados
db2 connect to %DB%

rem --- Inicio do CORE
db2 "select cast (appl.AGENT_ID as int) as ag_id, substr(APPL_STATUS,1,5) as status, case when APPL_STATUS = 'LOCKWAIT' then cast ((select AGENT_ID_HOLDING_LK from sysibmadm.lockwaits lkwait where lkwait.agent_id = appinfo.agent_id) as int) else null end as ag_blk, substr(APPL_NAME,1,1) as appl_name, cast (POOL_DATA_L_READS+POOL_INDEX_L_READS as bigint) as lreads, cast (POOL_DATA_P_READS+POOL_INDEX_P_READS as bigint) as preads, cast (AGENT_USR_CPU_TIME_S+AGENT_SYS_CPU_TIME_S as int) as ag_cpu, cast (LOCKS_HELD as int) as nr_locks, cast (LOCK_WAIT_TIME as int) as lkwait_time, substr (EXECUTION_ID,1,3) as EXEC_ID from sysibmadm.snapappl_info as appinfo, sysibmadm.snapappl appl where appinfo.AGENT_ID = appl.AGENT_ID and ( appl_status not in ('UOWWAIT','DECOUPLED', 'CONNECTED') OR appl.AGENT_ID in (select AGENT_ID_HOLDING_LK from sysibmadm.lockwaits) ) order by ag_cpu desc with ur"
rem --- Fim do CORE

rem --- Desconexao com o banco de dados
db2 connect reset > nul
db2 terminate > nul