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

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

Symptom

  • 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.

Read more...

Environment

  • 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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

DUMP TRANSACTION. DBA cockpit
  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.