SQL30081N
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 63
- Joined: Mon Sep 12, 2011 2:11 am
SQL30081N
Hi All
does any one know how to solve this bug on datastage.
DB2_Connector_0: 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.10.50.58".
Communication function detecting the error: "send". Protocol specific error code(s): "10054", "*", "0".
SQLSTATE=08001 (CC_DB2Connection::commit, file CC_DB2Connection.cpp, line 1,491)
Thanks
does any one know how to solve this bug on datastage.
DB2_Connector_0: 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.10.50.58".
Communication function detecting the error: "send". Protocol specific error code(s): "10054", "*", "0".
SQLSTATE=08001 (CC_DB2Connection::commit, file CC_DB2Connection.cpp, line 1,491)
Thanks
I think that a bit more information is required.
- Does it always occur
- Does it only occur for one table or for all tables?
- Has this ever worked before and now no longer works?
- Since "commit" is mentioned, what are your commit settings in the stage?
- Can you read from this table?
- Does it always occur
- Does it only occur for one table or for all tables?
- Has this ever worked before and now no longer works?
- Since "commit" is mentioned, what are your commit settings in the stage?
- Can you read from this table?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 63
- Joined: Mon Sep 12, 2011 2:11 am
- Is this a sporadic error or does it always occur? If it always occurs, does it always occur on the same record / after the same amount of data?
- What has changed between the time it worked and now? Both in the job, the table, the database and the system
- Are you writing large amounts of data? If you specify a commit interval (e.g. 10,000 rows) does the error no occur?
- What has changed between the time it worked and now? Both in the job, the table, the database and the system
- Are you writing large amounts of data? If you specify a commit interval (e.g. 10,000 rows) does the error no occur?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 63
- Joined: Mon Sep 12, 2011 2:11 am
It occurs everytime on the same job and same record count (which is equal to the total record count within the job , 11+ million rows of records.)
No changes on the job, but there is some database configuration changes on the logging part.
Where i can set the commit interval ? Is it the array size in DB2 connector stage ?
Thanks
No changes on the job, but there is some database configuration changes on the logging part.
Where i can set the commit interval ? Is it the array size in DB2 connector stage ?
Thanks
The commit frequency is set under "Transaction -> Record Count" in the connector stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 63
- Joined: Mon Sep 12, 2011 2:11 am