TREND
TREND command syntax
Parameter | Description |
|---|---|
None | Expands the time interval of the report 1 day into the past |
days | Expands the interval by the specified number of days. The default value is 1. |
FORWARD | Expands the interval into the future (up to the current time as a maximum). If not specified, the interval is expanded into the past. |
ARCHIVES | Includes archived data in the updated view of the report. |
TIMEISO | Limits the selected data to the time of day for which the report was entered. After being specified, this option is retained for subsequent TREND commands until the report is deactivated. |
Type TREND (with or without parameters) on the Command line and press Enter.
Example 1
Depending on the goal of your analysis, you might want to access a report that groups data by time before using the TREND command. For example, if you are viewing an
workload report grouped by plan, program, statement, or similar criteria; consider using the V zoom action to see the breakout of that activity by interval, as displayed in the following figure:
Command ====> _______________________________________________ Scroll ===> CSR_
BMCSftwr.SQMCACTV -- INTERVAL ANALYSIS (DATA) -- 04/30 09:24:22
Source : BC1J-ACTIVE Intvl : 04/30 06:00 - 04/30 08:59 More: >
-------------------------------------------------------------------------------
Zooms: G-AppGrp I-ClntID 8-ConnTy B-DsGrp X-Excptn P-Plan S-Stmt
Y-Accel N-ClntAp W-ClntWS L-Corr T-Detl K-ImpQul R-Prog U-User
M-AccMtx 9-ClntCT C-ConnID D-DB2 E-Error O-Object J-ReqLoc
Expands: A-AvHiLo Z-zIIP 1-More 2-Accel
DB2: DLY3 DsGrp: Plan: Prog: CUSTQRY
CorrID: ConnID: Stmt: 53
SQL +----- Total IN-SQL Time -----+ +
Workload Interval Calls Elapsed % CPU % Getpages T
-------------------------- ------ --------------- --------------- -------- -
+ 04/30/20 06:00:00-08:59:59 10371 2:41:23.066 100 09:40.20156 100 518499K 1
You can then use the TREND command to display additional intervals, as displayed in the following figure to compare the activity between intervals:
Command ====> _______________________________________________ Scroll ===> CSR_
BMCSftwr.SQMCACTV -- INTERVAL ANALYSIS (DATA) -- 04/30 09:24:27
Source : BC1J-ACTIVE Intvl : 04/28 00:00 - 04/30 08:59 More: >
-------------------------------------------------------------------------------
Zooms: G-AppGrp I-ClntID 8-ConnTy B-DsGrp X-Excptn P-Plan S-Stmt
Y-Accel N-ClntAp W-ClntWS L-Corr T-Detl K-ImpQul R-Prog U-User
M-AccMtx 9-ClntCT C-ConnID D-DB2 E-Error O-Object J-ReqLoc
Expands: A-AvHiLo Z-zIIP 1-More 2-Accel
DB2: DLY3 DsGrp: Plan: Prog: CUSTQRY
CorrID: ConnID: Stmt: 53
SQL +----- Total IN-SQL Time -----+ +
Workload Interval Calls Elapsed % CPU % Getpages T
-------------------------- ------ --------------- --------------- -------- -
+ 04/30/20 06:00:00-08:59:59 20604 2:41:23.066 100 09:40.20156 99 518499K
+ 04/29/20 06:00:00-08:59:59 40002 00:16.21106 0 00:02.07283 0 30980
+ 04/28/20 06:00:00-08:59:59 40002 00:25.51501 0 00:01.81133 0 31022
Example 2
Another example would be a report for events such as exceptions or errors. Using the TREND command for this report increases the range of time for which this report displays event summaries and the number of events that you can select for details.
If the report is not grouped by time, you can issue the TREND command to increase the time range for the report, and watch for:
- New items
- Significant changes to counters in existing items
- Significant changes to averages in existing items