Resetting the system

The dropDatabases task can remove not only the data, but also the underlying structures such as tables from your database management system. The deleteSolrCollections task can remove any Solr collections from the system.

Before you begin

To drop the databases, you must ensure that there are no active connections to them.

About this task

In a multiple-server environment, run all toolkit tasks from the Liberty server.

In a deployment that provides high availability, use the documentation from your database management system to remove the Information Store database from each database server in your deployment instead of the dropDatabases toolkit task.

In a deployment that provides high availability, stop and start each Liberty server in your environment but run clearSearchIndex on the Liberty server that you used to create the database only.

Important: These instructions are designed to remove databases that are used for test purposes. Do not use the task to remove databases in a production system without backing up your data. For more information about backing up your data, see Backing up a deployment.

Procedure

In a command prompt, navigate to the toolkit\scripts directory.
Stop the deployment:
```
setup -t stopLiberty
```
To remove the database and Solr collections, navigate to the toolkit\scripts directory and run the following command:
```
setup -t dropDatabases --hostname <liberty.host-name>
setup -t deleteSolrCollections --hostname <liberty.host-name>
```
Here, liberty.hostname is the hostname of the Liberty server where you are running the command. It matches the value for the host-name attribute of the <application> element in the topology.xml file.
A message is displayed when you run each task to confirm that you want to complete the action. Enter Y to continue. The database and Solr collections are removed from the system.

To re-create the Solr collections and databases, run the following commands:

setup -t createSolrCollections --hostname <liberty.host-name>
setup -t createDatabases

Start the deployment of i2 Analyze.
```
setup -t startLiberty
```