Symptom
- The output of sp_helpdb <DBNAME> does not show the message of logsegment free space "log only free kbytes = XXXX"
e.g
1> sp_helpdb saptools
2> go
name db_size owner dbid created durability lobcomplvl inrowlen status
---------------- -------------------------- ---------- -------- ------------------------ -------------------- -------------------- ---------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
saptools 2480.0 MB sapsa 4 Dec 15, 2021 full 0 NULL abort tran on log full, no free space acctg, allow wide dol rows, unique auto_identity index, allow incremental dumps
(1 row affected)
device_fragments size usage created free_kbytes
-------------------------------- -------------------------- ------------------ -------------------------------------- --------------------------------
saptools_dev 1000.0 MB data only Dec 15 2021 10:48AM 458158
saptools_log 280.0 MB log only Dec 15 2021 10:48AM not applicable
saptools_log 200.0 MB log only Dec 25 2022 12:07PM not applicable
saptools_dev 1000.0 MB data only Dec 25 2022 12:01PM 1020000
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- The output above not message "log only free kbytes = xxxxx" , general speaking it should be shown in the end of the output.
Read more...
Environment
Adaptive Server Enterprise (ASE)
Product
Keywords
sp_helpdb, unique auto_identity index, log only free kbytes, sysdatabases, status2 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview