Uninstalling: Manually drop databases

After uninstalling a Connections application, we can drop any related databases using the database wizard or by following this manual procedure.

• Ensure all Connections database instances are running.

• Disconnect any open applications from the database.

• If the database server and IBM WebSphere Application Server are on different systems, copy the database scripts to the system hosting the database server.

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

The Wizards directory is located in the Connections set-up directory or installation media.

Complete the following steps for the 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 for Communities:

     db2 -td@ -vf calendar-dropDb.sql

  3. For Home page and Profiles, run the following command :

     db2 -tvf dropDb.sql

  4. Run for all the other applications:

     db2 -td@ -vf dropDb.sql

     The SQL scripts are located in:

     • AIX or Linux: Wizard/connections.sql/application/db2

       • For Linux on IBM System z with the DASD driver, the SQL scripts are located in the INSTALL_s390/Connections/connections.s390.sql directory.

       • For 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.

     • Windows: Wizards\connections.sql\application\db2

     where application is the directory for a Connections application.

• 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 for Communities:

     • AIX or Linux:@Wizards/connections.sql/communities/oracle/calendar-dropDb.sql

     • Windows:@Wizards\connections.sql\communities\oracle\calendar-dropDb.sql

  6. Run for the other applications:

     • AIX or Linux:@Wizards/connections.sql/application/oracle/dropDb.sql

     • Windows:@Wizards\connections.sql\application\oracle\dropDb.sql

     where application is the directory for a Connections application.

• SQL Server:

  1. Open a command prompt.

  2. Run for Communities:

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

     • If the 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.

  3. Run for the other applications:

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

     where application is the directory for a Connections application.

Parent topic:
Uninstall Connections