SAP Knowledge Base Article - Preview

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

Symptom

  • Ct wants 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) , Problem

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.