Backup 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 task
® 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, you must stop all applications that access the databases before running the scripts to compact and defragment them.
Backing up and restoring dataParent topic: Administering applications
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.