Creating an output group

Use the following procedure to create an output group for an option set. The option set uses this output group to collect and process data, and then writes it to the LOGSET (log file) data sets for batch or historical reporting.

To create an output group

1. On the option set’s panel (see Creating-a-DOMPLEX-option-set), expand Output Groups.

2. On the Output Groups line, overtype I on the minus sign (-) and press Enter.

   • Type I on the - sign
   • Type R to replicate an existing Output Group and then type over the name with a new name
   • Type E to define a new instance using the default values.

   The new output group is displayed at the top of the list and is by default is numbered 001. However you can use any 3-digit number within the range. Each output group must have a unique number within the DOMPLEX set.

   Tip

   This step inserts a completely new output group. If you prefer repeating an existing output group, type R on the plus sign (+) next to that output group and press Enter.

   Doing so copies the new group under the original group and uses the same group number for both. Change the number for the new group to be unique.

3. To edit the parameters for the new output group, expand its group number.

4. In the Output Groups section, complete the following fields:

   Field	Description
   OutGp (Group Number)	Specify the number of the output group. Valid values are 001 through 256.
   DCID (Data Collector SSID)	Specify the subsystem ID of the Data Collector that owns the output group.
   DspSize (Data space size)	Specify the size of the data space (in megabytes) that this output group uses to collect and process data (before writing the data to LOGSET log files). The recommended size depends on the types of data assigned to this group and the load expected for all types combined. The size is specified in megabytes in the range 0 to 2000. A value of zero causes all IFCIDs assigned to this group to be immediately discarded. Important The sum of data space for all output groups assigned to the same data collector cannot exceed 2000 MB.

