Improving access performance and defragmenting DB2 database dataAdded by IBM on February 11, 2013 | Version 1 (Original)
|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.
Before you begin
The script that you run to improve access performance and reclaim the fragmented space of the database takes the database offline. To prepare the database to be taken offline, you must stop the WebSphere
® Application Server instances for each application that you plan to run the script on.
About this task
You do not need to run this script on the database frequently. It is recommended that you schedule this tasks during another maintenance task that requires you to take the application offline.
- Copy the database compacting script named reorg.sql to the root directory of the application database for which you want to improve access performance. The scripts are stored in the following subdirectory of the IBM Connections installation files:
- AIX® or Linux®:
- Microsoft® Windows®:
From the WebSphere Application Server Integrated Solutions Console, stop the servers hosting the applications hosting the databases. To do so, complete the following steps:
is the script file storage directory of the application for which you are improving database access performance. Choose one of the following subdirectories:
To improve access performance of the Communities discussion forum database, copy the reorg_forum.sql file from the communities subdirectory.
Log into the database server using an ID that has administrative privileges.
Open a command prompt, and change to the directory to which you copied the script.
Use the following command to run the application scripts:
- Log in to the WebSphere Application Server Integrated Solutions Console as an administrator.
- Expand Servers -> Server Types, and then select WebSphere application servers.
- Select the check boxes next to the servers hosting the applications with the databases in which you want to improve access performance, and then click Stop.
Restart the application servers by repeating Step 2, but selecting Start instead of Stop.
- For Activities, Blogs, Communities, Forums, Files, Metrics, and Wikis:
- For Bookmarks, Home page, and Profiles:
Parent topic: Maintaining application databases