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.