Tracing tab (UDB, IBM i) - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

Table in Metabase

msglvl

Type of messages to send to the metabase, from where they are then retrieved by the Connect CDC Director for monitoring. Each level includes the functionality of the levels listed above it. Numerically higher settings send more information, but may reduce performance.

• None (msglvl=-1)

• Errors (msglvl=2) An error counter is incremented. This is the default.

• Warnings (msglvl=3)

• Information (msglvl=4) Typically, confirmations of a successful operation.

• SQL Print (msglvl=5) SQL Statements (sqlprint parameter) messages.

Log File

filelvl

Type of messages the process sends to its log file. Each level includes the functionality of the levels listed above it. Numerically higher settings send more information to the log, but may reduce performance.

Any level other than None sends statistics data to the statistics file of the process.

• Errors (filelvl=2) An error counter is incremented.

• Warnings (filelvl=3)

• Information (filelvl=4) Typically, confirmations of a successful operation.

• SQL Print (filelvl=5) SQL Statements (sqlprint parameter) messages. This is the default.

Console   

printlvl

Message print level. The type of messages to send to standard output or the console. Each level includes the functionality of the levels listed above it. Numerically higher settings send more information but may reduce performance.

• None (printlvl=-1) This is the default.

• Always (printlvl=0)

• Status (printlvl=1)

• Errors (printlvl=2) Error counter is incremented.

• Warnings (printlvl=3)

• Information (printlvl=4) Typically, confirmations of a successful operation.

• SQL Print (printlvl=5) SQL Statements (sqlprint parameter) messages.

SQL Statements

sqlprint

Writes to the process log file the dynamic SQL statements being generated by the component process, if any. The value you specify identifies the types of statements written. You can sum the values below to include multiple types:

• Base table references (sqlprint=1)

• Shadow table references (sqlprint=2)

• Conflict detection and resolution (sqlprint=4)

• SQL from messaging system (sqlprint=8)

• All other SQL queries (sqlprint=16)

• Rollbacks and commits (sqlprint=32)

The default is for all values to be deselected.

Miscellaneous:Include message number in messages

msgnoprt

Select to include the message number in messages. (This is the default.)

Miscellaneous:Monitor statistics

monitor

Select to automatically send statistics messages at the end of each period (where a period is the value of the period configuration parameter). This is the default.