2727254 - ASE log shows upgrade messages after running sp_downgrade_ esd - SAP ASE

• After a minor downgrade using sp_downgrade_esd
• The ASE errorlog prints 'upgrade' messages while showing the correct (lower) server version :
  
  Database 'master' appears to be at an older version '16.0 SP02 PL05' than the present installation at version '16.0 SP02 PL05'; ASE will assess it, and upgrade it as required.
  Database 'master': beginning upgrade step [ID     2]: validate basic system type date
  
  
• This example is from a downgrade to SP02 SP05, but it applies to other versions as well
  
  sp_downgrade_esd 'testdb','SP02 PL05'
  go
  
  -- console outputs
  Reverting database 'testdb' to SP02 PL05.
  Running CHECKPOINT on database 'testdb' for option 'downgrade' to take effect.
  Downgrade is complete.
  Database 'testdb' is now suitable for use by SP02 PL05.
  
  -- on restarting with SP02 PL05 binaries, ASE errorlog includes:
  
  00:0000:00000:00000:2018/11/29 15:59:36.69 kernel  Adaptive Server Enterprise/16.0 SP02 PL05/EBF 26670 SMP/P/x86_64/Enterprise Linux/ase160sp02pl05x/2714/64-bit/FBO/Sun Dec  4 07:35:11 2016
  ...
  00:0000:00000:00002:2018/11/29 15:59:38.03 server  Database 'master' appears to be at an older version '16.0 SP02 PL05' than the present installation at version '16.0 SP02 PL05'; ASE will assess it, and upgrade it as required.
  00:0000:00000:00002:2018/11/29 15:59:38.04 server  Database 'master': beginning upgrade step [ID     2]: validate basic system type dat
  00:0000:00000:00002:2018/11/29 15:59:38.15 server  Database 'master': beginning upgrade step [ID    75]: executing SQL statement ("update syscolumns set type=66, user...
  
  (lines removed for brevity)
  
  00:0000:00000:00002:2018/11/29 15:59:40.20 server  Database 'master': beginning upgrade step [ID  1702]: noting the present database upgrade level
  00:0000:00000:00002:2018/11/29 15:59:40.20 server  Database 'master': beginning upgrade step [ID  1719]: executing SQL statement ("update sysattributes set object_inf...")
  00:0000:00000:00002:2018/11/29 15:59:40.20 server  Database 'master': beginning upgrade step [ID  1720]: noting the present database upgrade level
  00:0000:00000:00002:2018/11/29 15:59:40.20 server  Database 'master': beginning upgrade step [ID  1800]: noting the present database upgrade level
  00:0000:00000:00002:2018/11/29 15:59:40.20 server  Upgrade has finished in database 'master'. ASE is now updating table level statistics for its system tables. Please be patient.

SAP Adaptive Server Enterprise (ASE) - All versions

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To