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.
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.