SAP Knowledge Base Article - Preview

2948378 - sp_dump_history using purge removed almost all history

Symptom

- Run:  sp_dump_history 'purge', @until_time= 'Jul 13 2020 4:30:00:00PM'  clears out dumphist file

- $SYBASE/$SYBASE_ASE (unix) or %SYBASE%\%SYBASE_ASE%  contains the dumphist.* files

- In this case the last 3 dumphist.* files are <<dumphist.000000018>>, <<dumphist.000000019>>, <<dumphist.000000020>>
  They have same number of identical entries and each having 7 datetime of dump entries:

      Jul 13 2020 2:12:02:533PM ... ... ... 
      Jul 13 2020 2:30:01:530PM ... ... ... 
      Jul 13 2020 3:12:01:513PM ... ... ... 
      Jul 13 2020 3:20:02:510PM ... ... ... 
      Jul 13 2020 3:30:02:503PM ... ... ... 
      Jul 13 2020 4:20:02:500PM ... ... ... 
      Jul 13 2020 4:30:01:486PM ... ... ...

- <<dumphist>> file is the active and currently used file. The 1st entry is always the following (it is in every dumphist* file):

    0|0|1.1|0|Jan 1 1900 12:00:00:000AM|Jan 1 1900 12:00:00:000AM|Jan 1 1900 12:00:00:000AM| |0|*|0|0|0| |Jan 1 1900 12:00:00:000AM

- We see that the next line in the current <<dumphist>> is:

 3|4|SID|1|Jul 13 2020 4:50:01:480PM|Jul 13 2020 5:30:02:470PM|Jul 13 2020 5:30:02:470PM|sybackup::SID.SID.T.0.36766514.13-07-2020.17:30:02 -SERV HOSTNAME -CLIENT hostname SYBASE_LOG|0|*|0|0|1| |Jul 13 2020 5:30:35:210PM

This suggests that the issuance of [ sp_dump_history 'purge', @until_time= 'Jul 13 2020 4:30:00:00PM' ] command did exactly as it was suppose to do.
It had deleted all entries up to  'Jul 13 2020 4:30:00:00PM'


Read more...

Environment

  • On Business Suite or Standalone/On-premise
  • SAP Adaptive Server Enterprise 16.0
  • SAP Adaptive Server Enterprise 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

dumphist, purge, purgefiles, dump configuration, deleted entries, lost entries, dump database, dump transaction, dump tran , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.