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
Error when writing records to hash file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America