What the heck is compress level 0 for a Sybase backup?

Compress level 0 specifies:

  1. do not compress the data
  2. store the data using zlib

Think of it as the same as:

$ gzip -0 dumpfile.dmp

produces:  dumpfile.dump.gz

The file is simply encapsulated within the zlib archive.  Note that the compression mechanism within the backup server (and gzip btw) is zlib.

When you specify ‘compress level 0’ when dumping a database, you still need specify ‘compress’ to load the database.  The backup server isn’t intelligent enough to determine if the data is encapsulated with zlib or not.

Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *