Connection being Reset exactly after 60 minutes

Hi ,

I have an AIX script which triggers a Java program to get the information from the database (DB2) and produce the report to the end user.

The java program makes use of the application deployed in the WebSphere Server which calls a callable statement repetedly to trigger a stored procedure in the database to fetch data in chunk of 200 from the database(DB2).Now program runs exactly for 1 hour and then we get connection Reset error.We tried this 6 times and everytime same issue.

java.net.SocketException - Connection Reset

The same program works fine in Test environment but gives problem in production

Any clue ?

[658 byte] By [MyThreada] at [2007-11-27 3:35:54]