print recovery information

Summary information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Dynamic

Display level

Intermediate

Required role

System Administrator

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