I am using DataStage to read from Azure SQL Server and Writing into Azure Sql Server. During the process of reading and writing using ODBC connector Job is performing the CDC .
For the High Data volume jobs, if the job runs for more than 30 minutes, I get this error message
Along those lines, it could be a keep alive or connection timeout setting in a firewall. We ran into that before with a different type of database connection.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Was thinking the same thing, especially if you meant "if the job runs for more than 30 minutes before it starts returning data". Now, if data is actively flowing through the job for those 30 minutes then something else is going on.
-craig
"You can never have too many knives" -- Logan Nine Fingers
We have added keepAlive variable in odbc.ini file but still getting the problem and involved the network team, they are not saying any connection break during the process.
In my situation I did not have to change any settings on Information Server. I had to request the firewall team to change the "extended session timeout" firewall settings. But like Craig said, that usually depends on idleness, so if your job was actively transferring data, then maybe a different setting is needed or it has a different cause. Any chance the database server has a hard limit on connection time?
Choose a job you love, and you will never have to work a day in your life. - Confucius