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.