BusinessConnect Database consuming high disk space.

BusinessConnect Database consuming high disk space.

book

Article ID: KB0073021

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect 6.X.X, 7.X.X
Not Applicable -

Description

Resolution:
Customers using BusinessConnect (BC) have reported JDBC errors or database performance issues.  These issues usually arise because of the BC database tablespaces becoming large.  Also, large amounts of audit data can cause a database to generate extents which can also slow BC performance. For these reasons, it is important that BusinessConnect users regularly archive their BC database tables.

 
The BusinessConnect 6.X.X and 7.X.X documentation provides an appendix that describes the structure of the BC database tables, as well as sample queries to help your database administrator develop an archiving plan for archiving and purging records from these tables. Check the TIBCO BusinessConnect Interior Server™ Administration Guide Appendix A "Database Schema Definition" for details.  You will need to work with your Database Administrator to implement some of the archiving/purging queries to reduce or optimize your database performance.
 

Issue/Introduction

BusinessConnect Database consuming high disk space.

Additional Information

 BusinessConnect Interior Server™ Administration Guide