print deadlock information  procedure cache size

Chapter 5: Setting Configuration Parameters

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

The print recovery information parameter 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 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.





Copyright © 2005. Sybase Inc. All rights reserved. procedure cache size

View this book as PDF