About this task
If you use IBM DB2
® databases, IBM
Connections provides a few SQL scripts to help you perform maintenance tasks on them, such as collecting statistics and compacting. You can collect statistics while IBM
Connections is running; there is no need to stop the applications nor bring the databases offline. However, you must stop all applications that access the databases before compacting and defragment them.
When you restore data for an application that is also available from the Communities application, you must also restore the data in the Communities application to keep the two in sync. See Recovering from a database failure for more details.
Gathering DB2 database statistics dailyParent topic: System maintenance
Recovering from a database failure
Restoring a Community Blog after a Communities database failure
Backing up Files data
Backing up Wikis data
Backing up IBM Connections
Restoring Activities data
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.