Preparing the data for the tutorials

The data mining tutorials are based on sample files in the sample database DWESAMP. This tutorial provides step-by-step instructions how to create the sample database DWESAMP, enable the data mining functions, and import sample tables and data mining models that are used in the tutorials.

Before you begin

Verify that Intelligent Miner® is installed on the database server.
If you do not have access to the database server, ask your database administrator to prepare the data for the tutorials for you.
Ensure that you have SYSADM authority on the Db2® database server that you are using for this tutorial.
You need SYSADM authority to create and to modify the sample database that you work with. Throughout this tutorial, the user ID db2admin is assumed to have SYSADM authority.

If you are working with a database server on a remote client, use the Db2 Configuration Assistant and the catalogdb command to indicate how the client connects to the remote server.

Procedure

The following instructions refer to the default installation directory of Intelligent Miner on the Microsoft Windows operating system. If you use another operating system or a different installation directory, you need to modify the commands accordingly.

Create the sample database DWESAMP by following these steps on the system where your database resides:
1. Open a Db2 command window.
2. Go to the following directory:
```
c:\program files\IBM\ISWarehouse\samples\data
```
3. Type the following command:
```
setupolapandmining.bat
```
  For more information about the script setupolapandmining.bat, see the file readme.txt in the following directory:
```
c:\program files\IBM\ISWarehouse\samples\data
```
Enable the database DWESAMP for data mining by typing the following command in the Db2 command window:
idmenabledb DWESAMP fenced dbcfg

By enabling the database, the data-mining functions are registered with the database and database-configuration parameters are optimized for mining.

Now you can create a database connection to the database DWESAMP in the Data Source Explorer of the data warehousing in Db2 Design Studio.

Feedback