5. Expand the Data Classes section to specify the IFCIDs that this output group captures and stores.

   Data class	IFCIDs
   DCSYSTEM Specify Y to collect DATA Collector events data Important This information is also available from the SYSLOG, DB2 JESLOG, or DB2 IFCIDS	(BMC IFCIDs 241 and 245) Important Do not define an output group for DCSYSTEM unless recommended by BMC Support.
   APSTACC Specify Y to collect Apptunestatement accounting interval data.	Apptune/SQL Performance BMC IFCIDs: 006—Interval Statistics 307—SQL Statement Summary 318—Filter Data 507—SQL Statement Summary (Basic)
   APSTACCS Specify Y to collect Apptunestatement accounting summaries data.	Apptune/SQL Performance Accounting Statement Summary BMC IFCIDs: 305—MainView Application Summary 306—High Use Statement Summary (unless ALERTS class is active) 308–311—Statement Summary 508-511—Statement Summary (Basic)
   APSTMT Specify Y to collect Apptunestatement text, host variables, and exceptions data.	Apptune/SQL Performance BMC IFCIDs: 004—SQL Exceptions 005—SQL Statement Text 010—Host Variables (unless HOSTVAR class is active) 011—Object Statistics per SQL Exception 012—Call stack info per exception
   APERROR Specify Y to collect ApptuneSQL error data.	Apptune/SQL Performance BMC IFCID: 007—SQL Errors
   APOBJECT Specify Y to collect Apptuneobject summary data.	Apptune/SQL Performance Object Statistics. BMC IFCIDs: 008—SQL Statement/Object Cross-Reference 009—Access Object Statistics
   DB2ACCT 2 Specify Y to collect Db2 accounting data.	Db2 accounting records DB2 IFCIDs: 003—Accounting 239—Package Accounting DBRMs
   DB2SYS 2 Specify Y to collect Db2 statistics events data.	Db2 system records DB2 IFCIDs: 001—System Statistics 002—Database Statistics 031—EDM Pool Full Condition 102—Start Short on Storage 103—End Short on Storage 104—Log Data Set Names 105—DBID/OBID Translate to Names 106—System Parameters (DSNZPARM) 107—Page Set OPEN/CLOSE 172—Deadlock Detail 196—Timeout Detail 199—Dataset I/O Statistics 202—Statistics Dynamics DSNZPARMS 203—Heuristics Decision DDF COMMIT/ABORT 204—Partner Cold Start Detected 205—Incorrect Log NAME/SYNC PARMS 206—SNA Compare Protocol Error 207—Heuristic Damage CS Exchange 208—SNA SYNCPOINT Protocol Error 209—SYNCPOINT COMM Failure 210—Logname Changed on Warm Start 225—Storage Summary1 230—Global Statistics 365—Locations Statistics
   DB2AUDIT 2 Specify Y to collect Db2 audit data.	Db2 audit records DB2 IFCIDs: 140—Audit Authorization Failures141–Audit GRANTs and REVOKEs 142—Audited Object DDL1 143—Audited Object First Write Attempt1 144—Audited Object First Read Attempt1 145—Audited Object DML at BIND1 146—User-Defined Audit Trace 312—Audit Trail for DCE Security Processing
   DB2PERF 2 Specify Y to collect Db2 performance data.	Db2 performance records (all other DB2 IFCIDs) MainView for DB2 - Data Collector IFCIDs: 004—Start Trace Command 005—Stop Trace Command 006—Start SYNC/ASYNC Read I/O 007—End SYNC/ASYNC Read I/O 024-025—Utility Processing1 026—Sort Workfile Obtained 027—Sort Run Records Sorted 028—Sort Details 029-030—Start EDM I/O Request 048—(S)End New SRB Exec Unit 049—(S)Start New TCB Exec Unit 050—(S)End New TCB Exec Unit 051—(S)Shared Latch Resumed 052—(S)Shared Latch Suspend 053—End DESCRIBE/COMMIT/ROLLBACK 055—Set Current SQLID 090—Text of DB2 Command 091—Completion Status of Db2 CMD 096—End Sort 097—End AMS Command 098—(S)Start Non-Pool GET/FREEMAIN 099—(S)End Non-Pool GET/FREEMAIN 100—(S)Start Pool GET/FREEMAIN 101—(S)End Pool GET/FREEMAIN 108—Start BIND/REBIND 109—End BIND/REBIND 110—Start Bind Free 111—End Bind Free 168—(S)Distributed SQL Text 169—Distributed Authorization ID Translation 170—(S)Suspend Agent Wait on Db2 SERV 171—(S)Resumed Agent Wait on Db2 SERV 173—Dynamic SQL Exceeds ASUTIME 174—Start Archive Log (QUIESCE) CMD 175—End Archive Log (QUIESCE) CMD 192—DDM Level 6A Header Errors 193—DRDA UOW DISP/SQLCODE Mismatch 194—DRDA Invalid SNA FMH-5 RCVD 195—DRDS First Failure Data CAPTUR 197—Db2 Monitor Error-MSG 198—Buffer Manager Requests 199—Dataset I/O Statistics 201—Altered Bufferpool Status 211—Make or Release Claim 212—Make or Release Drain 213—Drain Lock Suspend 214—Drain Lock Resume 215—Begin Wait Claim Count Zero 224—Invalid Select Procedure 226—Page Latch Suspend 227—Page Latch Resume 228—(S)Start Archive Allocate Wait 229—(S)End Archive Allocate Wait 231—Parallel Group Processing 232—ENTRY/EXIT from Db2 233—START/END Call Store PROC Server 234—Authorization ID of Calling Agent 235—Conditional Restart Data Loss 236—SNA Exchange lognames error 237—Set Current Degree 238—(S)Db2 Restart Error 313—Long Running URS During CHKPT 314—Authorization Exit PARMS 316—SQL Statement Statistics 317—SQL Statement String 324—Function Resolution for Statement 325—Begin, End of Trigger Operation 327—Copy of Data LE ENV MSGRTN Exit 342—Work FILE/DATABASE Usage 343—Max Temp Failure 359—Locations Statistics 369—Aggregated Accounting Statistics 370-371—Pageset OPEN/CLOSE 401—Static Statement Currently in EDM Pool Stats 404—Service Authorization Compatibility Settings
   OPERTUNE Specify Y to collect OPERTUNEevents data. Important This data class applies only if you are using the OPERTUNE for Db2 product with another of the System and SQL Performance products	OPERTUNErecords (BMC IFCID 17)
   PAHIST Specify Y to collect BMC AMI Pool Advisor history data.	Pool Advisor History. BMC IFCIDs: 072—DB2 Storage Usage Status 079—PMD: Configuration Change History 082—DB2 Page Set Access Statistics 086—DB2 Object Getpage Statistics 089—DB2 Object Getpage Event Trace 095—DB2 Dynamic Statement Cache Plan/DBRM (History) 096—DB2 Dynamic Statement Cache by Plan (History) 097—DB2 Dynamic Statement Cache by DBRM (History) 098—DB2 Dynamic Statement Cache by Corr ID (History) 099—DB2 Dynamic Statement Cache by Conn ID (History)
   MVDBACC Specify Y to collect BMC AMI Ops Monitor for Db2  - DC accounting summary data.	BMC AMI Ops Monitor for Db2 BMC IFCIDs: 340—End to End Connection Monitor Records 350–352—Data Collector Accounting Summary Records
   ALERTSSpecify Y to send Apptune data that can be the basis of alerts to this output group. If no output group specifies Y for this class, then the alerts data will go to the APPSTACC output group. If you specify Y for this class, all others must be N.	Apptune/ SQL Performance BMC IFCID: 306—High Use Statement Summary (Advanced)
   HOSTVARSpecify Y to send Db2 and Apptune host variable data to this output group. If no output group specifies Y for this class, then the host variable data will go to the DB2PERF output group for Db2 or APSTMT output group for Apptune. If you specify Y for this class, all others must be N.	Apptune and BMC AMI Ops Monitor for Db2 BMC IFCID: 10—Host variable DB2 IFCIDs 247-248—Host variable

   ^{1.This IFCID is disabled by default. It can be used optionally for batch reporting. See theBMC AMI Ops Infrastructure  documentation for instructions on how to activate additional IFCIDs when you want to produce a report that requires them.}

   ^{2.Only valid for BMC AMI Ops Monitor for Db2}
   

   
   

