The automated load process may receive an "ERROR
in DBISQL operation" message in the terminal
window and the automated load log (the .err file
in the $IQ_DIR/log directory)
contains an "Unable to start database server" error.
These errors may occur even though the Sybase IQ server is running,
and the IQ_ENGINE, IQ_UID, IQ_PWD, IQ_DB_QUOTE, and
IQ_DB_TRADE environment variables in the $RAP_HOME /set_rap_env_pl.sh file
are all set to the correct values.
These errors indicate there is a connection issue with the IQ server and none of the data files have been loaded to the IQ database.
To resolve this issue, perform these steps:
Stop the automated load process by running the script $RAP_HOME/rap_stop_pl.sh.
Use a text editor to open the file $RAP_HOME/rap_tbl_dbisql_pl.sh and locate this line in the file: PARAMETER="uid="${USER_ID}";pwd="${PWD}";dbn="${DB}"; eng="${ENG}
Change this line to: PARAMETER="uid="${USER_ID}";pwd="${PWD}";dbn="${DB}"; eng="${ENG}";dbf=<Database File Name>;links=tcpip{port= <Port Number>;host=<Host Name>}" where <Database File Name>, <Port Number>, and <Host Name> are the actual database file name, the server port number, and the server host name, respectively.
Save the changes.
Copy the data files from the $RAP_ARCH directory to the $IQ_DIR directory.
Start the automated load process by running the script $RAP_HOME/rap_start_pl.sh.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
