SAP Knowledge Base Article - Preview

3147930 - How to speed-up migration from one platform to another - SAP ASE


Trying to move from Solaris to Linux and process is taking weeks - would like to find a way to decrease that time frame.

  1. Currently, the process we are using is dump from Solaris
  2. Load to Linux, this is taking hours to just load the database. (2k server 6Tb database)
  3. Running the sp_post_xpload - is taking weeks to complete.  
  4. Tuning has been done to try and increase performance. 
    1.   The  “max utility parallel degree” is calculated at 2 times the number of partitions + 1 producer
      Therefore, if the “max utility parallel degree“ is set to 255 (the max value allowed)  it will be able to consume what it needs to the maximum.
    2. ASE uses sort buffers for sorts used by operations including create index.  
      This equation estimates the amount of procedure cache required (in bytes):  (<Number of sort buffers>) X (<rows per page>) X 100  (currently set to number of sort buffers = 32767

What else can be done to speed up this process?



  • Solaris ASE 16.0 SP03 PL11  
  • Linux ASE 16.0 SP03 PL11
  • Solaris ASE 16.0 SP04 PL02  
  • Linux ASE 16.0 SP04 PL02


SAP Adaptive Server Enterprise 16.0


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

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.