Troubleshooting
Problem
Information Server DataStage job aborts with error "Abnormal termination of stage detected"
Cause
The DataStage environment has both the environment variables ODBCINST and ODBCINI set to a different directory path
Diagnosing The Problem
In DataStage Director open the log for the failed job. Double click the log entry that states "Environment variable settings" to view the complete list of variables used by the job and search for the variable ODBCINST. Verify that the variable ODBCINST is defined and that its value is set to a path that is different from the path of the variable ODBCINI
Resolving The Problem
ODBCINST is an environment variable that defines the directory where the odbc.ini file exists when unixODBC drivers are installed.
Information Server DataStage uses the DataDirect ODBC drivers shipped with DataStage and uses the ODBCINI environment variable to define the path of the .odbc.ini file which contains the ODBC data source name (DSN) definitions. The environment variable ODBCINI is set in the dsenv file automatically as part of the Information Server installation and defaults to the .odbc.ini file under the $DSHOME directory.
If the DataStage engine server has additional ODBC drivers such as unixODBC drivers installed, then the variable ODBCINST could be defined and set to a different path such as /usr/local/etc. When both the ODBCINST and ODBCINI environment variables are defined it creates conflict during job execution so you need to unset the variable ODBCINST.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21633028