process still running after insert

[dnat]

I am running a job in 4 node configuration which is inserting few records in a table through ODBC stage. The database connected through ODBC is progress. Here , even after the job completes(after inserting the records), the process is still running in the database. And when the next job runs, it again creates some processes and so on. It takes longer time for the process to complete, but the records are inserted. Is there a way to commit the transaction and close all the connections.

[ray.wurlod]

Talk to your DBA about keep-alive interval and/or inactivity timeout.

DataStage *should* disconnect; perhaps you could run an ODBC trace to see whether the SQLDisconnect() function is called - if it is, the problem is with ODBC, if it is not, the problem is with DataStage.