Configuring Data Ship for Sybase IQ Targets with Location
JDBC can be used to transfer tables, but significantly better performance can be had with use of location. The following steps are optional, but recommended, when moving data between two Sybase IQ data sources.
To configure Sybase IQ to ship tables using location
1. Create a Sybase IQ server:
CREATE SERVER "<server-name_database_name>" CLASS ‘ASAJDBC’ USING ‘<host_name>:2638’;
2. On the Sybase IQ instance create a user sign-in to allow remote connections:
CREATE EXTERNLOGIN <user_name> TO "<host_name>_<database_name>" REMOTE LOGIN <user_name> IDENTIFIED BY <password>;
3. Configure the added server info in the interfaces file for the Sybase IQ server.
4. Repeat the configuration for each Sybase IQ server, pointing the SQL location at each of the other Sybase IQ instances.