Hi all,
There are two cases where the Datastage Job takes an extremely long time to complete.
Case (i) Extract from a Sequential File and Load to a DB2 Table.
Case (ii) Exract from Multiple DB2 Tables and Load to a DB2 Table
The issue in Case (i) is that the loading time is very long.... jobs that usually took just a few minutes to complete take more than an hour for the same number of records.
In Case (ii) The jobs abort with the following error :
[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "IP.XXX.XXX.XX". Communication function detecting the error: "recv". Protocol specific error code(s): "73", "*", "0". SQLSTATE=08001
I have already checked with the DBA and was told that he has no found performance issue. What possible causes could result in long delays ?
Would appreciate your advice....
Thanks in advance.
Extremely long time loading and extracting records
Moderators: chulett, rschirm, roy
These typically are not DataStage "issues" per se but rather issues on the database side, in spite of what your DBA said. For example, Case (i) - define "load". Plus - how is the table structured? How many indexes does it have? Etc, etc.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers