Bookshelf v7.7: Configuring the DAC Server on UNIX

Configuring the DAC Server on UNIX

Shell scripts are provided in the *.sh and *.csh formats. You must use the appropriate scripts in the appropriate shells, because their syntaxes are different. lists the available shell scripts and their usage. These files contain comments that provide information about how to configure the scripts.

Table 28. Siebel Data Warehouse Scripts for Bash and C Shells
Script	Purpose
config.sh config.csh	Configures the environment variables for DAC_HOME and JAVA_HOME.
dacCmdLine.sh dacCmdLine.csh	Invokes DAC commands on the DAC server. See the file for usage information.
dac_env.sh dac_env.csh	Configures environment variables, including Informatica's pmcmd utility, which enables the DAC server to invoke workflows. Other variables included are NLS_LANG and ORA_HOME.
serverSetupPrompt.sh serverSetupPrompt.csh	Configures DAC metadata repository connection information and DAC administrator email account information, which enables the DAC to send email notification upon the success or failure of execution plans.
serverinfo.sh serverinfo.csh	Displays the DAC server version.
startserver.sh startserver.csh	Starts the DAC server on machines running Solaris and HP.
startserver_aix.sh startserver_aix.csh	Starts the DAC server on AIX machines.
stopserver.sh stopserver.csh	Shuts down the DAC server.

NOTE: All the files listed in Table 28 need to have read, write, and execute permissions. If the files do not have these permissions, modify them using the chmod command.

To configure the DAC server on UNIX

Edit the dac_env.sh or dac_env.csh file to add the path of the directories for the Informatica Server and Informatica Repository Server to the appropriate environment variable:

For Solaris: LD_LIBRARY_PATH
For AIX: LIBPATH
For HP: SHLIB_PATH
For example:

setenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:/<INFA_HOME>/informatica621/pm

If you are using an Oracle database and the OCI driver, configure the following variables and uncomment them by removing the # sign at the beginning of the line:

TNS_ADMIN: To set the directory for Oracle to use tnsnames.ora files
LD_LIBRARY_PATH (Solaris), LIBPATH (AIX), or SHLIB_PATH (HP): To set the Oracle library path.
NOTE: Informatica does not support 64-bit libraries.

Edit the config.sh or config.csh file to set the JAVA_HOME directory.

CAUTION: Do not edit any other parameter in this file.

Copy the database-specific .jar files to the $DAC/lib directory:

Oracle. If you are using an Oracle database (other than 8.x), find the directory where Oracle is installed. Copy the file named ojdbc14.jar in the jdbc/lib directory and paste it in the $DAC/lib directory.
- If you are using Oracle 8.x, copy the file named classes12.zip and paste it in the $DAC/lib directory. Also, edit the ORACLELIB setting in the config.sh or config.csh file as follows:

setenv ORACLELIB=$DAC_HOME/lib/classes12.zip

DB2. If you are using a DB2 database, find the directory where DB2 is installed. In the Java subdirectory copy the file named db2java.zip and paste it in the $DAC/lib directory.
NOTE: If your source or target database is DB2-UDB, you also need to create Siebel stored procedures to be used during the ETL process. For instructions, see Creating Siebel Stored Procedures for DB2-UDB.
MSSQL. If you are using an MSSQL database, download the SQL Server JDBC drivers from Microsoft's Web site. Copy the files msbase.jar, mssqlserver.jar, and msutil.jar to the $DAC/lib directory.

Run serverSetupPrompt.sh or serverSetupPrompt.csh to set the repository connection information and the email settings:

At the initial prompt, enter 1 to set the repository connection information.
Enter 3 to test the repository connection.
Enter 4 to save the information you entered.
Enter 2 to set up the administrator email account.
NOTE: For the email functionality to work, you must be using an SMTP server in which the SMTP authentication mode LOGIN is enabled. For example, if you are using Microsoft Exchange Server, you must enable the SMTP module and enable authentication in the Basic Mode. The SMTP server outbound email authentication must be turned on for the DAC server to be able to send email notifications.
Enter 5 to exit.

Copy content-specific XML files from the SiebelAnalytics\DAC\CustomSQLs folder in the Windows installation to the SiebelAnalytics\DAC\CustomSQLs folder in the UNIX installation.