Try OpenEdge Now
skip to main content
OpenEdge 11.6.1 New Information : OpenEdge RDBMS
 

OpenEdge RDBMS

Release 11.6.1 of OpenEdge RDBMS includes the full activation of the Crash Recovery Status options. There are two startup parameters for database brokers and database utilities that control Crash Recovery Status (-crStatus and -crTXDisplay). These startup parameters were documented in 11.6.0, but deactivated.
When crash recovery is performed on a large and active database, crash recovery can take longer than a few seconds to run. Two startup parameters can help you monitor the progress of your crash recovery by logging status messages to the screen:
*crStatus — Displays the phase progress as an estimate of percent complete, every n seconds. The default is 30. The following example shows the output displayed to the screen during crash recovery with -crStatus 5:
Logical Undo 9% at block 2967. 2926 blocks processed in 5 seconds.
Logical Undo 19% at block 5744. 5653 blocks processed in 10 seconds.
Logical Undo 29% at block 8916. 8881 blocks processed in 15 seconds.
Logical Undo 38% at block 11543. 11502 blocks processed in 20 seconds.
Logical Undo 48% at block 14294. 14255 blocks processed in 25 seconds.
Logical Undo 56% at block 16850. 16819 blocks processed in 31 seconds.
Logical Undo 65% at block 19545. 19500 blocks processed in 36 seconds.
Logical Undo 75% at block 22587. 22474 blocks processed in 41 seconds.
Logical Undo 84% at block 25138. 25043 blocks processed in 46 seconds.
Logical Undo 93% at block 27725. 27704 blocks processed in 51 seconds.
Logical Undo 100% at block 29568. 29573 blocks processed in 54 seconds.
*crTXDisplay — Displays transaction IDs and adds counters to the -crStatus output. For example:
Transaction 2048 by user 15 at 2015/08/06@16:53:49. Counter: 202
Transaction 5771 by user 12 at 2015/08/06@16:55:15. Counter: 459
Transaction 24 by user 7 at 2015/08/06@16:52:49. Counter: 1
Transaction 5801 by user 10 at 2015/08/06@16:55:15. Counter: 460
Transaction 5802 by user 14 at 2015/08/06@16:55:16. Counter: 463
Transaction 5683 by user 18 at 2015/08/06@16:55:15. Counter: 459
Logical Undo 10% at block 3205. 3200 blocks processed in 5 seconds. Counter: 413
Logical Undo 21% at block 6427. 6378 blocks processed in 10 seconds. Counter: 363
Logical Undo 30% at block 9038. 9015 blocks processed in 15 seconds. Counter: 322
Logical Undo 38% at block 11581. 11464 blocks processed in 20 seconds. Counter: 283
Logical Undo 44% at block 13148. 13097 blocks processed in 25 seconds. Counter: 258
Logical Undo 50% at block 14994. 14963 blocks processed in 31 seconds. Counter: 229
Logical Undo 58% at block 17502. 17447 blocks processed in 36 seconds. Counter: 190
Logical Undo 64% at block 19210. 19195 blocks processed in 41 seconds. Counter: 163
Logical Undo 71% at block 21264. 21237 blocks processed in 46 seconds. Counter: 131
Logical Undo 82% at block 24412. 24361 blocks processed in 51 seconds. Counter: 82
Logical Undo 90% at block 27070. 26951 blocks processed in 56 seconds. Counter: 41
Logical Undo 100% at block 29568. 29573 blocks processed in 60 seconds. Counter: 1
Note: The crash recovery parameters provide output when used with a database broker or the database utilities. For other database connections, such as a single-user client, a remote client, or DBTOOL, the parameters are ignored.
See Release 11.6.0 OpenEdge Data Management: Database Administration for more information.