Viewing near-term historical data from current trace data sets
To view near-term historical data from current trace data sets
On the Apptune Main Menu, select SQL Workload and press Enter.The SQL Workload Analysis Menu is displayed.
Select Time interval and press Enter.The Select Analysis Interval report is displayed. This report lists time intervals for all Db2s in the current trace data sets. You can select a single interval or a range of intervals.
Select Analysis Interval report
ASQEQRTN/I VIEW A REPORT LINE 1 OF 20
COMMAND ====> _______________________________________________ SCROLL ===> CSR_
BMCSftwr.SQMINTVD -- SELECT ANALYSIS INTERVAL -- 01/28 19:23:48
SELECT A SINGLE INTERVAL OR A RANGE OF INTERVALS. TYPE "S" BESIDE A SINGLE
INTERVAL OR BESIDE THE FIRST AND LAST INTERVALS IN THE RANGE, AND PRESS
ENTER. EXIT WHEN FINISHED.
ACTIONS: F-FILTERING CRITERIA
+------------------- INTERVAL -----------------+ NUMBER ACTIVE
BEGIN END DURATION DB2 ENTRIES FILTER
------------------ ------------------ -------- ---- ------- --------
+ 03/28/22 16:19:59 03/28/22 19:23:48 03:03:49 DEBF 0 DOTDEFF
+ 03/28/22 16:19:59 03/28/22 19:23:48 03:03:49 DEDK 915 DOTDEFF
+ 03/28/22 16:19:59 03/28/22 19:23:48 03:03:49 DEFF 301 DOTDEFF
+ 03/28/22 16:19:59 03/28/22 19:23:48 03:03:49 DEFM 0 DOTDEFF
+ 03/28/22 09:10:59 03/28/22 14:20:59 05:10:00 DEDK 2027 DOTDEFF
+ 03/28/22 09:10:59 03/28/22 14:20:59 05:10:00 DEFF 1447 DOTDEFF
+ 03/28/22 09:10:59 03/28/22 14:20:59 05:10:00 DEFM 61 DOTDEFF
+ 03/28/22 00:00:00 03/28/22 08:54:59 08:54:59 DEBF 0 DOTDEFF
+ 03/28/22 00:00:00 03/28/22 08:54:59 08:54:59 DEFF 5412 DOTDEFF- Type S beside a single interval or beside the first and last intervals in the range, and press Enter. Press F3 when you finish selecting intervals.If you want to report on multiple intervals, you should check the filtering criteria for all intervals. If you view data from multiple intervals that used different filters, the data might not be meaningful.
Type F over the + (plus sign) beside the interval, and press Enter.The Associated Filter Criteria report is displayed. Use the filtering criteria to select the intervals for your reporting session and to determine which reports are relevant to the data collected. (For example, exception reports are relevant only if exception data was collected.)
(BMC.DB2.SPE2501)Associated Filter Criteria report
ASQEQRTW/I View a Report LINE 1 OF 8
Command ====> _______________________________________________ Scroll ===> CSR_
BMCSftwr.SQMINTVF -- ASSOCIATED FILTER CRITERIA -- 09/13 23:54:56
DEBF - Start: 03/28/22 16:19:59 END: 03/28/22 19:23:48 Entries: 146
Active filter name: !BMCTEST
Actions: C-Collection options 1-More F-Full
Coll, Options Keys +--------- Exception settings ---+ EffSt Neg
Program Plan Userid Corrid Thrd ABCDE FG ABCDEFGHIJKLMNOPQ Elapsed CPU GPS SIOS ABCD Count SQL
-------- -------- -------- ------------ ---- ----- -- ----------------- -------- -------- ----- ----- ---- ----- ---
+ * DISTSERV * * Y, N YYYYY YN YYYYYNYNNNNNNYNNN 0 0 0 0 YYYN 1000 YYN
+ * * * * Y, N YYYYY YN YYYYYNYNNNNNNYYYN 0 0 0 0 YYYN 1000 YYN- Press F3 until you return to the SQL Workload Analysis menu.
Select Data Source, Db2(s) and press Enter.The Data Source panel is displayed. Use this panel to specify the source of records and the Db2 subsystems for reporting.
Data Source panel
DOMEQFIS/I DATA SOURCE 17:17:40
COMMAND ====> ________________________________________________________________
TYPE THE DATA SOURCE FOR REPORTING BELOW. THEN EXIT.
DATA SOURCE . . . . . . S ( D =DATA SET )
( A =ARCHIVE DIRECTORY )
( S =DC SUBSYSTEM : DAC1 )
DATA SET . . . . . . . ____________________________________________
DB2 SSID LIST . . . . . *___ ____ ( * FOR ALL)
____ ____ ____ ____ ____
____ ____ ____ ____ ____
____ ____ ____ ____ ____
____ ____ ____ ____ ____
____ ____ ____ ____ ____
____ ____ ____ ____ ____- In the Data source field, type S.
- In the Db2 SSID list field, specify the subsystem IDs of the Db2 subsystems that you want to examine. You can specify up to 32 Db2s or you can enter an * (asterisk) in the first field to select all Db2 subsystems in the data set.
- Press F3 until you return to the SQL Workload Analysis Menu.From this menu, you can continue your reporting session.