Adaptive Server Enterprise version 12.5 provides a feature that allows you to compress databases and transaction logs using Backup Server. This new feature is part of the dump command through its new compress option.
The partial syntax for dump database … compress and dump transaction … compress commands is:
dump database dbname to [compress::[compression_level::]]stripe_device …[stripe on [compress::[compression_level::]]stripe_device] …
dump transaction dbname to [compress::[compression_level::]]stripe_device …[stripe on [compress::[compression_level::]]stripe_device]…
The default level of compression is 1. You can however, use compression_level to specify up to a level-9 compression to accommodate various requirements and specifications.
Adaptive Server also lets you load databases and transaction logs that you dumped using the dump ... compress option, by using the load ... compress option.
The partial syntax for load database .. compress and load transaction .. compress is:
load database dbname from [compress::]stripe_device …[stripe on compress::stripe_device]…
load transaction dbname from [compress::]stripe_device …[stripe on compress::stripe_device]…
