Hi All,
My job design is as follows.
DB2 Connector (fetch from DB2 table) ----> Aggregator ----> DB2 Connector ( to load Mainframe table).
The problem i am facing here is the below error
SQLExecute reported: SQLSTATE = 08506: Native Error Code = -30,108: Msg = [IBM][CLI Driver][DB2] SQL30108N A connection failed but has been re-established.
The reason being, the idle timeout. For eg, here im fetching 2 million records which takes around 2 minutes. And the idle timeout in the traget DB2 connection is 1 minute. Hence when the data propagetes to target the connection is getting lost.
So, i would like to know if we could establish db2 connection in the target after the whole data is fetched from the source ?
Thanks.
PS : Admins, please correct me if my post is not as per the standards set.
Establish DB2 Connection in runtime
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Fri Jan 27, 2006 12:17 am
Establish DB2 Connection in runtime
Regards,
Patel
Patel
A 1 minute idle timeout? Sheesh. No, there's no ability to defer the target connection until the source data is ready in any sense.
Look for some kind of a 'keep alive' parameter in the connector, pretty sure I've seen people here mention the fact that at least some of them have this capability.
Look for some kind of a 'keep alive' parameter in the connector, pretty sure I've seen people here mention the fact that at least some of them have this capability.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Establish DB2 Connection in runtime
The easy solution is:patelamit009 wrote:So, i would like to know if we could establish db2 connection in the target after the whole data is fetched from the source ?
Job 1:
DB2 Connector (fetch from DB2 table) ----> Aggregator ----> Data Set stage.
Job 2:
Data Set stage ----> DB2 Connector ( to load Mainframe table).
Choose a job you love, and you will never have to work a day in your life. - Confucius
The DB2 Connector stage does have a keep alive setting for the conductor node (default=Yes), but I don't think it works in the way you probably think of a keep-alive normally working like on a telnet or VPN session. The setting is there in 8.5 and 8.7. I think on 8.1 it requires a patch to get that setting.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 20
- Joined: Fri Jan 27, 2006 12:17 am