DSXchange

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.

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

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.