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.