Resolution:
Customers using BusinessConnect 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 imperative that BusinessConnect users regularly archive their BC database tables.

BusinessConnect 5.X includes an archiving utility that can be used to archive your audit data out of your BC tables and into a separate set of tables for off-line storage.  These tables can be created by creating a new JDBC connection in BC and then running the "Create Audit Tables" hyperlink against the new connection.  The scripts can also be exported and run separately against the database.  The archiving tool is documented in Appendix A "Database Archiving Tool" of the "TIBCO BusinessConnect Trading Partner Administration Guide".

BusinessConnect 3.X also includes separate archiving tools for the EDI (with EDI 2.71 and above) and RosettaNet protocols.  The ediarchive (for EDI transactions) tool is located in $BC_HOME/tools/EDI/archive.  The archive tool for RosettaNet is part of the Administrator utility for RosettaNet, and is documented in Chapter 12 "Maintaining Archives of Audit and Non-Repudiation Log Records" in the "TIBCO BusinessConnect RosettaNet Protocol Guide".