MonitorQueryBand機能を使用すると、アクティブ セッションのためのクエリー バンドを検出できます。
BTEQ -- Enter your DBC/SQL request or BTEQ command: SELECT t1.sessionno, MonitorQueryBand(Hostid, sessionNo, runvprocno) FROM TABLE (MonitorSession(1,'*',0)) AS t1; SELECT t1.sessionno, MonitorQueryBand(Hostid, sessionNo, runvprocno) FROM TABLE (MonitorSession(1,'*',0)) AS t1; *** Query completed. 2 rows found. 2 columns returned. *** Total elapsed time was 1 second. SessionNo MonitorQueryBand(HostId,SessionNo,RunVprocNo) ----------- ---------------------------------------------------- 1299 1298 =S> REPJOBID=495;REPORT=Sales;CLIENTMACHINE=XYZ12;REPTYPE=10;