Enabling Data Compression

To compress data, you must obtain a current ASE_COMPRESSION license, then set the system-wide configuration parameter enable compression.

  1. Obtain an ASE_COMPRESSION license from the SPDC download site (see the SySAM Users Guide or your Sybase® representative).
  2. Enable data compression using:
    sp_configure 'enable compression', 1

See System Administration Guide: Volume 1 > Setting Configuration Parameters.

Parent topic: Data Compression Overview