Preparing an SAP Sybase IQ Server

SAP Sybase IQ 16.0 SP03 is a complete installation package. The initial release of SAP Sybase IQ 16.0 is not a prerequisite for this support package.

  1. Download the SAP Sybase IQ 16.0 SP03 archive.
    Option Description
    If you purchased the product directly from Sybase

    Download the support package from the Software Downloads for EBFs and Maintenance site at: http://downloads.sybase.com/swd/base.do?client=support

    For details about SAP Sybase software downloads, see Software Downloads Frequently Asked Questions at: http://downloads.sybase.com/swd/jsp/faq.jsp.

    If you ordered your Sybase product under an SAP contract

    Download the support package from the SAP Software Download Center at: http://service.sap.com/swdc

    For details, see the online help on the SAP Software Download Center Web site.

  2. Back up your current installation, and save copies of any changes you made to default login and post-login scripts. Before you proceed, make sure the backups are readable.
  3. Check with your operating system vendor for information about the latest operating system patches. Use the recommended operating system patch. Do not use a patch that is earlier than the version suggested for your operating system.
  4. In Interactive SQL, run sp_iqcheckoptions on each database, and capture the output.
    sp_iqcheckoptions generates a list of current database values and options. Use these values to restore your database settings after you upgrade.
  5. Validate your license against each database to ensure that your license maintenance support is in (or near) compliance.
    A server without a maintenance contract for more than a year will not run. Validating your licenses ensures that your database functions correctly after you install the SP. See the SySAM documentation for validation procedures.