Proxy-jdbc scenario

[Former Member]

Hi all,

   In proxy-jdbc scenario, i want to know how much of data had been sent on particular date. Plz help me out.

regards

[markangelo_dihiansan · Accepted solution]

Hello,

Not sure what you meant by how much data, but you can use RWB -> Performance Monitoring -> Detailed Data Aggregated with 1week time interval and aggregation interval of 1 day. Make sure you provide all the filters for your interface only.

Hope this helps,

Mark

[Former Member · Accepted solution]

Thank you Mark

[Former Member]

Shaik,

You can check the size of the message in audit log in RWB.

Also you can check the size in SXMB_MONI in Call Adapter-> Main -> Message size payload.

Regards

Ashsih

[anand_shankar10]

Since this is a JDBC receiver so I assume by "How much data" you mean number of records.

You can find out the number of messages sent on any particular day from SXMB_MONI or from Adapter engine monitoring. But for number of records you will have to find out from the payload. Or you can get the volume of records in MB. Basis ca help you in finding this.

Thanks

Anand

[Former Member]

Hi Anand,

  Tq for your reply,

   The scenario is like this

1.Proxy-Jdbc

2.Jdbc-Mail Server.

  What ever data has been updated in database i.e in first scenario,that record should also be maintained in Mail Server,So i want to compare both the data.