Altering or Dropping Alternate Replicate Sybase IQ Connections

Alter or drop default or alternate replicate connections to Sybase IQ by using the alter connection and drop connection commands.

The data server and database names that you specify in the commands can be the default or alternate replicate connection names.

You can use configuration parameters available to alter connection when you configure an alternate or default replicate connection.

For example, to set dsi_bulk_threshold to 15 for the IQSRVR.iqdb_conn2 alternate replicate connection, enter:

alter connection to IQSRVR.iqdb_conn2
set dsi_bulk_threshold to '15'
go