print recovery information

Summary information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Dynamic

Display level

Intermediate

Required role

System administrator

Configuration group

Backup/Recovery

print recovery information determines what information Adaptive Server displays on the console during recovery. (Recovery is performed on each database at Adaptive Server start-up and when a database dump is loaded.) The default value means that Adaptive Server displays only the database name and a message saying that recovery is in progress. A value of 1 indicates that Adaptive Server displays information about each individual transaction processed during recovery, including whether it was aborted or committed.