Home

 

Uninstalling: Manually drop databases

After you have uninstalled a Lotus Connections feature, you can drop related databases by using the database wizard or by following this manual procedure.

If you prefer not to use the database wizard, use this procedure to manually drop DB2®, Oracle, or Microsoft SQL Server databases.

Notes

• All database instances should be running during this procedure

• All open applications should be disconnected from the database.

• If the database server and WebSphere Application Server are on different systems, copy the database creation scripts to the system that hosts the database server.

• The Wizards is located in the Lotus Connections installation media.

Complete the following steps for your database type:

• DB2:

  1. Log in to the database server with an authorized administrator account.

     The default administrator account is db2inst1 on AIX and Linux®, and db2admin on Windows®.

  2. Run the following command for each feature whose database you want to drop:

     db2 -tvf dropDb.sql
     

The SQL script is located in the following directory:

• AIX/Linux: Wizard/connections.sql/<feature_subdirectory>/db2

• Microsoft Windows: Wizards\connections.sql\<feature_subdirectory>\db2

where <feature_subdirectory> is the for a Lotus Connections feature.

Oracle:

1. Log in to the database server with an authorized administrator account.

   The default administrator account is oracle.

2. Set the ORACLE_SID.

3. Run SQL Plus by typing the following command:

   sqlplus /NOLOG
   

4. Type the following command to log in as an administrator with the sysdba role:

   connect as sysdba
   

5. Run the following command for each feature that you want to drop:

   • AIX/Linux:

     @Wizards/connections.sql/<feature_subdirectory>/oracle/dropDb.sql
     

6. Windows:

   @Wizards\connections.sql\<feature_subdirectory>\oracle\dropDb.sql
   

   where <feature_subdirectory> is the for a Lotus Connections feature.

   To drop the Communities forum database, run the following script, located in the communities subdirectory:

   dropDb_forum.sql
   

SQL Server:

1. Launch a command prompt window.

2. Run the following command for each feature that you want to drop:

   sqlcmd -U <admin_user> -P <admin_password> 
   -i Wizards\connections.sql\
   <feature_subdirectory>\sqlserver\ dropDb.sql
   

   where <feature_subdirectory> is the for a Lotus Connections feature.

   If your SQL Server database has multiple instances, add the following line as the first parameter of the command:

   -S <sqlserver_server_name>\<sqlserver_server_instance_name>
   

   where <sqlserver_server_name> is the name of the SQL Server database, and <sqlserver_server_instance_name> is the name of each database instance.

Uninstall Lotus Connections

 

Related tasks

Uninstall a stand-alone deployment

Uninstall a network deployment

Manually uninstalling Lotus Connections

Uninstalling: Remove files

Uninstalling: delete databases with the database wizard

---

+

Search Tips   |   Advanced Search