Uninstalling: Manually drop databases
After you have uninstalled an IBM Connections application, you can drop any related databases by using the database wizard or by following this manual procedure.
Before starting
- All database instances should be running during this procedure.
- All open applications should be disconnected from the database.
- If the database server and IBM WAS are on different systems, copy the database creation scripts to the system that hosts the database server.
- The Wizards directory is located in the IBM Connections set-up directory or installation media.
About this task
If you prefer not to use the database wizard, use this procedure to manually drop DB2 , Oracle, or Microsoft™ SQL Server databases.Complete the following steps for your database type:
Procedure
- DB2:
- Log in to the database server with an authorized administrator account.
Note: The default administrator account is db2inst1 on AIX and Linux™, and db2admin on Windows™.
- Run the following command for each application whose database you want to drop:
db2 -tvf dropDb.sql
Note: For Files and Wikis, run the following command instead:
db2 -td@ -vf dropDb.sql
The SQL script is located in the following directory:
- AIX or Linux: Wizard/connections.sql/<application_subdirectory>/db2
Note:
- If you are using Linux on IBM System z with the DASD driver, the SQL scripts are located in the Lotus_Connections_Install_s390/LotusConnections/connections.s390.sql directory.
- If you are using Linux on IBM System z with the SCSI driver, back up the connections.s390.sql directory and rename the connections.sql directory to connections.s390.sql.
- Microsoft Windows: Wizards\connections.sql\<application_subdirectory>\db2
where <application_subdirectory> is the directory for an IBM Connections application.
- Oracle:
- Log in to the database server with an authorized administrator account.
Note: The default administrator account is oracle.
- Set the ORACLE_SID.
- Run SQL Plus by typing the following command:
sqlplus /NOLOG
Type the following command to log in as an administrator with the sysdba role:
connect as sysdba
Run the following command for each application that you want to drop:
- AIX or Linux:
@Wizards/connections.sql/<application_subdirectory>/oracle/dropDb.sql
Windows: @Wizards\connections.sql\<application_subdirectory>\oracle\dropDb.sql
where <application_subdirectory> is the directory for an IBM Connections application.
SQL Server:
- Launch a command prompt window.
- Run the following command for each application that you want to drop:
sqlcmd -U <admin_user> -P <admin_password> -i Wizards\connections.sql\ <application_subdirectory>\sqlserver\ dropDb.sqlwhere <application_subdirectory> is the directory for an IBM Connections application.
Note: 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.
Parent topic
Uninstall IBM Connections
Related tasks
Uninstall a deployment or removing applications
Uninstall in silent mode
Uninstalling: delete databases with the database wizard
Uninstall databases in silent mode
});