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 ONE Support launchpad (Login required).

Search for additional results

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