From time to time as a Business Process Manager (BPM) system administrator you need to purge information from the system. This primarily includes instance, task and snapshot data. This topic is covered in the administering the BPM databases and Chapter 4 of the IBM Redbooks publication "IBM Business Process Manager Operations Guide." We in Support created a simple JSP to deliver quick summaries to the system administrator in the process admin console. This file placed on the server file system will generate a simple report showing the various counts of tables and groupings of items. The JSP page is easily configured for other tables and threshold counts that you may need in your organization. The initial indicators for this are based on historical problem records (PMRs) and where clients often experience problems with certain row counts or percentages. This JSP is free to use and extend as needed. You can also submit feedback for us to include in later releases.
THE DOWNLOAD(S) ARE PROVIDED "AS IS," WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT OF PATENTS, COPYRIGHTS OR OTHER PROPRIETARY RIGHTS OF OTHERS. NEITHER THE AUTHOR NOR IBM WARRANT THAT THE FUNCTIONS, ROUTINES, AND DATA CONTAINED IN, OR GENERATED AS A RESULT OF THE DOWNLOAD(S), WILL MEET YOUR REQUIREMENTS OR BE ERROR-FREE. The entire risk related to the quality and performance of the download(s) and sample(s) is with you. In the event that there is any defect, you assume the entire cost of all necessary services, repair or correction. IN NO EVENT WILL THE AUTHOR OR IBM BE LIABLE TO YOU OR TO ANY THIRD PARTY FOR ANY DIRECT OR INDIRECT DAMAGES (INCLUDING, WITHOUT LIMITATION, LOST PROFITS, LOST SAVINGS OR OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES) ARISING OUT OF THE USE OR INABILITY TO USE THE DOWNLOAD(S), EVEN IF THE AUTHOR OR IBM HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Some jurisdictions do not allow the exclusion of implied warranties or the limitation or exclusion of liability for incidental or consequential damages, so some of the above may not apply to you."