Couples days ago, I used PI JDBC Sender Adapter to retrieve data from A database system. When PI fetch about 900,000 rows records at one time, J2ee Stack got OOM(out of memory) error, restarted over and over again. After applied SP 20, PI could throw an exception, and the communication channel stop. Administrator had to something to make the records into smaller amount. This is final solution.(Note 1253826 - Configuring Maximum Message Size Limits) But this can not be the final solution to our customer. Best performance message size should be in the range of 1MB to 5MB.(PI Best Practices: Sizing & Performance Tuning {code:html}http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/2016a0b1-1780-2b10-97bd-be3ac62214c7{code}) set sapflag = '1' where sapflag = '0' and ROWNUM <10001*
For SQL Server, You could try this:
*UPDATE where sapflag ='0')*
In my case, It's Informix.'select first n' can not used in SQL clause.I may be able T*o update* the flag in JDBC Sender Adapter with a procedure or SQL program. But it's not easy to find an Informix expert. Here lots of warmhearted friends gave me lots helpful suggestions. That's very nice. I will try harder to aoid using a complex BPM. What I have done is to design BPM: 
1, ERP system trigger the process; 2, send SQL 'select count(*)' to DB; 3, if count<>0, retrieve first 10000 rows; 4,send SQL to update flag identified by primay key; 5,send XI message to ABAP proxy which write data into SAP; 6,loop step 2; 7, if count=0, sned 'end' message, end of the process. There is a simple test, total 7318 rows, retrieve 1000 rows each time. What happened in SXMB_MONI after trigger once? 
6 Comments
