Configure ODBC to Prevent Timeouts on a SQL/MX Target

Follow this procedure to change the ODBC connection timeout on a NonStop target from the SYSTEM_DEFAULT of ten minutes to NO_TIMEOUT .

1. From OSH, run mxci and set the mode to mxcs .

   /G/DEV01/SUPERDEV 1>mxci
   >>mode mxcs;
   

2. Issue the following command to show current settings.

   info ds *,detail;
   

   The system responds:

3. Change the IdleTimeout and ConnTimeout to NO_TIMEOUT as follows:

   CS>alter ds "TDM_Default_DataSource", IdleTimeout NO_TIMEOUT;
   CS>>alter ds "TDM_Default_DataSource", ConnTimeout NO_TIMEOUT;
   

4. Repeat the prior alters for any ds Oracle GoldenGate might also use.

Example 24-2

Name: \SYSA.$MX.TDM_Default_DataSource
CpuList: ALL
InitPri..........Same as Assoc Server
CurrentState..................STARTED
ConnectedServers....................0
AvailableServers....................4
LastStateChg.............Apr 12 15:36
LastUpdate...............Apr 12 14:56
IdleServer..........................4
IdleTimeout............SYSTEM_DEFAULT
MaxServer.........................100
ConnTimeout............SYSTEM_DEFAULT
InitServer..........................4
StartAutomatic.....................ON
Trace.............................OFF
SQLPrepareStat....................OFF
ConnInfoStat.......................ON
SQLExecuteStat....................OFF
SessionInfoStat....................ON
SQLExecDirectStat.................OFF
SQLStmtStat.......................OFF
SQLFetchStat......................OFF