SAP Knowledge Base Article - Preview

2771551 - Alter database OFF to shrink database is very slow - SAP ASE

Symptom

  • Alter database shrink is very slow or appears to hang.
  • Alter database shrink seems to freeze never finish
  • Following functions calls are seen on top of the stack:
    • upyield
    • getpage_with_validation
    • getpage__noscan
    • altdb__dol_idx_sibling
    • altdb__propagate_rid_dol
    • altdb__propagate_dupkey_group_dol
    • altdb__repair_idx_grp_dol
    • altdb__finish_obj_au_move
    • altdb__move_extents
    • altdb__clear_chunk
    • altdb__clear_lpages
    • altdb__do_shrinkdb
    • altdb_shrink


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP100 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

shrinkdb, duplicate, dupkey, with check_only, reorg, rebuild , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.