Maintaining application databasesBackup the application databases and any associated content stores on a regular schedule using the methods documented by the vendor from whom you purchased the database and file system that you are using.
About this taskIBM Connections provides a few SQL scripts to help you perform maintenance tasks on DB2 databases, such as collecting database statistics and compacting the database. You can collect statistics while IBM Connections is running; there is no need to stop the applications nor bring the databases offline. However, stop all applications that access the databases before running the scripts to compact and defragment them.
Backing up and restoring data
You must back up both the application databases and content stores on a regular schedule using the methods documented by the vendor from whom you purchased the database and file system you are using.
Gathering DB2 database statistics daily
Use the provided script to gather statistics about DB2 database table usage. Run the scripts nightly using the DB2 Task Center, for example, to update internal statistics used by DB2. Up-to-date statistics are necessary for proper performance. This procedure is relevant for DB2 databases only. Oracle and SQL Server gather statistics automatically.
Improving access performance and defragmenting DB2 database data
Use the scripts provided with IBM Connections to improve access performance and reclaim fragmented space in the DB2 database data of an application database. This procedure is relevant for DB2 databases only. Oracle and SQL Server compact data automatically.
Parent topicAdminister applications