Improving access performance and defragmenting DB2® database data
Use the scripts that are provided with HCL Connections to improve access performance and to reclaim fragmented space in an application database.
Before you begin
This task is relevant for DB2® databases only. Oracle and SQL Server compact data automatically.
About this task
Procedure
- Copy the reorg.sql script to the root
directory of the application database for which you want to improve
performance. The scripts are stored in the following directory:
- AIX® or Linux™:/Lotus_Connections_Install/connections.sql/ application_subdirectory/db2
- Microsoft™ Windows™:\Lotus_Connections_Install\connections.sql\ application_subdirectory\db2
where application_subdirectory is the directory of the application for which you are improving database access performance. Choose one of the following subdirectories:- activities
- blogs
- communities
- dogear
- files
- forum
- homepage
- metrics
- mobile
- news
- oauth provider
- profiles
- search
- wikis
Note: To improve access performance of the Communities forum database, copy the reorg_forum.sql file from the communities subdirectory. - From the WebSphere® Application
Server Integrated Solutions Console, stop the servers that host the
application that you want to administer:
- Log in to the WebSphere® Application Server Integrated Solutions Console as an administrator.
- Expand WebSphere application servers. and then select
- Select the servers that host the applications for which you want to improve access performance.
- Click Stop.
- Log in to the database server by 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
for every application:
db2 -td@ -vf reorg.sql
- Restart the application servers.