Job aborted when using hash file

somu_june · Post by **somu_june** » Mon Feb 27, 2006 9:35 pm

Hi,

Iam facing a error when Iam using a hash file. I used hash file as look up and Iam writing 9023435 from db2 table to hash file but Iam getting a job abort message after writing 8367235 records.Iam using type (30) with default values is there anything I have to change in options then default values .. .... error saying

Error :

Insert_In2_Product_And_SW_Tables..Prod_Ctry_Hash.IDENT3: [IBM][CLI Driver] SQL0902C A system error (reason code = "18") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005

[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: "9.149.91.27". Communication function detecting the error: "recv". Protocol specific error code(s): "78", "*", "*". SQLSTATE=08001

SQLFetch: Error retrieving results from server.

chulett · Post by **chulett** » Mon Feb 27, 2006 9:45 pm

You've already posted this twice - why post it yet again with a different Subject?

Sheesh...

I_Server_Whale · Post by **I_Server_Whale** » Mon Feb 27, 2006 10:02 pm

Hi,

This is NOT professional at all.

Thanks,
Naveen.