The following figure shows the INPUT statement syntax.
For compatibility with earlier versions, Log Master also supports an INPUT keyword on the LOGSCAN statement. This keyword is deprecated and might be removed from future versions. (It defines 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.)
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: