Symptom
- 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: 4.172.1.4: 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: 4.41.1.1: 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."
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) all versions
- UNIX environment
Product
Keywords
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.