2965494 - sp_helpdb shows NULL values for database size - SAP ASE

Here is an example,

1> sp_helpdb test
2> go
name db_size owner dbid created durability lobcomplvl inrowlen
status

---- ------- ----- ---- ------------ ---------- ---------- --------
---------------------------------------------------------------------
------------------------------------------------------------------------------
------------------------------------------------------------------------------
-------------------------------------------
test MB sa 4 Apr 04, 2017 full 100 2000
(1 row affected)

device_fragments size usage created free_kbytes
---------------- ---- --------- ------------------- --------------
test_data_001 MB data only Apr 4 2017 8:37PM NULL
test_data_002 MB data only Apr 4 2017 8:37PM NULL
test_log_001 MB data only Apr 4 2017 8:37PM not applicable

log only free kbytes =

(return status = 0)

• SAP Adaptive Enterprise Server 15.7
• SAP Adaptive Enterprise Server 16.0

sp_helpdb, NULL, size, spt_values, installmaster, instmstr , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem