Home

 

Compacting and defragmenting DB2 database data

Use the scripts provided with Lotus Connections to compact and defragment the DB2 database data in a feature database. This procedure is relevant for DB2 databases only. Oracle and SQL Server compact data automatically.

To compact and defragment data in a DB2 database...

1. Copy the database compacting script named reorg.sql to the root of the feature database that you want to compact. The scripts are stored in the following subdirectory of the Lotus Connections installation files:

   • AIX or Linux

     /Lotus_Connections_Install/connections.sql/
      <feature_subdirectory>/db2
     

2. Microsoft Windows

   \Lotus_Connections_Install\connections.sql\
    <feature_subdirectory>\db2
   

   where <feature_subdirectory> is the script file storage of the feature for which you are compacting the database. Choose one of the following subdirectories:

   • activities

   • blogs

   • communities

   • dogear

   • files

   • homepage

   • profiles

   • wikis

   To compact the Communities discussion forum database, copy the reorg_forum.sql file from the communities subdirectory.

3. Log into the database server using an ID that has administrative privileges.

4. Take the database offline.

5. Open a command prompt, and change to the to which you copied the script.

6. Use one of the following command to run the script:

   db2 -tvf reorg.sql 
   

   To run the script for the Communities discussion forum database...

   db2 -tvf reorg_forum.sql 
   

7. Bring the database back online.

Maintaining feature databases

---

+

Search Tips   |   Advanced Search