| ODBC driver (SybaseIQ) |
- Configure via the ODBC driver manager, or add it to a path where it can be found by esp_iqloader.
- Create an odbc.ini file containing the connection information for
the target database.
|
| User account (esp_iqloader) |
- Ensure the user account using esp_iqloader has full permissions on the working directory and the log directory, including the ability to create these directories (if they do not exist).
|
| Working directory (esp_iqloader) |
- Ensure that the working directory for esp_iqloader is accessible to Sybase IQ. If Sybase IQ is running on a different
server than the one on which you are running esp_iqloader, share this directory (for example,
over SAN or NAS) between the two servers.
This is required for the LOAD TABLE statement to
work properly.
|
| Archiving data (esp_iqloader) |
- Ensure the working directory has sufficient disk space to handle surges in volume. When archiving data, the archive executable may not keep up with the Event Stream Processor, especially when applying SQL DML to archive data. In this case a large number
of intermediate files may be written out to disk.
|
| Tables (SybaseIQ) |
- Predefine the target tables in the destination database and ensure they exist in the same order with the appropriate datatypes.
- Add an additional datetime column to the destination table if the archive
executable is instructed to populate this column. This column should appear only as the first or the last column.
|