Home / Educational Content / PeopleSoft / Integration Broker (IB) Web Service Transaction Log Management

Integration Broker (IB) Web Service Transaction Log Management

100830 Integration Broker (IB) Web Service Transaction Log Management

Presented at RECONNECT 19

Integration Broker (IB) keeps information for every web service transaction so we can review later to resolve issues. As the volume of web services increase, the related tables can become very large in volume.

The risk of purging is losing the ability to  review some transactions for back dated production issues. No purging may resulted in high volume of logging data, increased storage cost and cause concern of web services and overall system performance.

We have designed and implemented two-tied archive and purge process. Archive: using PeopleSoft delivered  AE program to archive the IB logs from the transaction tables by age into archive tables. Purge: We had developed a custom AE process to purge the archive tables by age. It clean the older logs off the system.

April Zhang, Northwestern University

Integration Broker (IB) Web Service Transaction Log Management