6. Expand the NGL LOGSET Parameters section to specify the Next Generation Logger (NGL) LOGSET parameters for the output group. See the following table for a description of the NGL LOGSET parameters.

   Parameter	Description
   Logset Compression	Specify how to compress the log file data or to disable compression: LOW (default), is considered the optimal balance of compression and CPU usage HIGH saves more DASD space but use significantly more CPU (including zIIP usage where available) NO disables compression, saving CPU usage at the expense of DASD space
   LOGSET time span	Specify the amount of time that you would like to have data kept in log files, in days (D), hours (H), or minutes (M). You can specify only one type. If you specify a number without a type, the value defaults to days. If all of the log files become full in less time than this time span allows, more log files are allocated, up to the maximum allowed.
   Max log buffers	Specify the maximum number of log I/O buffers to use. Valid values are 2 through 20.
   Max read buffers	Specify the maximum number of read I/O buffers to use. Valid values are 2 through 99.
   Deferred write time	Specify the maximum time delay before buffered records are written to the DASD log files. A shorter deferred time requires more write I/Os but means less vulnerability to data loss if an outage occurs. Valid values are 1 through 999 seconds.
   Minimum log file data sets (LDS)	Specify the number of log file datasets that are allocated when the data collector starts. Valid values are 1 through 99.
   Maximum log file data sets (LDS)	Specify the maximum number of log file datasets that can be allocated as needed to meet the LOGSET time span goal. Valid values are 1 through 99.
   Space to allocate (per LDS)	Specify the total space used for each LOGFILE. Valid values are 1 through 9999 MB.
   LDS Allocation Type	Specify the type of allocation parameters to be used. SMS: DFSMS parameters are used and you must provide at least one of the SMS parameters (storage class, management class, data class) VOL: you must provide a traditional VOLSER to indicate where the LOGFILE should be allocated. NONE: you provide no allocation parameters and the system defaults are used
   LDS Volume	(Mandatory if you select type volume) Specify the volume for the LOGSET.
   LDS DFSMS Data Class	(Mandatory if you select type SMS) Specify the DFSMS data class for the LOGSET.
   LDS DFSMS Management class	(Mandatory if you select type SMS) Specify the DFSMS management class for the LOGSET.
   LDS DFSMS Storage Class	(Mandatory if you select type SMS) Specify the DFSMS storage class for the LOGSET.
   LDS DSN prefix	Specify the DSN prefix for the LOGSET (log file) data sets. Important Supports system static and dynamic symbols
   Enable Archiving	Specify Y to enable LOGSET data set archiving. For details, see Additional-information-about-archiving-and-the-NGL1.
   Archive Wait Time	Specify the maximum time in seconds to wait for an archive to finish before reusing a LOGFILE. Allowed values are 1-9999, with a default of 600.
   Archive post processing job	(Optional) Specify the member that contains the job that executes when the archive job is done. The data set that contains the member is defined by the DOMPARMS DD in the DBC started task.
   Max days to keep archives	Specify the number of days to keep archive data sets. Valid values are 1 through 999 days, or 0 which indicates no limit.
   Max number of archives to keep	Specify the number of archived data sets to keep. Valid values are 1 through 999 archives, or 0 which indicates no limit.
   Max combined size of archives	Specify the total space used by all archive data sets. Valid values are 1 through 999999 MB, or 0 which indicates no limit.
   Archive file allocation type	Specify the type of allocation parameters to be used. SMS: DFSMS parameters are used and you must provide at least one of the following SMS parameters (storage class, management class, data class) VOL: you must provide a traditional VOLSER to indicate where the LOGFILE should be allocated. UNIT: Specify any valid unit name NONE: you provide no allocation parameters and the system defaults are used
   Archive Volume	(Mandatory if you select type volume) Specify the volume for the LOGSET.
   Archive Unit	(Mandatory if you select type unit) Specify the unit for the LOGSET.
   Archive DFSMS Data class	(Mandatory if you select type SMS) Specify the volume for the archive.
   Archive DFSMS Management class	(Mandatory if you select type SMS) Specify the DFSMS management class for the archive.
   Archive DFSMS Storage class	(Mandatory if you select type SMS) Specify the DFSMS storage class for the archive.
   Archive GDG	Specify Yes to configure the enabled DSN prefix (Archive DSN Prefix or the Alternate full archive DSN) as the base name for a generation data group. All members of the archive output data set are members of a generation data group (GDG).
   Archive DSN prefix	(Optional) Specify the DSN prefix for the archive. 1
   Alternate full archive DSN	(Optional) Specify the archive DSN. The product uses this value in place of the value defined as the Archive DSN prefix. You must ensure that the name is unique for each archive created. BMC suggests using date and time symbolics in the name. 1 Example For example: BMCPERF.D&YYMMDD.T&HHMMSS

   ^{1.Supports system static and dynamic symbols}

   ^{The Archive DSN prefix and Alternate full archive DSN are mutually exclusive. Specify a value for one or the other.}

7. Enter Db2 subsystem names on the lines in the DB2 Subsystem IDs fields. Place your cursor on > (the greater-than sign) and press Enter to zoom to more fields to enter additional SSIDs.