Using infasetup
infasetup is a command line program that you use to administer Informatica domains and nodes.
Use infasetup to modify domain and node properties after you install Informatica services with the Informatica installation program. For example, you can use infasetup to change the port number for a node after you install Informatica services on the node.
You can use infasetup to back up, restore, define, and delete domains, and to define and update nodes.
Running Commands
You invoke infasetup from the command line. You can issue commands directly or from a script, batch file, or other program. On Windows, infasetup is a batch file with a .bat extension. On UNIX, infasetup is a script file with a .sh extension.
To run infasetup commands:
1. Open a command prompt.
On Windows, open the command prompt as administrator. If you do not open the command prompt as administrator, the Windows system administrator might encounter issues when accessing files in the Informatica installation directory.
2. At the command prompt, switch to the directory where the infasetup executable is located.
By default, infasetup installs in the <InformaticaInstallationDir>/isp/bin directory.
3. Enter infasetup on Windows or infasetup.sh on UNIX followed by the command name and its required options and arguments. The command names are not case sensitive.
For example:
infasetup(.sh) command_name [-option1] argument_1 [-option2] argument_2...
Command Options
When you run infasetup, you enter options for each command, followed by the required arguments. Command options are preceded by a hyphen and are not case sensitive. Arguments follow the option.
For example, the following command updates a worker node with the name “Node1” and the address “Host1:9090”:
infasetup UpdateWorkerNode -nn Node1 -na Host1:9090
If you omit or incorrectly enter one of the required options, the command fails, and infasetup returns an error message.
infasetup Return Codes
infasetup indicates the success or failure of a command with a return code. Return code (0) indicates that the command succeeded. Return code (-1) indicates that the command failed.
Use the DOS or UNIX echo command immediately after running an infasetup command to see the return code for the command:
- •In a DOS shell: echo %ERRORLEVEL%
- •In a UNIX Bourne or Korn shell: echo $?
- •In a UNIX C shell: echo $status
Using Database Connection Strings
Some infasetup commands use connection strings to connect to the domain configuration database. Specify the database host, database port, and database service name as part of the connection string.
You can use connection strings with the following infasetup commands:
- •BackupDomain
- •DefineDomain
- •DefineGatewayNode
- •DeleteDomain
- •RestoreDomain
- •UpdateGatewayNode
The following table lists the connection string syntax for each supported database:
Database Name | Connection String |
|---|
Oracle | Oracle: jdbc:informatica:oracle://host_name:port;SID=sid Oracle RAC: jdbc:informatica:oracle://host_name:port; ServiceName=[Service Name];AlternateServers=(server2:port);LoadBalancing=true |
Microsoft SQL Server | jdbc:informatica:sqlserver://host_name:port; SelectMethod=cursor;DatabaseName=database_name |
IBM DB2 | jdbc:informatica:db2://host_name:port; DatabaseName=database_name |