Near-Term History Data Collection Options
This panel shows the specifications for the currently active Near-Term History Data Collector.
For example, you can see which DB2 subsystem is being monitored, which DB2 traces are turned on, and where the data is being stored. The values shown in this panel are determined by the content of the collection options data set member RKD2PAR(COPTcccc), where cccc specifies the DB2 subsystem being monitored. The values are set by means of the Configuration Tool and are applied when the Near-Term History Data Collector is started. More information about the content of the RKD2PAR(COPTcccc) member is described in Configuration and Customization.
________________ ZH2IN VTM O2 V540.#P SAD 11/06/13 15:55:11 2
> Help PF1 Back PF3 Up PF7 Down PF8
> H.C.A
> NEAR-TERM HISTORY INFORMATION: Enter a selection letter on the top line.
> *-COLLECTION OPTIONS B-RECORD INFORMATION C-DATASET STATUS
===============================================================================
> NEAR-TERM HISTORY DATA COLLECTION OPTIONS
COPT
+ H2 Collection Options
+
+ DB2sys = SAD Writeoption = VSAM,SEQ Interval = 1
+ ArchiveSEQ = N/A Tracebufsz = 1024K Ifireadtime = 010000
+ NTAInterval = 5 Minutes Suspcoll = Yes PostPCT = 70
+
+ Statistics = Yes
+ Accounting = (1 2 3 7 8 10)
+ Sort summary = Yes Lock contention = Yes
+ Scan summary = Yes Lock suspension = Yes
+ Dynamic SQL = Yes Negative SQL = Yes
+
+ H2 Data Sets :
+ SYS1PMO.O310.V540.SE12.SAD.RKD2VS01
+ SYS1PMO.O310.V540.SE12.SAD.RKD2VS02
+ SYS1PMO.O310.V540.SE12.SAD.RKD2VS03
+ SYS1PMO.O310.V540.SE12.SAD.RKD2VS04
+
+ SYS1PMO.O310.D843.SDN1(+1)
+
+ Filtering :
+ Plannname = DISTSERV DYNSELP1
=============================================================================== Navigation
- related topics, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- DB2sys
- The identifier (1 to 4 characters) of the Db2 subsystem that is being monitored by the Near-Term History Data Collector.
- Writeoption
- The specified storage medium for trace
data. Possible values are:
- VSAM
- The Near-Term History Data Collector stores the trace data in VSAM data sets.
- VSAM,SEQ
- The Near-Term History Data Collector stores the trace data in VSAM data sets and sequential data sets. Sequential data sets are either regular sequential data sets or Generation Data Group (GDG) data sets. This specification is made by means of the Configuration Tool.
- Interval
- The time interval for data collection.
- ArchiveSEQ
- If sequential data sets were specified as storage medium for trace data (WRITEOPTION(VSAM,SEQ) keyword in collection options member RKD2PAR(COPTcccc)), this entry displays the name of the data set member RKD2PAR(ARCScccc) that contains the JCL to archive the sequential data sets. cccc specifies the Db2 subsystem being monitored.
- Tracebufsz
- The size of the buffer on the START TRACE command.
- Ifireadtime
- The frequency of IFI reads on lightly loaded DB2s. The value is mmsshh, where mm stands for minutes, ss for seconds, and hh for 1/100s of a second.
- Suspcoll
- Flag indicating whether the data collection is to be suspended
at times the VSAM data set is not available.
A near-term history VSAM data set is considered to be unavailable from the time all allocated file space is used until the end of a successful execution of the archive job.
- Yes
- The Near-Term History Data Collector is requested to discard all collected data in memory until a VSAM data set becomes available gain for use.
- No
- The Near-Term History Data Collector is requested to accumulate all collected data in memory until a VSAM data set becomes available gain for use.
- PostPCT
- A percentage value that determines when the Near-Term History
Data Collector drains its IFI buffer on behalf of DB2.
Use this information to tune the Near-Term History Data Collector, if you often see the DB2 message DSNW133I. This value is used to compute a "high water mark" or threshold, which is a percentage of the total number of bytes in the IFI buffer. When this threshold is exceeded, DB2 posts the Near-Term History Data Collector to drain the buffer.
- NTAInterval
- Displays the Near-Term History sub-interval time. This value may be specified as minutes or seconds. This value is used to provide a secondary display of thread accounting data from a smaller period of time. Sub-Interval periods may be displayed by entering F next to an interval of time on the THREAD HISTORY BY REPORT INTERVAL screen.
- Statistics
- Indicates whether a Statistics trace is active.
- Accounting
- Displays the number of each accounting trace class that is turned on. Accounting class 11 is available from DB2 11 and later. When class 11 is on, class 1, 7, 8, and 10 are suppressed.
- Sort summary
- Indicates whether sort processing is active.
- Lock contention
- Indicates whether lock timeout and deadlock information is being collected.
- Scan summary
- Indicates whether scan processing is active.
- Lock suspension
- Indicates whether lock wait information is being collected.
- Dynamic SQL
- Indicates whether SQL text and access path information for dynamic SQL is being collected.
- Negative SQL
- Indicates whether information about SQL statements
returning negative SQLCODE is being collected.
This entry is only shown if
Negative SQLis specified in the Near-Term History configuration. - H2 Data Sets
- The fully qualified names of the data sets that hold the trace data. The list of names varies depending on what media were specified with the Configuration Tool.
- Filtering
- Displays the specified filtering values. An asterisk (*) at the end of the filtering value means that all collected data begins with the characters that precede the asterisk. A question mark (?) at any position in the filtering value serves as a wildcard for a single character.