Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Installation options quick reference

The following table lists the installation options (also known as DOPTs) in alphabetical order and provides their default values, a brief description, and includes any SYSIN syntax that can override the option’s value.

For detailed descriptions, see Installation option descriptions.

Log Master for DB2 installation options quick reference

Installation option

Shipped value

Brief description

ALPOFDSN

None

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.

AMSGLEV

0

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

For more information, see AMSGLEV.

ANPCT

20

Specifies the percentage of key store memory that is allocated to the anomaly (AN) key store

Syntax override: STOREOPTS, MEMPERCENT ANOMALY

For more information, see ANPCT.

APFONLIN

YES

Determines whether the online interface runs as an authorized TSO command

For more information, see APFONLIN.

BCPCT

10

Specifies the percentage of key store memory that is allocated to the backward completion (BC) key store

Syntax override: STOREOPTS, MEMPERCENT BACKWARDCOMPLETION

For more information, see BCPCT.

BINDOWN

None

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.

BINDQUALIFIER

ALPvvr

Specifies a qualifier value that Log Master uses during execution to dynamically bind internal packages that are distributed with Log Master

For more information, see BINDQUALIFIER.

BYPASSLL

NO

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.

CMPLGRNG

YES

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.

CSTFILE

2000

Defines the relative cost of processing an additional data set, expressed in terms of the cost to read one page from the DB2 log

Syntax override: OPTION, FILECOST

For more information, see CSTFILE.

CSTMOUNT

25000

Defines the relative cost of a single tape mount, expressed in terms of the cost to read one page from the DB2 log

Syntax override: OPTION, FILECOST

For more information, see CSTMOUNT.

CSTSEG

2000000000

Defines the relative cost of obtaining information from a segmented table space, expressed in terms of the cost to read one page from the DB2 log

Syntax override: OPTION, FILECOST

For more information, see CSTSEG.

DASDDSNS

10

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.

DB2AUTH

NO

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

For more information, see DB2AUTH.

DB2CAT

NO

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.

DB2DIR (PTF BQU1717 applied)NO

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.

DBCS

NO

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.

DDLOBJ

NO

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

Syntax override: LOGSCAN, INCLUDE DDL OBJECTS

For more information, see DDLOBJ.

DDPRMBR

YES

Specifies the scope of the DASDDSNS value 1

Syntax override: OPTION, PER MEMBER

For more information, see DDPRMBR.

DSNSYMPRE

YES

Forces the prefix for &TABNAME and &WORKID in input and output data set names

For more information, see DSNSYMPRE.

ERLYRCL

YES

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.

EXECMODE

CURRENT

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 (PTF BQU2875 applied)None

Specifies the names of DB2 data sharing members that should be excluded from processing

Syntax override: INPUT BSDS EXCLUDE clause

For more information, see EXCLUDEMEMBERS.

FCPCT

10

Specifies the percentage of key store memory that is allocated to the forward completion (FC) key store

Syntax override: STOREOPTS, MEMPERCENT FORWARDCOMPLETION

For more information, see FCPCT.

FCUSE

YES

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.

FLTRMTHD

STATIC

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.

GENMDEL

YES

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.

IMAGESRC

ANY

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

Syntax override: OPTION, IMAGESOURCE

For more information, see IMAGESRC.

KEYDSNAM

None

Specifies the name of the key data set that is used for encrypted image copies

For more information, see KEYDSNAM.

KSMEMORY

100M, 10M

Specifies the amount of memory that is used to allocate a temporary working storage area called a key store that Log Master uses for processing DB2 log records

(PTF BQU0316 applied)

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.

LLOGAUTH

NO

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

For more information, see LLOGAUTH.

LOADEX

YES

Specifies whether to include exchange records in load outputs

For more information, see LOADEX.

LOADFMT

LOGMAST

Specifies the overall format for the load data files and load control files

Syntax override: LOGSCAN, LOAD FORMAT

For more information, see LOADFMT.

LOADMD

YES

Specifies whether to include mass delete records in load outputs

For more information, see LOADMD.

LOADNCP (PTF BQU2603 applied)NO

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.

LOBALLOC

CYLINDERS

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.

LOBDATA

None

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.

LOBDUPDS

ERROR

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.

LOBLIMIT

10

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.

LOBMGMT

None

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.

LOBPREF

&&SYSUID..LOB

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.

LOBSPACE

10, 10

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.

LOBSTOR

None

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.

LOBVOLS

None

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.

LOCCPSEL

(FC,LP,LB)

Specifies resource selection for local site copies

Syntax override: OPTION, RESOURCE SELECTION, COPIES

For more information, see LOCCPSEL.

LOGSORT

WHENEVER

Determines how Log Master processes DB2 log data sets from multiple members of a DB2 data sharing group 1

Syntax override: LOGOPTS, LOGSORT

For more information, see LOGSORT.

LOGTAPES

0

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.

LRPCT

40

Specifies the percentage of key store memory that is allocated to the log record (LR) key store

Syntax override: STOREOPTS, MEMPERCENT LOGRECORD

For more information, see LRPCT.

MIGRATE

YES

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.

MIGRWAIT

NO

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.

MINLOGPT

NO

Specifies how Log Master determines the log scan end point 1

Syntax override: OPTION, MINLOGPT

For more information, see MINLOGPT.

MTPRMBR

NO

Specifies the scope of the SMSTASKS value 1

Syntax override: OPTION, PER MEMBER

For more information, see MTPRMBR.

OPNDB2ID

YES

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

For more information, see OPNDB2ID.

OSRCHCNT

3

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.

PARMSTOR

None

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.

PARMUNIT

None

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.

PLANALPB

ALPBvvr

Specifies the batch execution DB2 plan for Log Master

For more information, see PLANALPB.

PLANALPO

ALPOvvr

Specifies the online interface DB2 execution plan for Log Master

For more information, see PLANALPO.

PLANESQL

ALP

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.

PUBLICPLAN

YES

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.

QUIESCEAGING

–1

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.

REBUILD

NO

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.

REMCPSEL

(RP,RB,FC)

Specifies resource selection for remote site copies

Syntax override: OPTION, RESOURCE SELECTION, COPIES

For more information, see REMCPSEL.

RESINV

0K

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.

RETAINTIME (PTF BQU2282 applied)ALL

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.

SMCORE

0M, 0K

Specifies the maximum amount of memory that the sort routine uses

Syntax override: SORTOPTS, SMCORE

For more information, see SMCORE.

SMSTASKS

0

Limits the number of early recall subtasks that Log Master creates

Syntax override: OPTION, SMSTASKS

For more information, see SMSTASKS.

SORTDYN

USE

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.

TAPES

CART, TAPE

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

Syntax override: NONE

For more information, see TAPES.

TRCHARS

>>

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

For more information, see TRCHARS.

TRPOS

END

Defines which part of DB2 object namesLog Master truncates for display within the online interface

For more information, see TRPOS.

TZRULE

NONE

Specifies the rules that determine when Daylight Saving Time (DST) begins and ends

Use this installation option to enable DST adjustments.

For more information, see TZRULE.

ULOGORD

ASCENDING

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.

UNITWAIT

YES

Determines whether dynamic file allocations should wait for unavailable resources

For more information, see UNITWAIT.

URIDTHR

0

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.

URPCT

20

Specifies the percentage of key store memory that is allocated to the URID (UR) key store

Syntax override: STOREOPTS, MEMPERCENT URID

For more information, see URPCT.

USELGRNG

NO

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

Syntax override: OPTION, USELGRNG

For more information, see USELGRNG.

USELOGS

ACT1, ACT2, ARCH1, ARCH2

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

Syntax override: OPTION RESOURCE SELECTION LOGS

For more information, see USELOGS.

USEUTILITYDELETES

YES

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.

UTILPLNS

None

Specifies the plan names of any products that can perform LOAD LOG YES, LOAD REPLACE, or REORG LOG YES actions

For more information, see UTILPLNS.

WKSTOR

None

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.

WKUNIT

None

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.

WORKNUM

0

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

Syntax override: SORTOPTS, WORKOPTS NUM

For more information, see WORKNUM.

XMLPREF

&&SYSUID..XML

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.

ZIIP

ENABLED

Determines whether zIIP processing is enabled

Syntax override: ZIIP

For more information, see ZIIP.

1 This option applies only in a data sharing environment.






Was this page helpful? Yes No Submitting... Thank you

Comments