Pre-installing the IBM InfoSphere Information Analyzer analysis database in a Microsoft SQL Server database system

You can use an existing installation of a Microsoft SQL Server database to create an InfoSphere® Information Analyzer analysis database for InfoSphere Information Server.

Before you begin

If the SQL statement does not run, then you must add the path to the sqlcmd.exe application to your Path system variable. This application is typically located in one of the Microsoft SQL Server Tools\Binn directories. For example,

C:\Program Files\Microsoft SQL Server\110\Tools\Binn

About this task

Complete this procedure to create the InfoSphere Information Analyzer analysis database. Create the database before you run the InfoSphere Information Server installation program.

Procedure

Open a command prompt and change to the following directory. (The ⇒ character indicates a line continuation.):
```
payload_install_dir\is-suite\DatabaseSupport\Windows\⇒
InformationAnalyzer\SQLServer2012
```
payload_install_dir is the directory where you extracted the InfoSphere Information Server installation media (is-suite.zip).
Run the following command to create the InfoSphere Information Analyzer analysis database:
```
create_ia_db.cmd ServerName DbName UserName Password
```
For example:
```
create_ia_db.cmd localhost iadb iauser myPassw0rdIA
```
The create_ia_db.sql script creates data and saves log files in the default SQL Server installation location, C:\Program Files\Microsoft SQL Server. This directory might not provide optimal throughput and performance. To create the data and log files in a different directory, modify the create_ia_db.sql script to specify a different location.

ServerName

The name of the server where you are creating the database.

DbName

The name of the database that you are creating.

UserName

The database user name that you are using to create the database.

Password

The password for the database user.

Important: Do not assign the sysadmin SQL Server role to the user name that you specified for UserName. Assigning this role to the database user name will cause the InfoSphere Information Server installation program to fail.