Error when writing records to hash file

[somu_june]

Hi,

Please help me to over come this problem. Iam using Hash file (Type 30) as look up to db2 table and Iam getting this error there are 9096946 records in DB2 tables when Iam writing this records to a hash file after 8367235 records the job is aborting saying this error


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.

Do I need to change any thing in hash file like modulus etc . I kept all as default values.


Thanks,
Somaraju

[kcbland]

This is a duplicate post.

[I_Server_Whale]

Moderator,

Please remove this duplicate post.

Thanks,
Naveen.