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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.