Skip to Content

How many messsages can we insert using JDBC receiver adapter in to DB

Hi Friends,

We are having 30 JDBC receiver interfaces in my current implementation project; load of JDBC receiver interfaces was 50 k messages per day and Performing only INSERT operation on data base.

We have created individual communication channel for every JDBC receiver interface and max concurrency value set in CC was 5.

Now we are testing all interfaces in quality with all possible cases, but we found that JDBC receiver adapter unable to process 50 k messages per day, we are on PI 7.1 EHP1 SP7.

Please share your experiences with JDBC adapter receiver like per day how many messages we can transfer.

Thanks a Ton,

Raj

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2011 at 09:17 AM

    Hi Raj,

    Please increase consumer threads for JDBC.

    Also set parameter "queueParallelism.maxReceivers". as you have increased concurrency to 5.

    You can refer SAP NOTE "SAP Note 1136790 - Blocking receiver channel may affect the whole adapter type".

    When you say you are inserting 50K records, does that mean you have 50K Messages in SAP PI?

    If single message is having multiple records, then have you tried BATCH Mode & SQL DML ??

    Regards,

    Gouri

    Add comment
    10|10000 characters needed characters exceeded