Kill Idle JDBC connectionr

[former_member184619]

Hi Folks,

We have a Sender JDBC channel which is running every 30 sec to pull Invoices and the job runs overnight, as we have a high volume. The issue that DB team is facing is that once the job is over (my channel is stopped). They can still see the lock from that job.

Is there any way/parameter, we can kill the Idle connection or we can have a hard connection kill once the job is over.

The option to disconnect from database after each pull doesn't fit our requirement.

Regards,

Sachin Dhingra

[iaki_vila · Accepted solution]

Hi Sachin,

I think the data retrieved from the JDBC goes to any SAP ECC or third system, from these systems you can check if there is no more data during X time and to stop the JDBC externally. Check these blogs:

Regards.

[former_member184619 · Accepted solution]

Hi Inaki,

Thank you for the inputs. But, the issue is that after stopping the channel the logs still persist on DB2 database. So, when we stop the channel, does it disconnect the connection. If so, then probabaly DB2 team needs to look into it. If not, how to have an explicit disconnect from DB using PI.

Regards,

Sachin Dhingra

[former_member184619 · Accepted solution]

Folks,

Please suggest, Once we stop the channel the connection on DB should be gone or we do any explicit disconnect.

[justin_santhanam · Accepted solution]

Hi Sachin,

This is off the topic, just to see where the problem is. Can you deploy the EAR file and try to test it?

1085539 - XI JDBC/FTP connection Test and XML Validation Application

Just ask the folks to monitor it when you test out this connection. Whether the DB2 closes the connection after you test it or It's still has the session opened. This way we can isolate the problem. Did u check are there are other Drivers that also has the same issue - db2jcc.jar or db2jcc4.jar?

Just adding my 2 cents.. Not sure if it will help, but give a try..

Thanks!

[former_member186851]

Hello Sachin,

Why don't you configure ATP(availability time planning) and run the channel for a particular time.

[former_member184619]

Raghuraman Sritharan wrote:

Hello Sachin,

Why don't you configure ATP(availability time planning) and run the channel for a particular time.

ATP is in place already.