如何显示appl id holding the oldest transaction?

db2 get snapshot for db |grep -i "oldest"
db2 get snapshot for application on agentid  刚才的ID


查看最早占用日志的agentid和日志的使用量
select
APPL_ID_OLDEST_XACT as "Oldest agentid",
int(total_log_used/1024/1024) as "Log Used (M)",
int(total_log_available/1024/1024) as "Log Space Free (M)",
int((float(total_log_used) / float(total_log_used+total_log_available))*100) as "Pct Used",
int(tot_log_used_top/1024/1024) as "Max Log Used (M)",
int(sec_log_used_top/1024/1024) as "Max Sec. Used (M)",
int(sec_logs_allocated) as "Secondaries"
from sysibmadm.snapdb;