SAP Knowledge Base Article - Preview

2653950 - DUMP DATABASE shows different behaviors based on the CAPACITY value specified - SAP ASE


  • When you run DUMP DATABASE, you may observe different behaviors based on the CAPACITY value specified. You want to know the reason. 

  • The following DUMP DATABASE SQL statement returns Syntax error:

    1> dump database model to '/etc/rmt/test' CAPACITY=2500000000, blocksize=2097152, file='test'
    2> go
    Msg 102, Level 15, State 181:
    Server 'ASE', Line 1:
    Incorrect syntax near '2500000000'.

  •  But the following SQL statement can be successful:

    1> dump database model to '/etc/rmt/test' CAPACITY=2000000000, blocksize=2097152, file='test'
    2> go
    Backup Server: The value of 'allocated pages threshold' has been set to 40%.
    Backup Server session id is: 14. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
    Backup Server: Creating new disk file /etc/rmt/test.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • SAP Adaptive Server Enterprise (ASE) all versions
  • UNIX environment


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5


Sybase, ASEServer, SAPASE, dataserver, backupserver , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.