Compression levels in Sybase

The dump command includes two options that allow you to compress databases and transaction logs using Backup Server, thereby reducing your space requirements.

Compression levels are 0-9 and 100,101

Below image refers the backup file size depends on the compression level.

level 9 provides the highest compression ratio but also the heaviest CPU usage.

100 – the SAP ASE server uses FastLZ compression. The compression ratio that uses the least CPU usage; generally used for shorter data.

101 – the SAP ASE server uses FastLZ compression. A value of 101 uses slightly more CPU than a value of 100, but uses a better compression ratio than a value of 100.

 

Let’s use with compression in a single dump file command:

dump database PID to “/sybase/dumps/PID.dmp” with compression = 9

PID = database name

Syntax for striped backup with compression:

            dump database <DB NAME> to

                    "/path/<DB NAME>_comp_1.dmp" stripe on

                    "/path/<DB NAME>_comp_2.dmp" stripe on

                    "/path/<DB NAME>_comp_3.dmp" stripe on

                    "/path/<DB NAME>_comp_4.dmp" with compression = 9

Path: local file system path, where you want to store your backup files.

Example : /sybase/dumps/