Professional Web Applications Themes

Reply to Thread

Post a reply to the thread: Question The DB2 Load API call failed with SQLCODE -30,081.

Your Message

Click here to log in

 

Send Trackbacks to (Separate multiple URLs with spaces)

Already pinged:
  • http://www.dsxchange.com/viewtopic.php?t=140612&hi...

You may choose an icon for your message from this list

Topic Review (Newest First)

  • August 20th, 03:23 PM
    Samarth

    The DB2 Load API call failed with SQLCODE -30,081.

    Hi ,

    My datastage bulk jobs are failing with the below error message.

    dbeW_Fact_Stock_Movement_Tgt,1: The DB2 Load API call failed with SQLCODE -30,081.
    Load messages are stored in message file:???.

    dbeW_Fact_Stock_Movement_Tgt,1: An error occurred while loading the table. (CC_DB2APILoadRecordDataSetConsumer::complete, file CC_DB2APILoadRecordDataSetConsumer.cpp, line 1,832)

    After some lines of log I could see this error message as well.

    dbeR_DimFaultPosition: SQLEndTran(SQL_COMMIT) reported: SQLSTATE = 08007: Native Error Code = -30,081: Msg = [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: "10.144.130.1". Communication function detecting the error: "send". Protocol specific error code(s): "32", "*", "0". SQLSTATE=08001 (CC_DB2Connection::commit, file CC_DB2Connection.cpp, line 1,520)

    Tried below steps
    1. Datastage server and DB server are up and fine. No issues with CPU, paging or disk space.
    2.Tried connecting the DB through Datastage unix server and able to connect.
    3. Able to connect DB from Database server also.
    4. There is no table lock but still these bulk load jobs are failing.
    5. Tried running job will less volume of data but no luck.
    6. I have gone through some of the posts in google and as per one of the post need to disable the env variable CC_MSG_LEVEL but I dont have any env variable in my job.

    Can anybody help me on this. This is very urgent.

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139