Sybase recommends that you perform these tasks after you install and test Sybase IQ.
To verify your license, start the server, and run the sp_iqlmconfig stored procedure in Interactive SQL (dbisql). To verify the license from a custom license installation, check the $SYBASE/SYSAM-2_0/log/SYBASE.log file. You can use iqdemo.db to perform this task.
A line that begins with “Checked out license...” indicates a successful license configuration. If you see a “Sysam: FLEXnet Licensing error:” message, check with your Sybase representative to resolve the issue.
For additional information about license issues, see the Troubleshooting SySAM section and the SySAM 2 Users Guide.
Sybase recommends that you change the default connection parameters:
Parameter | Default Value |
---|---|
User ID | DBA (case insensitive) |
Password | sql (case sensitive) |
Port Number | 2638 |
To upgrade a database from an earlier edition of Sybase IQ, see the "Database Upgrades" section. Depending upon your current version of the IQ database the method of upgrading will differ. There are separate upgrade procedures for simplex and multiplex databases