3291701 - Dump was not perfomed on a quiesced database, the load does not recognize this issue early in LOAD DATABASE process - SAP ASE

• The ASE is a 1 Terabyte database:
  • The conversion of the user tables takes between 3 and 4 hours to get the error:
    Msg 3151, Level 16, State 2:
    Server '<servername>', Line 1:
    Adaptive Server cannot load this database because the database that was dumped
    was not quiescent when the dump was performed. Run sp_flushstats before DUMP
    DATABASE and ensure that the database is not updated during the dump. 
    
  • It is frustrating to find out after this that the transaction log prevents a cross platform dump load.
• Currently LOAD DATABASE executes tasks in this order:
  1. Load pages from file.
  2. Convert byte order of system tables, user table and transactions.
  3. Check the transaction log for invalid entries that cause a failure.
• It could be very helpful to work in a different order if possible:
  1. Load the pages from file.
  2. Convert byte order of transaction log.
  3. Check the transaction log for invalid entries that cause a failure.
  4. Convert byte order of system tables and user tables.

SAP Adaptive Server Enterprise (ASE) 16.0

cross, platform, OS, dump, load, cross-platform, dump/load, different , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement