Extremely long time loading and extracting records

[cosec]

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.

[mystuff]

you have to contact network administrator or let your datastage admin know about it.

[chulett]

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.