Skip to Content

Default language.

+WRLOG

Related topics

Global parameters (UTLPARMS)

SQLID

The +WRLOG global parameter specifies whether to enable or disable the writing of diagnostic log records. These log records are used to notify replication tools that the base tables have been changed through BMC AMI Utilities. These records are written regardless of whether the object is replicated or not.

WRLOG.png

The values are defined as follows:

NO

(Default) Disables REPAIR WRITELOG processing.

YES

Enables REPAIR WRITELOG processing. (BMC.DB2.SPE2401) If +SQLID is configured and no configuration for +WRLOGID exists, the specified +SQLID user ID will run the REPAIR WRITELOG.

Warning

Important

Specifying +WRLOG(YES):

  • Invokes DSNUTILB REPAIR to write the log record.
  • BMC AMI Reorg and BMC AMI Load will write log records under the following conditions:
    • BMC AMI Reorg when rows are discarded
    • All BMC AMI loads with the exception of LOAD RESUME YES SHRLEVEL CHANGE 
Warning

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Load for Db2 13.1