SAP Knowledge Base Article - Preview

2052533 - Incorrect results returned by LOGINFO() function using the CAN_FREE_USING_DUMP_TRAN parameter - SAP ASE with SAP Business Suite


  • System and database adminitrators need a way to accurately determine how much space can be reclaimed by execution of DUMP TRANSACTION.
  • Execution of below query returns incorrect results for some databases:

select dbid, db_name(dbid), loginfo(dbid, 'can_free_using_dump_tran')
from master..sysdatabases

4 mydb 0
5 saptools 18446744073709551536
31516 dbccdb 0
8 mytools 0

  • The value reported for the saptools database is impossibly high
    • The 'can_free_using_dump_tran' parameter should return a value from 0 to 100, a percentage of the amount of log space that can be reclaimed without disturbing the oldest active transaction in the database. 
    • DBACockpit may terminate with an "Arithmetic Overflow" message when checking log usage information.
    • Other applications dependent on LOGINFO() output may encounter unexpected errors.



  • SAP Adaptive Server Enterprise (ASE) 15.7 SP110 
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 
  • SAP Adaptive Server Enterprise (ASE) 15.7 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.