Symptom
- How to reduce the time spent filling free space info during recovery?
- Unexpected shutdown of ASE
- Most of the time spent by Recovery is done filling free space info for the database
- ASE calculates free space count for non-log segment
00:0000:00000:00016:2019/04/25 14:20:41.04 server Recovering database '<database>'.
00:0000:00000:00016:2019/04/25 14:20:41.05 server Started estimating recovery log boundaries for database '<database>'.
00:0000:00000:00016:2019/04/25 14:20:41.09 server Database '<database>', checkpoint=(504657, 9), first=(504657, 8), last=(504710, 5).
00:0000:00000:00016:2019/04/25 14:20:41.09 server Completed estimating recovery log boundaries for database '<database>'.
00:0000:00000:00016:2019/04/25 14:20:41.09 server Started ANALYSIS pass for database '<database>'.
00:0000:00000:00016:2019/04/25 14:20:41.09 server Completed ANALYSIS pass for database '<database>'.
00:0000:00000:00016:2019/04/25 14:20:41.09 server Log contains all committed transactions until 2019/04/25 13:55:31.90 for database <database>.
00:0000:00000:00016:2019/04/25 14:20:41.09 server Started REDO pass for database '<database>'. The total number of log records to process is 205.
00:0028:00000:00016:2019/04/25 14:21:54.12 server Completed REDO pass for database '<database>'.
00:0028:00000:00016:2019/04/25 14:21:54.12 server Timestamp for database '<database>' is (0x6613, 0x186535cb).
00:0028:00000:00016:2019/04/25 14:21:54.12 server Recovery of database '<database>' will undo incomplete nested top actions.
00:0028:00000:00016:2019/04/25 14:21:54.29 server Started recovery checkpoint for database '<database>'.
00:0028:00000:00016:2019/04/25 14:21:54.34 server Completed recovery checkpoint for database '<database>'.
00:0028:00000:00016:2019/04/25 14:21:54.34 server Started filling free space info for database '<database>'.
00:0004:00000:00016:2019/04/25 14:41:02.80 server Completed filling free space info for database '<database>'.
00:0004:00000:00016:2019/04/25 14:41:02.80 server Started cleaning up the default data cache for database '<database>'.
00:0004:00000:00016:2019/04/25 14:41:08.14 server Completed cleaning up the default data cache for database '<database>'.
00:0004:00000:00016:2019/04/25 14:41:13.49 server The transaction log in the database '<database>' will use I/O size of 4 Kb.
00:0004:00000:00016:2019/04/25 14:41:13.49 server Database '<database>' is now online.
00:0007:00000:00040:2019/04/25 14:41:14.60 server Started Rep Agent on database, '<database>' (dbid = 5).
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
Keywords
recovery, free space, abnormal, shutdown, OAM, allocation, GAM , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview