SAP Knowledge Base Article - Preview

2786706 - How to reduce the time recovery spends doing "Filling Free Space Info" - SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.