The following figure shows the INPUT statement syntax.
For compatibility with earlier versions, Log Master supported an INPUT keyword on the LOGSCAN statement. This keyword is deprecated and was removed in . (It defined the input source for an individual log scan, but the input source must always be the same for all log scans within a job step.)
(default) Directs Log Master to scan the current Db2 log files that are listed in the bootstrap data set (BSDS) of Db2.
EXCLUDE (db2MemberName) (PTF BQU2875 applied)
In a data sharing system using BSDS input, forces the exclusion of all BSDS and log information for the member names specified. 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.
Directs Log Master to read log records from one or a set of logical log files previously created by 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. 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:
Db2 log input definition
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.
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 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
Merge (unless LOGSORT is NEVER; see LOGSORT in LOGOPTS statement)
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, 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, 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. 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.
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. 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 is not in RBA/LRSN order after 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.
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).
Specifies the VOLSER where the Db2 log data set is located. Separate multiple VOLSERs with commas.
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 . For example, if two members of a data sharing group are DHF1 and DHF2, a correct INPUT statement would be: