Installation options quick reference

Specifies the location of a data set that contains the Log Master POF. Log Master can read the POF to obtain certain default values for the online interface

For more information, see ALPOFDSN.

Determines the type of messages that Log Master issues when a job encounters a Db2 security exception as it processes either Db2 log or logical log input

For more information, see AMSGLEV.

Specifies an authorization ID that Log Master uses to bind application plans when it executes SQL statements

Syntax override: EXECSQL, BINDOWN

For more information, see BINDOWN.

Specifies a qualifier value that Log Master uses during execution to dynamically bind internal packages that are distributed with Log Master. The vv represents a two-character version number and r represents a one-character release number.

For more information, see BINDQUALIFIER.

Determines whether Log Master generates Summary reports that include or exclude the INSERT log records that result when a Db2 Load utility is run with the LOG option set to YES

For more information, see BYPASSLL.

Indicates whether Log Master can use the SYSIBM.SYSLGRNX tables to reduce the amount of log that it reads during row completion processing

For more information, see CMPLGRNG.

Determines the maximum number of recalled data sets that Log Master maintains on DASD at one time

Syntax override: OPTION, DASD DATASETS

For more information, see DASDDSNS.

Determines whether Log Master honors Db2 security at the table level whenever a job accesses Db2 log input

For more information, see DB2AUTH.

Determines whether Log Master processes log records that were created as a result of updates to Db2 catalog tables

Syntax override: LOGSCAN, DB2CATALOG

For more information, see DB2CAT.

Determines whether Log Master processes log records that were created as a result of updates to Db2 directory tables

Syntax override: LOGSCAN, DB2DIRECTORY

For more information, see DB2DIR.

Directs Log Master to use only uppercase characters in the online interface and Log Master generated portions of reports

This installation option is provided for environments that display double-byte characters online.

For more information, see DBCS.

Determines whether Log Master includes DDL information in all output logical log files

Syntax override: LOGSCAN, INCLUDE DDL OBJECTS

For more information, see DDLOBJ.

Directs Log Master to issue requests to recall archived data sets before it needs the data sets for log processing

Syntax override: OPTION, EARLY RECALL

For more information, see ERLYRCL.

Determines whether Log Master processes log records for Db2 objects that have been dropped and possibly re-created

Syntax override: OPTION, EXECUTION MODE

For more information, see EXECMODE.

EXCLUDEMEMBERS ( SPE2005 )

Determines whether Log Master uses the forward completion (FC) key store to perform a special type of row completion processing

Syntax override: OPTION, HEURISTIC FORWARDCOMPLETION

For more information, see FCUSE.

Determines how Log Master obtains Db2 catalog information (DBIDs, OBIDs, or PSIDs) for the Db2 objects that the filter names

Syntax override: OPTION, FILTER METHOD

For more information, see FLTRMTHD.

Determines the output that Log Master generates when it encounters the Db2 log records that reflect a LOAD REPLACE action

Syntax override: OPTION, GENERATE MASSDELETE

For more information, see GENMDEL.

Specifies the source that Log Master uses to perform row completion processing or decompression processing

Syntax override: OPTION, IMAGESOURCE

For more information, see IMAGESRC.

Specifies the target maximum aggregate amount of below-the-bar memory (REGION) that Log Master uses for temporary working storage areas called key stores.

Syntax override: STOREOPTS, MEMORY

For more information, see KSMEMORY.

Determines whether Log Master honors Db2 security at the table level when a job accesses logical log input

For more information, see LLOGAUTH.

Determines how Log Master processes LOAD RESUME LOG NO events. When set to YES, Log Master assumes LOAD RESUME LOG NO events ran with NOCOPYPEND and compression dictionaries were not rebuilt

Syntax override: OPTION, LOAD NOCOPYPEND

For more information, see LOADNCP .

Specifies the units that Log Master uses to allocate LOB or XML VSAM files

Log Master uses LOB VSAM files to store data from LOB columns in selected log records.

Syntax override:

LOBOPTS, CYLINDERS | TRACKS

XMLOPTS, CYLINDERS | TRACKS

For more information, see LOBALLOC.

Specifies a valid data class within the IBM product DFSMS

Log Master uses this data class to allocate LOB or XML VSAM files .

Syntax override:

LOBOPTS, DATACLAS

XMLOPTS, DATACLAS

For more information, see LOBDATA.

Determines how Log Master responds to a duplicate data set condition as it attempts to create a LOB or XML VSAM files

Syntax override:

LOBOPTS, DUPLICATE DATASET

XMLOPTS, DUPLICATE DATASET

For more information, see LOBDUPDS.

Determines the maximum number of LOB or XML VSAM files that Log Master can create to store the LOB data of one LOB column

Syntax override:

LOBOPTS, LOBLIMIT

XMLOPTS, XMLLIMIT

For more information, see LOBLIMIT.

Specifies a valid management class within the IBM product DFSMS

Log Master uses this management class to allocate LOB or XML VSAM files

Syntax override:

LOBOPTS, MGMTCLAS

XMLOPTS, MGMTCLAS

For more information, see LOBMGMT.

Specifies a prefix name that Log Master uses to derive the name for a LOB or XML VSAM files

Syntax override:

LOBOPTS, PREFIX

XMLOPTS, PREFIX

For more information, see LOBPREF.

Specifies the primary and secondary amounts of space that Log Master uses to allocate LOB or XML VSAM files

Syntax override:

LOBOPTS, SPACE

XMLOPTS, SPACE

For more information, see LOBSPACE.

Specifies a valid storage class within the IBM product DFSMS

Log Master uses this storage class to allocate LOB or XML VSAM files

Syntax override:

LOBOPTS, STORCLAS

XMLOPTS, STORCLAS

For more information, see LOBSTOR.

Specifies the volumes that Log Master uses to allocate LOB or XML VSAM files

Syntax override:

LOBOPTS, VOLUME

XMLOPTS, VOLUME

For more information, see LOBVOLS.

Determines how Log Master processes Db2 log data sets from multiple members of a Db2 data sharing group ¹

Syntax override: LOGOPTS, LOGSORT

For more information, see LOGSORT.

Specifies the maximum number of tape units or DASD data sets that Log Master allocates for reading log files

Syntax override: LOGOPTS, LOGTAPES

For more information, see LOGTAPES.

Directs Log Master to request storage management software to migrate any recalled data sets to their original status

Syntax override: OPTION, MIGRATE

For more information, see MIGRATE.

Determines whether Log Master terminates at the end of processing or waits for data set migration requests to complete

Syntax override: OPTION, WAIT

For more information, see MIGRWAIT.

Specifies how Log Master determines the log scan end point ¹

Syntax override: OPTION, MINLOGPT

For more information, see MINLOGPT.

MOVETABLE

( SPE2104 )

Determines how Log Master opens Db2 data sets, such as table spaces or logs

For more information, see OPNDB2ID.

Determines how Log Master responds if the user running the online interface does not enter a log file name when specifying Db2 log data sets

For more information, see OSRCHCNT.

Specifies a valid storage class within the IBM product DFSMS

Log Master uses this storage class for dynamic allocation of data sets other than sort work data sets.

Syntax override: SORTOPTS, PARMOPTS STORCLAS

For more information, see PARMSTOR.

Specifies a unit name that Log Master uses for dynamic allocation of data sets other than sort work data sets

Syntax override: SORTOPTS, PARMOPTS UNIT

For more information, see PARMUNIT.

Specifies the batch execution Db2 plan for Log Master

For more information, see PLANALPB.

Specifies the online interface Db2 execution plan for Log Master

For more information, see PLANALPO.

Specifies either a prefix or an eight-character plan name that Log Master uses to execute generated SQL

Syntax override: EXECSQL, PLAN NAME

For more information, see PLANESQL.

Determines whether Log Master grants the authority to run Log Master (execute against the Log Master base plan) to PUBLIC

For more information, see PUBLICPLAN.

Excludes from processing members of the data sharing group that are quiesced longer than the specified number of days. If the value is –1 (the default value), Log Master does not exclude quiesced members.

For more information, see QUIESCEAGING.

Determines the keyword that Log Master includes in the recovery syntax that it generates for an automated drop recovery job step

For more information, see REBUILD.

Specifies the amount of memory (below the 16-MB line) that Log Master instructs the sort routine to reserve for processing other than sort processing

Syntax override: SORTOPTS, RESINV

For more information, see RESINV.

Specifies the number of days that you want Log Master to keep ongoing and history records in the Repository tables for a specified work ID. If RETAINTIME is set to ALL, Log Master bypasses record deletion and retains all records in the ongoing and history Repository tables.

For more information, see RETAINTIME=ALL.

Limits the number of early recall subtasks that Log Master creates

Syntax override: OPTION, SMSTASKS

For more information, see SMSTASKS.

Indicates whether Log Master uses the dynamic allocation rules for the sort routine, or allows the user to specify allocation characteristics

Syntax override: SORTOPTS, SORTDYN

For more information, see SORTDYN.

Specifies tape esoteric names of datasets that Log Master allocates for reading log files.

Syntax override: NONE

For more information, see TAPES.

Specifies the character string that Log Master uses to indicate truncated Db2 object names within the online interface

For more information, see TRCHARS.

Defines which part of Db2 object names Log Master truncates for display within the online interface

For more information, see TRPOS.

Specifies the order in which Log Master reads Db2 log files that you explicitly define (either through the online interface or the INPUT DB2LOG keyword of the LOGSCAN statement)

For more information, see ULOGORD.

Specifies the maximum number of data changes (insert, update, or delete actions) that Log Master processes within one unit of work, as represented by one unit of recovery identifier (URID)

Syntax override: OPTION, URID THRESHOLD

For more information, see URIDTHR.

Indicates whether Log Master uses the SYSIBM.SYSLGRNX tables when determining the ranges for a log scan ¹

Syntax override: OPTION, USELGRNG

For more information, see USELGRNG.

Specifies the order in which Log Master reads active and archive log files

Syntax override: OPTION RESOURCE SELECTION LOGS

For more information, see USELOGS.

Specifies whether Log Master should process and use the delete record logged by the DSNUTILB utility when invoked by the DB2 LOAD or REPAIR utilities or by the EXEC SQL statement

Syntax override: OPTION, USE UTILITY DELETES

For more information, see USEUTILITYDELETES.

Specifies a valid storage class within the IBM product DFSMS

Log Master uses this storage class for dynamic allocation of large temporary files and sort work data sets.

Syntax override: SORTOPTS, WORKOPTS STORCLAS

For more information, see WKSTOR.

Specifies the unit name that Log Master uses for dynamic allocation of sort work data sets

Syntax override: SORTOPTS, WORKOPTS UNIT

For more information, see WKUNIT.

Specifies the number of sort work data sets that Log Master uses

Syntax override: SORTOPTS, WORKOPTS NUM

For more information, see WORKNUM.

Specifies a prefix name that Log Master uses to derive the name for an XML VSAM file

Syntax override: STOREOPTS, DATA

For more information, see XMLPREF.