We have had a dramatic slowdown in the last two weeks using publications on XI R3 SP3 to create bursted reports with dynamic recipients to approximately 2300 individuals. The reports are being output to a file system location as PDFs and not stored in the Enterprise repository. There are no Enterprise recipients. To reduce server load, we split the publications into chunks of 500 individuals each.
The dynamic recipient lists have fixed filters with the appropriate ranges and row number parameters are passed to the source Webi Report.
Publications that took about 35-40 minutes previously are taking 2.5-3 hours.
As reported by other forum members, I believe the Report Bursting method (the only one available) One database fetch for all recipients may not working properly. We are seeing recurring database fetches recurring throughout the publication process where we would expect it to happen only once at the beginning.
We are running BOE on RedHat Linux, and our database is IBM UDB DB2 on AIX. The CPU, Memory, and IO on the BO server are running at normal levels during the process.
Can anyone shed some light on what might be happening, or how to speed up the process? Are there any fixpacks that may help? Any thoughts would be greatly appreciated.
We have more jobs that need to run tomorrow, and we would like to get a handle on managing publication performance.
Thanks in advance.
Manager, Broker Dealer Systems
Jackson National Life