I was running an IBM product called IIB on SUSE Linux. We are migrating all our SUSE over to Oracle Linux. With the IIB application we added the same information within /etc/profile as we had on SUSE Linux but after reboots the database connection isn't happening like it should.
We placed this in the /etc/profile:
unset i
unset -f pathmunge
. /opt/mqm/bin/setmqenv
. /opt/IBM/iib-10.0.0.10/server/bin/mqsiprofile
ODBCINI=/var/mqsi/odbc/odbc.ini
ODBCSYSINI=/var/mqsi/odbc
export ODBCINI
export ODBCSYSINI
I am not sure if there is a better place to add these values for startup in Oracle Linux. Here are the logs I am seeing in the logs -
. Requests that need database access are timing out. I see the environment variables when I run printenv
Oct 12 08:27:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 4/6) BIP2348E: Error detected while attempting to obtain a connection to data source 'eodss' of type 'ODBC' using userid 'iibsvc_d'.
Oct 12 08:27:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 5/6) BIP2393E: Database error: ODBC return code '-1' from data source 'EODSS' using ODBC driver manager ''.
Oct 12 08:27:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 6/6) BIP2347E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'
Oct 12 08:28:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 1/6) BIP2628W: Exception condition detected on input node 'ApplicationServicesPing_flow.SOAP Input'.
Oct 12 08:28:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 2/6) BIP2230E: Error detected whilst processing a message in node 'ApplicationServicesPing_flow.ApplicationServicesPing.Extract'.
Oct 12 08:28:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 3/6) BIP2230E: Error detected whilst processing a message in node 'ApplicationServicesPing_flow.Compute'.
Oct 12 08:28:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 4/6) BIP2348E: Error detected while attempting to obtain a connection to data source 'eodss' of type 'ODBC' using userid 'iibsvc_d'.
Oct 12 08:28:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 5/6) BIP2393E: Database error: ODBC return code '-1' from data source 'EODSS' using ODBC driver manager ''.
Oct 12 08:28:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 6/6) BIP2347E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'
Oct 12 08:28:34 eisiibl1d IIB[1834]: IBM Integration Bus v100010 (INL11D.CRC_IS) [Thread 2089] (Msg 1/5) BIP2232E: Error detected whilst handling a previous error in node 'PolicyDetail.Common_ErrorHandler.FormatExceptionMessage'.
Oct 12 08:28:34 eisiibl1d IIB[1834]: IBM Integration Bus v100010 (INL11D.CRC_IS) [Thread 2089] (Msg 2/5) BIP2230E: Error detected whilst processing a message in node 'PolicyDetail.Process Config'.
Oct 12 08:28:34 eisiibl1d IIB[1834]: IBM Integration Bus v100010 (INL11D.CRC_IS) [Thread 2089] (Msg 3/5) BIP2348E: Error detected while attempting to obtain a connection to data source 'eodss' of type 'ODBC' using userid 'iibsvc_d'.
Oct 12 08:28:34 eisiibl1d IIB[1834]: IBM Integration Bus v100010 (INL11D.CRC_IS) [Thread 2089] (Msg 4/5) BIP2393E: Database error: ODBC return code '-1' from data source 'EODSS' using ODBC driver manager ''.
Oct 12 08:28:34 eisiibl1d IIB[1834]: IBM Integration Bus v100010 (INL11D.CRC_IS) [Thread 2089] (Msg 5/5) BIP2347E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'
Oct 12 08:29:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 1/6) BIP2628W: Exception condition detected on input node 'ApplicationServicesPing_flow.SOAP Input'.
Oct 12 08:29:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 2/6) BIP2230E: Error detected whilst processing a message in node 'ApplicationServicesPing_flow.ApplicationServicesPing.Extract'.
Oct 12 08:29:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 3/6) BIP2230E: Error detected whilst processing a message in node 'ApplicationServicesPing_flow.Compute'.
Oct 12 08:29:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 4/6) BIP2348E: Error detected while attempting to obtain a connection to data source 'eodss' of type 'ODBC' using userid 'iibsvc_d'.
Oct 12 08:29:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 5/6) BIP2393E: Database error: ODBC return code '-1' from data source 'EODSS' using ODBC driver manager ''.
Oct 12 08:29:23 eisiibl1d IIB[1833]: IBM Integration Bus v100010 (INL11D.EIS_IS) [Thread 2162] (Msg 6/6) BIP2347E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correctly set.'