SAP Knowledge Base Article - Preview

2946665 - How to shrink a data device size resized a few times of a user database? - ASE

Symptom

  • Want to shrink a data device(<SID>_D57 resized a few times because it resized with a wrong size last time.
  • Information of the devices usage(<SID>_D57)

    device_fragments size usage created free_kbytes
    =================================
    ...
    <SID>_D50 20720.0 MB data only Jan 11 2019 10:55PM 0
    <SID>_D52 32000.0 MB data only Jan 11 2019 10:55PM 29762742
    <SID>_D53 30720.0 MB data only Jan 11 2019 10:55PM 31334400
    <SID>_D54 30720.0 MB data only Feb 28 2019 8:39PM 31334400
    <SID>_D55 10000.0 MB data only Mar 14 2019 3:03PM 10200000
    <SID>_D55 10000.0 MB data only Mar 15 2019 6:59AM 10200000
    <SID>_D55 10000.0 MB data only Mar 15 2019 7:12AM 10200000
    <SID>_D56 10000.0 MB data only Mar 21 2019 3:34PM 10200000
    <SID>_D56 10000.0 MB data only Mar 21 2019 3:51PM 10200000
    <SID>_D56 10000.0 MB data only Mar 21 2019 4:02PM 10200000
    <SID>_D57 10000.0 MB data only May 30 2019 4:34PM 10200000
    <SID>_D57 10000.0 MB data only May 30 2019 5:06PM 10200000
    <SID>_D57 300000.0 MB data only Jul 9 2020 2:04AM 306000000


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16 SP03 PL07

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.