UseLLogSysStrings


A logical log file generated by BMC AMI Log Master for Db2 contains SysStrings records that define the translation information, including the coded character set identifiers (CCSIDs), that was in use when the file was generated. The UseLLogSysStrings parameter determines whether the High-speed Apply Engine uses the translation information from the logical log to translate input data before it applies the data to the target Db2 subsystem.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[LogicalLog]

Abbreviation

None

Required?

No

Valid values

Yes or No

Default value

No

Usage

We recommend that you use the default value of No for normal processing.

  • Specify Yes to direct High-speed Apply Engine to translate the input data before applying it to the target subsystem. Use this value when Db2 would not be able to successfully translate between the source column and target column encoding schemes by itself. This situation can occur when a translation scheme is either undefined or different in the SysStrings information on the target subsystem.

    For example, you can specify Yes when the SYSIBM.SYSSTRINGS table on the source Db2 subsystem contains a user-defined translation scheme that is not available on the target subsystem. High-speed Apply Engine performs the translation using information from the logical log file. In this example, Db2 would still need to be able to successfully translate from the source application encoding scheme to the target column encoding scheme.

  • Specify No to direct High-speed Apply Engine to apply the input data directly to the target subsystem as is (without translation). Use this value for normal processing when the conditions described for the Yes value do not exist. Specifying No can improve performance in some cases by avoiding unnecessary translation actions. This value is the default.

 

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