|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Today @ 12:57:26 PM
Posts: 328,
Visits: 506
|
|
Is the FastLoad running directly on one of the database (TPA) nodes or on a separate application server? Client CPU usage appears not to be an issue (1.44 seconds). Have you looked at disk I/O and network throughput on the box running FastLoad? And network througput on the Teradata node(s)?
Mismatched ethernet speed or duplex settings between an adapter and a network switch can result in a connection that appears to work for trivial requests but is extremely slow when handling large data volume.
As an aside, note that FastLoad 7.5.0 dates from 2002 (TTU6.2). I don't think really that's causing your problem, but you might want to consider upgrading.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 3/13/2007 6:22:00 AM
Posts: 12,
Visits: 1
|
|
Thanks Fred.
FastLoad is running on a separate application server and not on the TPA node.
The application server is in a different network and the TPA node in another. Both the networks are configured for 100Mbps transfer speeds.
It can well be a network issue, which i am investigating. Meanwhile, any suggestions and views are welcome.
Thanks,
Kir Bojo..
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 3/13/2007 6:22:00 AM
Posts: 12,
Visits: 1
|
|
Hi All,
Thanks for your help.
The issue is resolved. The cause of the delay was due to network and switches.
Thanks,
Kir Bojo..
|
|
|
|