ODB doesn't terminate connections with DB when execution is interrupted

[Chirag Bhalgami]

If execution of ODB is interrupted then it does not terminate connections with DB (Trafodion) .
Restarting DCS does not help. It shows odb app is still occupying MXOSRVRs.
Also, re-executing odb throws following error message:
-----------------------------------------------------------------------------
odb [2015-03-31 21:19:11]: starting ODBC connection(s)... (1) 1 2 3 4
Connected to HP Database
[3] 5,000 records inserted [commit]
[2] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[2] 0 records inserted [commit]
[3] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[3] 5,000 records inserted [commit]
[4] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[4] 0 records inserted [commit]
[1] odb [Oloadbuff(9477)] - Error (State: 25000, Native -8606)
[Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2015-03-31 21:39:47]
[1] 0 records inserted [commit]
odb [sigcatch(4125)] - Received SIGINT. Exiting
-----------------------------------------------------------------------------

ODB version: odb64luo
Trafodion Build: Release [1.0.0-304-ga977ee7_Bld14], branch a977ee7-master, date 20150329_083001)
Hadoop Distro: HDP 2.2
HBase Version: 0.98.4.2.2.0.0

[Aruna Sadashiva (aruna-sadashiva)]

This is a DCS issue, happens with trafci and any tool/program using odbc/jdbc drivers.

[Aruna Sadashiva (aruna-sadashiva)]

Also, Chirag, before restarting dcs you should kill any leftover mxosrvrs if dcsstop did not stop all mxosrvrs.

[Chirag Bhalgami (chirag-bhalgami)]

providing loadcmd=ul resolve the issue... ul=upsert load

e.g.
./odb64luo -l src=nofile:tgt=<table_name>:max=1000:loadcmd=ul:map=<file.map>:rows=500:parallel=4 -u <userid> -p <password> -d TDM_Default_DataSource