JDBC Adapter Performance

[Former Member]

Hi Experts,

We have nearly 60 interfaces will read/write from/on DB and AS400 tables.

We are facing so many problems in production system. Everyday the messages are strucking at Adapter Engine. All messages are in "To be delivered" stage. If we can stop some cc's then it is processing slowly even the Database is using 60% usage.

We tried to create logical views(Instead of Physical views) on DB and AS400 even the performance has not increased.

We have used "prefetch=false" at "connection" on JDBC adapter but no use.

We can use "Disconnect after each message processed", but my client is not agree with this option.

We don't want to increase the connections to DB and AS400.

Is there any parameters needs to be updated at JDBC Adapter?

Help needed...

Regards,

Rams.

[Former Member]

Hi,

The below links may help u.

JDBC ADAPTER

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

Regards

Pullarao

[ravi_raman2]

Ramesh,

Very interesting issue, Would you be able to give some more specifics about the scenario, So as to be able to offer some solutions.

Regards

Ravi Raman

[udo_martens]

Hi Rams,

you could increase the performance of that sceanrio by writing stored procedured which are sending XML directly to PI's http adapter. No Java Adapter Engine would be used anymore. This solution would require some development time.

Regards,

Udo

[ng82si]

Hi Udo,

it is really a interesting approch.

Could you give me an example?

now we have big performance problem.

thanks a looooot!

Regards

Christine

[VijayKonam]

Stick to what ur client is saying. Otherwise u will choke the Database too. You might want tune the adapter polling intervals.. and may want to schedule adapter to poll at a specific period in time rather poling continuously.

VJ