2691648 - sp_helpdb reports usage -- unused by any segments -- SAP ASE

Symptom

When running sp_helpdb <database_name> the usage column reports a value of "-- unused by any segments --" for device usages that contain only user defined segments.

1> sp_helpdb segdb

2> go

name db_size owner dbid created durability lobcomplvl inrowlen status
---------- -------------------------- ---------- -------- ------------------------ -------------------- -------------------- ---------------- ------------------------------------
segdb 30.0 MB sa 51 Sep 07, 2018 full 0 NULL trunc log on chkpt
(1 row affected)
device_fragments size usage created free_kbytes
-------------------------------- -------------------------- ---------------------------------------------------------- -------------------------------------- --------------------------------
d1 10.0 MB data only Sep 7 2018 2:30PM 6600
d2 10.0 MB -- unused by any segments -- Sep 7 2018 2:30PM 10200
d3 10.0 MB log only Sep 7 2018 2:30PM not applicable
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
log only free kbytes = 10196
device segment
------------ --------------------
d1 default
d1 system
d2 mysegment
d3 logsegment
(return status = 0)

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL05
SAP Adaptive Server Enterprise (ASE) 15.7 SP140

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Sybase, ASEServer, SAPASE, dataserver, CR816545, CR#816545, 816545 , 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 for Me (Login required).

Search for additional results

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