How to increase the thread count for JDBC adapter

[Former Member]

Hi ALL,

Could someone advice me on how to increase the thread count for JDBC Adapter in Visual Admin:

JDBC_http://sap.com/xi/XI/System.Call.maxConsumers 5

JDBC_http://sap.com/xi/XI/System.Recv.maxConsumers 5

JDBC_http://sap.com/xi/XI/System.Rqst.maxConsumers 5

JDBC_http://sap.com/xi/XI/System.Send.maxConsumers 5

I need to increase them to 10.

Regards,

Xier

[Former Member]

All,

Please let us know the impact of the Max thread count changes at JDBC adapter queues and how much we can go for from 5 to <nn> and how this changes will work with Application thread manager Maxthreads in SAP PI environemnt.

Thanks.

[Former Member]

Hi Xier,

We are having similar issue, Please let us know how to change the JDBC Max Thread Count value from 5 to 10 and how did you resolved your issue? Please help us in this regarard we are into production and need to change this asap.

Thanks in advance

Gary

[Former Member]

Self resolved..

[Former Member]

What was the issue?

[Former Member]

hi check the below links:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/806e75a0-0e01-0010-2587-fc518de8...

admin manual:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/fdb09490-0201-0010-e09e-a76...

note:reward points if solution found helpfull.....

regards

chandrakanth.k

[Former Member]

We have increased the number of JDBC adapter threads to 15 and also AFW threads to 10. But now whats happening is SAP is sending around 100 messages to JDBC, at one time only 11 messages are in delivering state instead of 15. Remaining messages go to waiting state instead of 'To Be elivered' state. and after some time all waiting messages fail showing system error.

Could someone please explain why?

Regards,

XIER

[Former Member]

Please refer to http://help.sap.com/saphelp_nw2004s/helpdata/en/a7/c3d341c4cbc317e10000000a155106/content.htm