Database Upgrades

Important information about database upgrades.

For detailed information about installing and upgrading Sybase IQ, see the Installation and Configuration Guide.

Drop Global Temporary Tables Before Running iqunload [CR #717855]

Use DROP TABLE statements to drop all global temporary tables before you run the iqunload utility. You can recreate global temporary tables after migration.

iqunload migrates 12.7 FPIDX databases that use the asejebc remote data access class [CR #682589]

Although the asejdbc server class is deprecated, the iqunload tool migrates remote server definitions based on the asejdbc driver from Sybase IQ 12.7 databases to Sybase IQ 15.4. Set the cis_option to use the remote server at runtime.

ALTER DATABASE UPGRADE statement fails with the error "Not allowed while 'DBA' is using the database" [CR #675890]

Database upgrade procedures in the Installation and Configuration Guide instruct you to use several startup flags to start or restart a server. If Sybase Control Center is running, or another process that automatically connects to IQ, you must increase the number of connections using the -gm flag or the upgrade fails.

In an environment where many processes automatically connect to IQ, consider temporarily starting IQ on a different port using the -x flag. This option prevents all existing processes from connecting to IQ since the port will be unknown to them. You can also use this method for any maintenance task that requires IQ connectivity to be limited.

For example, the IQ upgrade procedure follows this sequence for a simplex server:

  1. Shut down the server, then restart with these startup flags:

    -gm 1 -iqro 1

  2. Run ALTER DATABASE UPGRADE.

    IQ returns a Not allowed while 'DBA' is using the database error.

Similarly, the IQ multiplex upgrade procedure follows this sequence:

  1. Shut down the multiplex, then restart the coordinator with these startup flags:

    -iqmpx_sn 1 -gm 1 -iqro 1

  2. Run ALTER DATABASE UPGRADE.

    IQ returns a Not allowed while 'DBA' is using the database error.

  • Workaround 1 – The -gm switch controls the number of connections when you start the server.
    1. Start the server with -gm 2 (which allows two connections), or drop the existing connection which is used by SCC when the server starts.
    2. Verify the number of connections using the sp_iqconnection command.
    3. If necessary, drop any connections used by SCC (or other processes) using the DROP CONNECTION <id_number> command.
  • Workaround 2 – Temporarily start IQ on a different port using the –x switch: The –x switch controls the port that IQ uses when you start the server.
    • On a simplex server, use the –x switch to specify a new port number: start_iq @yourserver.cfg yourdb.db -x 'tcpip{port=<new_port>}'
    • On a multiplex server, use both the –x switch and the iqmpx override switch to specify a new port number: start_iq @yourserver.cfg yourdb.db -iqmpx_ov 1 -x 'tcpip{port=<new_port>}'

Sybase Central Plug-in Compatibility [CR #667451]

Due to security fixes in IQ 15.3, the Sybase IQ 15.4 plug-in for Sybase Central™ and Sybase Central Agents are not compatible with versions of Sybase IQ earlier than 15.2 ESD #3. You can use the 15.4 plug-in only with Sybase IQ servers that are 15.2 ESD #3 or later, including 15.4; you cannot use the 15.4 plug-in to connect to 12.x servers or servers earlier than 15.2 ESD #3. See New Features Summary.

Default Password Value Change

The default password is sql in lowercase.

Parent topic: Installation and Upgrade