SAP Knowledge Base Article - Preview

2320948 - Shrink large database hang on ASE 15.7 SP134

Symptom

  • The process of shrink database is long time running on large db and never complete.
  • select physical_io from sysprocesses, ---- no physical_io changed
  • sp_lock, ---- long time remains on same table
  • select shrinkdb_status for au_current, ---- long time no change
  • Following are the stacktrace of the shrink database process:
        upyield
        getpage_with_validation
        getpage__noscan
        altdb__dol_idx_sibling
        altdb__dol_idx_sibling
        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
        alterdb
        s_execute
        sequencer
        tdsrecv_language
        conn_hdlr
  • sysmon, ----  Cache Hits in default data cache is very large
  • select * from monProcessObject, ---- LogicalReads continue increasing

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP134 (15.7.0.134)

Product

SAP Adaptive Server Enterprise 15.7

Keywords

shrink database, upyield, getpage_with_validation, getpage__noscan, altdb__dol_idx_sibling, altdb__propagate_rid_dol, altdb__propagate_dupkey_group_dol, altdb__repair_idx_grp_dol, ASE, SYBASE , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.