SET_MIRROR_FLIGHT_RECORDER_INFO procedure

Edit online

The SET_MIRROR_FLIGHT_RECORDER_INFO procedure sets values that are used for the Db2® Mirror flight recorder.

Authorization: For the authority needed to use this procedure, see Authorization.

Read syntax diagramSkip visual syntax diagram SET_MIRROR_FLIGHT_RECORDER_INFO ( ARCHIVE_RETENTION_DAY_COUNT => archive-retention-day-count,MAX_SYSBAS_PERCENTAGE => max-sysbas-percentage,FLIGHT_RECORDER_LOGGING_LEVEL => flight-recorder-logging-level,ENGINE_CONTROLLER_LOGGING_LEVEL => engine-controller-logging-level,OBJECT_REPLICATION_MANAGER_LOGGING_LEVEL => object-replication-manager-logging-level,OBJECT_RECEIVER_LOGGING_LEVEL => object-receiver-logging-level,ENGINE_COMMUNICATION_LOGGING_LEVEL => engine-communication-logging-level,ENGINE_STATE_LOGGING_LEVEL  => engine-state-logging-level,ENGINE_JOB_LOGGING_LEVEL => engine-job-logging-level,LOGGER_TESTING_LOGGING_LEVEL => logger-testing-logging-level,CONFIGURATION_PROCESSING_LOGGING_LEVEL => configuration-processing-logging-level,RCL_LOGGING_LEVEL => rcl-logging-level,SECURITY_OBJECT_LOGGING_LEVEL => security-object-logging-level,NRG_LOGGING_LEVEL => nrg-logging-level,OBJECT_REGISTRY_LOGGING_LEVEL => object-registry-logging-level,OBJECT_SYNCHRONIZATION_LOGGING_LEVEL => object-synchronization-logging-level,SPOOL_LOGGING_LEVEL => spool-logging-level,OUTPUT_AND_JOB_QUEUE_LOGGING_LEVEL => output-and-job-queue-logging-level,DATA_QUEUE_LOGGING_LEVEL => data-queue-logging-level,WORK_MANAGEMENT_LOGGING_LEVEL => work-management-logging-level,VARY_IASP_LOGGING_LEVEL => vary-iasp-logging-level,DATABASE_LOGGING_LEVEL => database-logging-level,UTILITIES_LOGGING_LEVEL => utilities-logging-level,SAVE_RESTORE_LOGGING_LEVEL => save-restore-logging-level,DB_CONNECTION_LOGGING_LEVEL => db-connection-logging-level,ENGINE_CONNECTION_LOGGING_LEVEL => engine-connection-logging-level,IFS_CONNECTION_LOGGING_LEVEL => ifs-connection-logging-level,OBJECT_CONNECTION_LOGGING_LEVEL => object-connection-logging-level,QUORUM_SERVER_LOGGING_LEVEL => quorum-server-logging-level,RESYNC_LOGGING_LEVEL => resync-logging-level,ACTION => action,HEALTH_MONITOR_LOGGING_LEVEL => health-monitor-logging-level,COMPARE_PROCESSING_LOGGING_LEVEL => compare-processing-logging-level,SYSTEM_SQL_LOGGING_LEVEL => system-sql-logging-level )

The schema is QSYS2.

archive-retention-day-count

The number of days flight recorder logs are retained. The value cannot exceed 100.

Logs will never be saved more than 100 days. The shipped default for this parameter is 10 days.

max-sysbas-percentage

The maximum percentage of SYSBAS storage that the flight recorder can consume for active and archived information. Valid values are 1 to 10.

The shipped default for this parameter is 5, indicating 5%.

xxx-logging-level

A logging level can be defined for each distinct category of Db2 Mirror functionality.

The shipped default level varies for each category. The levels should only be changed if directed by IBM® i Service.

NONE
No log entries are generated.
ERROR
Log entries are generated for run time errors and unexpected conditions.
WARNING
Log entries for the ERROR level are generated, plus entries for errors or other run time situations that are unexpected or unusual but not necessarily wrong.
INFO
Log entries for the WARNING level are generated, plus interesting run time events.
DEBUG
All log entries for the INFO level are generated, plus debug information.
action

The action to perform.

ENDJOB
End the QMRDBLOGR job.
While the QMRDBLOGR job is not active the generation of new log entries may be suspended.
STARTJOB
Start the QMRDBLOGR job.
SUSPEND
Suspend generation of new log entries in the flight recorder.
RESUME
Resume generation of new log entries in the flight recorder.

Example

Configure the Db2 Mirror Flight recorder to capture full details for RCL operations, with at most 3 days of detail retained and consuming at most 5% of SYSBAS storage.
CALL QSYS2.SET_MIRROR_FLIGHT_RECORDER_INFO(
     ARCHIVE_RETENTION_DAY_COUNT => 3,
     MAX_SYSBAS_PERCENTAGE       => 5.0,
     RCL_LOGGING_LEVEL           => 'DEBUG');