Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Hyrid setup Win Apps/AIX DB, SQL30081N error after increasing WP

Hi SDN Gurus,

I'm tuning our system to handle heavy loads. But encounter issues during our tuning.

our setup:

2 Apps instance in Win2008 R3(3 of such servers) to DB instance in Unix AIX.

Initial setup was fine and we have no problem setting the WP of each instance(around 40 WP for each instance). but when we try to increase the WP to 50 we encounter some issues.

After we started the SAP instance, Some of our WPs starts to fail and stop running. The logs have the following error message:

[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: "xx.xx.xx.xx<our db server>". Communication function detecting the error: "send". Protocol specific error code(s): "10054", "*", "0". SQLSTATE=08001

R3Trans -d show similar errors. If we turn off one of the instance the error will disappear.

Our user base is very large and SAP have confirmed that our server resources/hardware are able to handle the user load. So memory/CPU wise is not the issue. We need 50 WP to handle high loads. Our network is simple setup with no FW so don't think there's any issue (works with 40 WP anyway)

The funny thing if we turn on the Unix apps instances, only the Windows apps WP will fail while the Unixs WPs remains running so we suspect the bottleneck may not be in the DB server.

Is there a certain limit to the number of DBconnections or sockets connections for Windows? Or is there any limits to connect to windows from Unix AIX?

Any advise or hints will be greatly appreciated! Thank you!

Regards,

Jansen

Edited by: Jansen Low on May 19, 2011 5:35 AM

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question