Symptom
- When executing the ASE system stored procedure sp_helpdb <DB_NAME>, the message "-- unused by any segments --" is reported for some parts of disk:
- Example:
exec sp_helpdb TEST_SEG
go
name db_size owner dbid created durability lobcomplvl inrowlen status
---------------- -------------------------- ---------- -------- ------------------------ -------------------- -------------------- ---------------- ----------------------------
TEST_SEG 30.0 MB sa 12 Jun 16, 2022 full 0 NULL no options set
(1 row affected)
device_fragments size usage created free_kbytes
-------------------------------- -------------------------- ---------------------------------------------------------- -------------------------------------- --------------------------------
TEST_SEG_DATA_01 10.0 MB data only Jun 16 2022 9:34AM 6728
TEST_SEG_LOG 10.0 MB log only Jun 16 2022 9:34AM not applicable
TEST_SEG_DATA_02 10.0 MB -- unused by any segments -- Jun 16 2022 9:35AM 10200
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
log only free kbytes = 10196
device segment
-------------------------------- ----------------------------------------------------------
TEST_SEG_DATA_01 default
TEST_SEG_DATA_01 system
TEST_SEG_DATA_02 -- unused by any segments --
TEST_SEG_LOG logsegment
(return status = 0)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
Keywords
sp_addsegment, sp_dropsegment, sp_extendsegment, sp_helpsegment, sp_helpdb, unused by any segments, segments, unused , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview