The syntax is:
optase [memory] [cpus] [pagesize] [ase editon] [application type] [output sql file]
where:
- memory - memory for SAP ASE in MB
- cpus - number of CPUs for ASE
- pagesize - The SAP ASE's page size as 2 / 4 / 8 / 16. This is
the actual configured SAP ASE value and should not be changed.
- ase edition - SAP ASE Edition type as EE / SE / DE / XE. This
is the actual configured SAP ASE value and should not be changed.
- application type - type of usage: MIXED / OLTP / DSS
- output sql file - output file to write SQL script
In this example, SAP ASE "Enterprise Edition" with 4KB page size is configured to
use 2048 MB of memory, 2 CPUs and a mixed workload:
cd $SYBASE/ASE-16_0/bin
./optase.sh 2048 2 4 EE MIXED /tmp/optase.sql
isql -Usa -P -S myserver -i /tmp/optase.sql -o /tmp/optase.out