2948378 - sp_dump_history using purge removed almost all history - SAP ASE

- 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'

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver (NW) - All versions
• SAP Adaptive Server Enterprise

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