Datastage job got stuck when extracting data from SQL SERVER
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
I think we need to know a bit more about what is going on here:
I assume the job is hanging after extracting data from the database using one of the database connect stages. If so, does the sql statement perform well when run from the SQL Server IDE?
What sort of volumes are being returned between dev and stage?
What is the job doing? Has it got many other stages? For example, it might be waiting for a look up link to complete somewhere else in the job.
Is the stage you are referring to a source feed or look up feed?
If the volumes are high, as you say, are look ups done with join stages?
Cheers,
Bob.
I think we need to know a bit more about what is going on here:
I assume the job is hanging after extracting data from the database using one of the database connect stages. If so, does the sql statement perform well when run from the SQL Server IDE?
What sort of volumes are being returned between dev and stage?
What is the job doing? Has it got many other stages? For example, it might be waiting for a look up link to complete somewhere else in the job.
Is the stage you are referring to a source feed or look up feed?
If the volumes are high, as you say, are look ups done with join stages?
Cheers,
Bob.
Bob Oxtoby
There's not much to go on, but check my topic at viewtopic.php?t=151911 in case it might help.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
-
- Participant
- Posts: 62
- Joined: Thu Feb 08, 2007 6:01 am
- Location: Pune
We were getting ASYNCHRONOUS_NETWORK_IO lock SQL server.
After Working with IBM,Microsoft, Network Team we resolved the issue.
This is due to some "Advanced" network setting of Microsoft Windows Server 2008.
This is what we done
1. In the Property list, click TCP/IP Offload, click Disable in the Value list, and then click OK.
2. In the Property list, click Large Send Offload, click Disable in the Value list, and then click OK.
3. Disable other Offload properties for IPV4
Now things are working fine
Thankyou everyone !!
After Working with IBM,Microsoft, Network Team we resolved the issue.
This is due to some "Advanced" network setting of Microsoft Windows Server 2008.
This is what we done
1. In the Property list, click TCP/IP Offload, click Disable in the Value list, and then click OK.
2. In the Property list, click Large Send Offload, click Disable in the Value list, and then click OK.
3. Disable other Offload properties for IPV4
Now things are working fine
Thankyou everyone !!
rAKESH