Commands for configuration

You can use commands to issue an HTTP API request to configure settings for the InfoSphere® Information Analyzer analysis database or the analysis engine.

The basic syntax of a command to specify these settings is:

IAAdmin -user user_name -password password -url https://host:port option -[suboption]

Examples:

The following command sets default InfoSphere Information Analyzer analysis database parameters of the InfoSphere Information Analyzer project SampleProject:

IAAdmin -user userName -password password -url https://localhost:9443 -setIADBParams 
-iaDBHost iadb_HostSystem -iaDBDataConnection iadb_dataConnection -iaDataSource 
jndi/jdbc -projectName SampleProject

The following command specifies global settings for the host name, user name and password, and port number for the analysis engine. These settings will take effect for all InfoSphere Information Analyzer projects unless these settings are specified at the individual project level. The settings that you specify at the individual project level will override these global settings.

IAAdmin -user userName -password password -url https://localhost:9443 -setDSParams 
-dsHost dataStageHost -dsUser dataStageUserName -dsPassword dataStagePwd 
-dsPort 31548

Basic parameters

Table 1. Basic parameters
Parameter	Description
-user `user_name`	Name of the user (required)
-password `password`	Password to use (required)
-help or -h	Displays list of available IAAdmin parameters
-v	Verbose. If specified, success or failure error codes are displayed on the console or are sent to the specified file. The success code is (200). Error code 400 indicates that the request was bad. Error code 500 indicates that there was a server error. Consult the application server log files for more details.
-url https://`host`:`port`	Host name and port number of the server (required)

-setIADBParams options

Table 2. -setIADBParams options
Option	Description
-iaDBHost `HostSystemName`	Specifies the analysis database host name.
-iaDBDataConnection `DataConnectionName`	Specifies the analysis database connection.
-iaDataSource`JNDINameDefinedForDataSource`	Specifies the JNDI Name defined for the data source.
-projectName`ProjectName`	Specifies the analysis database settings for a specified project.

-setDSParam options

Table 3. -setDSParam options
Option	Description
-projectName `ProjectName`	Specifies the analysis engine settings for a specified project.
-dsHost `DataStageHostName`	Specifies the analysis engine host name.
-dsUser `DataStageUserName`	Specifies the analysis engine user name. The user name must be a valid user name for an operating system user on the computer that hosts InfoSphere DataStage.
-dsPassword `DataStagePassword`	Specifies the analysis engine password. The password must be a valid password for an operating system user on the computer that hosts InfoSphere DataStage.
-dsPort `DataStagePortNumber`	Specifies the analysis engine port number.
-dsProject `DataStageProjectName`	Specifies the analysis engine project name.
-handlerName `HandlerName`	Specifies the handler name. Do not use this option because the default setting should not be changed.
-retainOSH TRUE\|FALSE	Specifies whether the OSH script should be retained at the end of an analysis job. If set to TRUE, specifies that the OSH script should be retained at the end of an analysis job. If set to FALSE, then the script is deleted.
-arraySize `Arraysize`	Specifies the array size. The array size controls the number of data rows to be grouped as a single operation, which affects write operation performance. A higher array size increases memory consumption and could degrade performance. The default setting for the array size is 2000.
-isolationLevel `IsolationLevel`	Specifies the isolation level. Do not use this option because the default setting should not be changed.
-autoCommitMode 0\|1	Specifies whether auto commit mode should be used for analysis results. If set to 0, auto commit mode is not used. If set to 1, then auto commit mode is used. The default is 0. Do not change the value of this option unless you are running analysis on a Microsoft Excel or Microsoft Access source file. If you are running analysis on an Excel or an Access source file, then change this option to 1. In all other cases, the default setting should not be changed.
-useCredentialMapping TRUE\|FALSE	Specifies whether credential mapping should be used. If set to TRUE, credential mapping is used for the InfoSphere Information Server engine. If set to FALSE, then the user name and password is required.