INPUT statement
The INPUT statement specifies the source where
BMC AMI Log Master
reads Db2 log records are. This statement defines the input source for all log scans within the current work ID.
The following figure shows the INPUT statement syntax.
Option | Description |
|---|---|
BSDS | (Default) Directs BMC AMI Log Master to scan the current Db2 log files that are listed in the bootstrap data set (BSDS) of Db2. |
EXCLUDE (db2MemberName) | In a data-sharing system using BSDS input, forces the exclusion of all BSDS and log information for the member names specified. BMC AMI Log Master proceeds as if those members do not exist. Note that the syntax uses the Db2 member name, not the subsystem identifier (SSID). These are usually the same, but not always. From a DISPLAY GROUP command, use the value under Db2 MEMBER rather than the value under SUBSYS. (SUBSYS values do not appear in the BSDS.) The specification replaces any EXCLUDEMEMBERS specification in the options module. Use the IGNORE keyword to ignore the EXCLUDEMEMBERS specification entirely. For more information about EXCLUDE, see EXCLUDEMEMBERS. |
LLOG (cntlDataSetName) | Directs BMC AMI Log Master to read log records from one or a set of logical log files previously created by BMC AMI Log Master or an application program that conforms to the published format. Enter the name of the data set that contains the control file of the logical log. BMC AMI Log Master uses information in the control file to locate and read the logical log data file, and any other files associated with the logical log. Enter a name that follows conventional guidelines for data set names. Separate multiple logical log data sets with commas. Be aware of the following points as you specify input logical log files:
|
DB2LOG | Directs BMC AMI Log Master to read log records from a specific Db2 log file or set of Db2 log files. You can define the exact location of the Db2 log files. For more information about specifying the Db2 log files, see Db2 log input definition . |
Db2 log input definition
Use this syntax to define a specific Db2 log file or set of Db2 log files where
BMC AMI Log Master
obtains Db2 log records.
The following figure shows the Db2 log input definition syntax used in the INPUT statement.
You can define the exact location of the Db2 log files. If you specify more than one log file, you must specify the files in the order defined by the ULOGORD installation option. For more information, see ULOGORD=ASCENDING.
BMC AMI Log Master either sorts input Db2 log files or processes them concurrently (performs a merge action) depending on the following criteria:
- Whether you are running in a data-sharing environment
- The settings of the BMC AMI Log Master LOGSORT and LOGTAPES values
Whether you specify a member name to group each member’s Db2 log files
Criteria for either sort or merge of Db2 log files
Group files with member name? | Data sharing environment | Non-data sharing environment |
|---|---|---|
Yes | Determine whether to sort based on LOGSORT and LOGTAPES values (see LOGOPTS-statement) | Merge |
No | Merge (unless LOGSORT is NEVER; see LOGSORT in LOGOPTS statement) | Merge |
When you define a specific Db2 log file or set of Db2 log files as input, you might need to specify more resources than you expect (such as additional Db2 log files or image copies). This requirement occurs for the following reasons:
- Unless the tables selected by your filter are defined with the Data Capture Changes (DCC) attribute, BMC AMI Log Master frequently requires resources other than your selected Db2 log files for row completion processing. The resources can include
- Additional Db2 log files from other members in a data sharing group (for example, if activity on another member affects the table rows selected by your filter)
- Additional Db2 log files that cover periods of time outside of your range definition (for example, log files covering the period between an image copy and the start point of your range)
- If the Db2 objects selected by your filter reside in compressed table spaces, BMC AMI Log Master can require image copies to obtain a valid compression dictionary. You can define the location of the image copies by using the IMAGECOPY statement. BMC AMI Log Master can also store copies of compression dictionaries in the Old Objects Table of the Repository. For more information, see INCLUDE DICTIONARY in LOGSCAN statement.
Option | Description |
|---|---|
dataSetName | Specifies a data set containing Db2 log records. The name that you enter must follow conventional guidelines for data set names. To specify Db2 log files from a non-data sharing system (or from only one member of a data sharing group), do not enter a memberName value. If you list multiple Db2 log files, specify them in the correct order. The correct order depends on the setting of the ULOGORD installation option. BMC AMI Log Master always expects to read log files from the lowest RBA/LRSN value to the highest. If you specify a list of log files that are not in RBA/LRSN order after BMC AMI Log Master applies the ULOGORD setting, you can encounter errors. For more information about the correct order with the ULOGORD installation option, see ULOGORD=ASCENDING. |
DEVT deviceType | Specifies the type of device that contains the Db2 log data set. Enter a site-specific name for a type of storage device (for example, 3390 for a DASD device or TAPE for a magnetic tape device). |
VOLUME (volser) | Specifies the VOLSER where the Db2 log data set is located. Separate multiple VOLSERs with commas. |
memberName | Specifies the name of a member in a data-sharing group. Use this keyword to specify Db2 log files that come from more than one member in a data-sharing environment. Group the log files from each member together, preceding the group with the member name. Within each member, specify the log files in the correct order. For more information, see dataSetName . For example, if two members of a data sharing group are DHF1 and DHF2, a correct INPUT statement would be: INPUT DB2LOG ( DHF1( DSNDHF.DHF1.ARCLOG1.A0005229, DSNDHF.DHF1.ARCLOG1.A0005230 ) DHF2( DSNDHF.DHF2.ARCLOG1.A0005849, DSNDHF.DHF2.ARCLOG1.A0005850 ) ) |