Friday, April 17, 2015

Optimize Domain and Repository Size and Performance



Informatica Admin team will receive concerns from developers saying that development repository performance is too bad and have issues to work on their regular tasks on daily wise, so as administrator its admin responsibly to review issues and fix, below are some of my findings where this could help in improving of performance.

Also please note below steps will clean up all history or logs etls and you cannot fetch history runs of your jobs, and note if the maintenance of the repository is not performed regularly, command line (pmrep truncatelog) might not work or takes long time to truncate the tables.
  
NOTE: Make sure to discuss internally with your team /client before implementing these steps, also you understand logic behind these steps.

1.1           Cleanup Unused ETL Objects:

·        Clean up unwanted / unused folders in repository
(select * from opb_subject)
·        Clean up all Backup Folders
·        Identify unwanted/unused workflows in the repository (Check below query)

select * from(
select subj_name, workflow_name,server_name, trunc(start_time) as start_time,
rank() over (partition by subject_id, workflow_name order by start_time desc ) rnk
from  OPB_WFLOW_RUN,opb_subject
where OPB_WFLOW_RUN.subject_id=opb_subject.subj_id
) where rnk=1


select server_name,count(1) from(
select subject_id, workflow_name,server_name, trunc(start_time) as start_time,
rank() over (partition by subject_id, workflow_name order by start_time desc ) rnk
from  OPB_WFLOW_RUN
) where rnk=1
group by server_name
--order by 1,2,3

·        Identify in any un used connections can be cleaned up
Select * from opb_cnx

1.2           Update Stats of Repository Schema

·        After cleanup of unwanted Folders or ETL’s make sure execute stats job on Repository database.

 1.3           Steps to complete before running the Cleanup queries

1.      Stop the repository service
2.      Take the backup of repository (skip workflow and session log, skip deployment group history, skip MX data) – this is an optional step.
Ideally – the below operations will not cause any impact on the repository service, but if required you can take the backup.

Note: Please do not make this as a script. Perform manually.

1.4           Steps to cleanup - Queries

1.       Take Backup of below OPB tables.
2.       To truncate all data from the OPB tables which stores the run history information

TRUNCATE TABLE OPB_SESS_TASK_LOG;
TRUNCATE TABLE OPB_SWIDGINST_LOG;
TRUNCATE TABLE OPB_DTL_SWIDG_LOG;
TRUNCATE TABLE OPB_TASK_INST_RUN;
TRUNCATE TABLE OPB_WFLOW_VAR_RUN;
TRUNCATE TABLE OPB_WFLOW_DEP_RUN;
TRUNCATE TABLE OPB_WFLOW_CACHE;
TRUNCATE TABLE OPB_WFLOW_RUN;
TRUNCATE TABLE OPB_PERF_COUNT;

3.       To backup and retain last  15 days run history (if you have any)

DROP TABLE OPB_SESS_TASK_LOG_BACKUP;
DROP TABLE OPB_SWIDGINST_LOG_BACKUP;
DROP TABLE OPB_DTL_SWIDG_LOG_BACKUP;
DROP TABLE OPB_TASK_INST_RUN_BACKUP;
DROP TABLE OPB_WFLOW_VAR_RUN_BACKUP;
DROP TABLE OPB_WFLOW_DEP_RUN_BACKUP;
DROP TABLE OPB_WFLOW_CACHE_BACKUP;
DROP TABLE OPB_WFLOW_RUN_BACKUP;
DROP TABLE OPB_PERF_COUNT_BACKUP;


CREATE TABLE OPB_SESS_TASK_LOG_BACKUP AS SELECT A.* FROM OPB_SESS_TASK_LOG A,OPB_WFLOW_RUN B WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

CREATE TABLE OPB_SWIDGINST_LOG_BACKUP AS SELECT A.* FROM OPB_SWIDGINST_LOG A,OPB_WFLOW_RUN B WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

CREATE TABLE OPB_DTL_SWIDG_LOG_BACKUP AS
SELECT A.* FROM OPB_DTL_SWIDG_LOG A,OPB_WFLOW_RUN B
WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

CREATE TABLE OPB_TASK_INST_RUN_BACKUP AS
SELECT A.* FROM OPB_TASK_INST_RUN A,OPB_WFLOW_RUN B
WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

CREATE TABLE OPB_WFLOW_VAR_RUN_BACKUP AS
SELECT A.* FROM OPB_WFLOW_VAR_RUN A,OPB_WFLOW_RUN B
WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

CREATE TABLE OPB_WFLOW_DEP_RUN_BACKUP AS
SELECT A.* FROM OPB_WFLOW_DEP_RUN A,OPB_WFLOW_RUN B
WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

CREATE TABLE OPB_WFLOW_CACHE_BACKUP AS
SELECT A.* FROM OPB_WFLOW_CACHE A,OPB_WFLOW_RUN B
WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

CREATE TABLE OPB_WFLOW_RUN_BACKUP AS SELECT * FROM OPB_WFLOW_RUN
WHERE END_TIME >= SYSDATE-15 AND END_TIME IS NOT NULL;

CREATE TABLE OPB_PERF_COUNT _BACKUP AS
SELECT A.* FROM OPB_PERF_COUNT A,OPB_WFLOW_RUN B
WHERE A.WORKFLOW_RUN_ID=B.WORKFLOW_RUN_ID AND
B.END_TIME >= SYSDATE-15 AND B.END_TIME IS NOT NULL;

TRUNCATE TABLE OPB_SESS_TASK_LOG;
TRUNCATE TABLE OPB_SWIDGINST_LOG;
TRUNCATE TABLE OPB_DTL_SWIDG_LOG;
TRUNCATE TABLE OPB_TASK_INST_RUN;
TRUNCATE TABLE OPB_WFLOW_VAR_RUN;
TRUNCATE TABLE OPB_WFLOW_DEP_RUN;
TRUNCATE TABLE OPB_WFLOW_CACHE;
TRUNCATE TABLE OPB_WFLOW_RUN;
TRUNCATE TABLE OPB_PERF_COUNT;


INSERT INTO OPB_SESS_TASK_LOG SELECT * FROM OPB_SESS_TASK_LOG_BACKUP; COMMIT;
INSERT INTO OPB_SWIDGINST_LOG  SELECT * FROM OPB_SWIDGINST_LOG_BACKUP; COMMIT;
                  INSERT INTO OPB_DTL_SWIDG_LOG SELECT * FROM OPB_DTL_SWIDG_LOG_BACKUP; COMMIT;
INSERT INTO OPB_TASK_INST_RUN SELECT * FROM OPB_TASK_INST_RUN_BACKUP; COMMIT;
                  INSERT INTO OPB_WFLOW_VAR_RUN SELECT * FROM OPB_WFLOW_VAR_RUN_BACKUP; COMMIT;
INSERT INTO OPB_WFLOW_DEP_RUN SELECT * FROM OPB_WFLOW_DEP_RUN_BACKUP; COMMIT;
INSERT INTO OPB_WFLOW_CACHE SELECT * FROM OPB_WFLOW_CACHE_BACKUP; COMMIT;
INSERT INTO OPB_WFLOW_RUN SELECT * FROM OPB_WFLOW_RUN_BACKUP; COMMIT;
                  INSERT INTO OPB_PERF_COUNT SELECT * FROM OPB_PERF_COUNT_BACKUP; COMMIT;

1.5           Steps to optimize after cleanup

After truncating the run history data from the repository tables, analyze the tables.
Run pmrep updatestatistics command.

Also, please refer to the KB article 14331 - which guides how to improve PowerCenter repository performance using the pmrep updatestatistics command

The following is the link to the KB article. Please follow the steps.

1.6           Steps to optimize Domain Database

o   Take backup of Domain
o   Take backup of TABLE ISP_RUN_LOG

o   Truncate TABLE ISP_RUN_LOG

Monday, March 9, 2015

Informatica PowerCenter 9.6.1 Installation Steps

Informatica Power Center 9.6.1 Installation Steps
 ********************************************************************************
TABLE OF CONTENTS

    1.   Overview   
     2.   Pre Installation Steps
2.1     Download Software               
2.2     Setup of Database Parameters, Users & Tablespace               
2.2.1    Database Parameter     
2.2.2    Repository Account       
2.2.3    Repository Tablespace 
2.3     Operating System   
     2.3.1    Processor           
     2.3.2    Temporary Disk Space Requirements    
     2.3.3    UNIX User Account        
     2.3.4    Port Validation 
     2.3.5    Environment Variables 
2.3.6    Obtain the locale values               
     2.3.7    File Descriptor  
     2.3.8    Installation directory and Permission     
     3.   961 Software Installation           
     4.   Post Installation Steps
4.1     Port Configuration          
4.1.1    Guidelines for Port Configuration        
5.Execute Informatica SRT    

********************************************************************************


1    Overview 

This document is for informatica administration team, providing the detailed steps on installation of Power Center 9.6.1 on Linux & Oracle Environment.

2.     Pre Installation Steps       
2.1   Download Software

Download Software from informatica Corporation and make sure to get proper keys based on environment (Dev/ Prod).

2.2           Setup of Database Parameters, Users & Tablespace
2.2.1 DATABASE PARAMETER
Set the open_cursors parameter to 1000
SQL> SHOW parameter open_cursor;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300
SQL> ALTER system SET open_cursors=1000;

System altered.

SQL>  ALTER system SET open_cursors=1000 SCOPE=BOTH;

System altered.

SQL> SHOW parameter open_cursors;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     1000
2.2.2   REPOSITORY ACCOUNT
At least two database user accounts (Domain and Repository) are required to host repository, Taking sample names as
USER_REP for the repository Database
USER_DOM for the domain Configuration Database
Both user need to create with the CONNECT, RESOURCE, and CREATE VIEW privileges.
For Oracle, you must perform the following instruction:
CREATE USER USER_REP IDENTIFIED BY USER_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW TO USER_REP;

CREATE USER UASER_DOM IDENTIFIED BY USER_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW, SELECT ANY dictionary TO USER_DOM;

The grant “select dictionary privilege” to the user INFA_DOM is only needed to verify the parameter Open_Cursor during the prerequisite check.
  
2.2.3    Repository Table-space

Set the storage size for the table-space to a small number to prevent the repository from using an excessive amount of space.
Also verify that the default tablespace for the user that owns the repository tables is set to a small size. The following example shows how to set the recommended storage parameter for a tablespace named PC_TABLESPACE.

ALTER TABLESPACE "PC_TABLESPACE" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED PCTINCREASE 50 );

2.3      Operating System

2.3.1            Processor
Verify that the process match the software (x86_64)
Display the Linux platform =  uname - p
List the basic system information, OS release, and OS version  = uname -orv
-bash-3.2$ uname -p
x86_64

-bash-3.2$ uname –arv

Linux ServerName 12.66.18-164.el5 #1 SMP Thu Sep 3 04:15:13 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
2.3.2       Temporary Disk Space Requirements
The installer writes temporary files to the hard disk. When the installation completes, the installer deletes the temporary files and releases the disk space.
Installer UNIX
1 GB
Informatica Services UNIX
2 GB
Verification of the temporary space with the df
-bash-3.2$  df -h /tmp

2.3.3    Unix User Account
On UNIX, create a user account infa91 specifically to run the Informatica daemon required for installation having group privileges’ on Oracle and java groups
2.3.4    Port Validation
Verify that the port numbers are available on the machines where you install Informatica Services.
-bash-3.2$  netstat -tulpn|grep 6005
The installer validates the port numbers that you specify to ensure that there will be no port conflicts in the domain.
-bash-3.2$  netstat -tulpn|grep 6001
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
tcp        0      0 :::6001                     :::*                        LISTEN      4935/java
-bash-3.2 netstat -tulpn|grep 6002
(Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.)
tcp        0      0 ::ffff:127.0.0.1:6002       :::*                        LISTEN      4935/java
-bash-3.2$  netstat -tulpn|grep 6003
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
-bash-3.2$  netstat -tulpn|grep 6004
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
  
2.3.5     Environment Variables

Most UNIX systems use the LANG variable to specify the desired locale but you can use also the set locale function.
2.3.6    Obtain Locale Values
To obtain the locale names for your UNIX system, enter the following:
infa@chetltst201 $ locale -a | grep -i en
en_IN.utf8
en_NZ
en_NZ.iso88591
en_NZ.utf8
en_PH
en_PH.iso88591
en_PH.utf8
en_SG
en_SG.iso88591
en_SG.utf8
en_US
en_US.iso88591
en_US.iso885915
en_US.utf8
en_ZA
en_ZA.iso88591
en_ZA.utf8
en_ZW
en_ZW.iso88591
en_ZW.utf8
french
slovene
slovenian
  
2.3.7  File Descriptor

Informatica service processes can use a large number of files. Set the Linux - File Descriptorlimit per process to 3000 or higher.
In the file /etc/security/limits.conf, add this line:
# PowerCenter
Infa91   hard   nofile    3001
Infa91   soft   nofile    2500
And verify with the ulimit function logged as the power center system user account:
-bash-3.2$  ulimit -Hn
3001
The limit is set to 3001 to prevent an error with the value 300 during the prerequisites check

2.3.8  Installation directory and Permission
As root, create the installation base directory:
Pwd
/infa
mkdir /informatica
chown  755 informatica
cd informatica
mkdir pc91
chown 755 pc91
cd  /infa
mkdir software
chmod 755 software

As the installer (powercenter), copy the file to software directory, unzip and untar it:

3. 961 Software Installation                  

Enter the choice(1 or 2):1

-----------------------------------------------------------
Checking for existing 9.6.1 product installation.
Unset the INFA_HOME,INFA_NODE_NAME and INFA_DOMAINS_FILE before continuing
the installation. Continuing the installation with the environment variables set
will cause the installation to fail.
Installer will exit now.
/opt/infa/svc-abc-snd/SOFT>unset INFA_HOME INFA_NODE_NAME INFA_DOMAINS_FILE
/opt/infa/svc-abc-snd/SOFT>./install.sh
OS detected is Linux

\***************************************************************************
\* Welcome to the Informatica 9.6.1 Server Installer.  *
\***************************************************************************
Before you continue, read the following documents:
* Informatica 9.6.1 Installation GuDEV and Release Notes.
* B2B Data Transformation 9.6.1 Installation, Configuration GuDEV and Release Notes.

You can find the 9.6.1 documentation in the Product Documentation section at http://mysupport.informatica.com.

Configure the LANG and LC_ALL variables to generate appropriate code pages and
create and connect to repositories and Repository Services.
Do you want to continue? (Y/N)Y
Installer requires Linux version 2.6.18-0 or later versions of the 2.6.18 series or version 2.6.32-0 or later versions of the 2.6.32 series.
Current operating system Linux version 2.6.32-431.
Current operating system meets minimum requirements.

Select to install or upgrade:

  1. Install or upgrade Informatica.
   Select this option if the machine does not have Informatica services installed or if it has Informatica 9.5.1 or an earlier version installed.

  2. Install or upgrade Data Transformation Engine Only.
   Select this option to install or upgrade only Data Transformation Engine.

Enter the choice(1 or 2):1
-----------------------------------------------------------
Checking for existing 9.6.1 product installation.
To verify whether the machine meets the system requirements for the Informatica installation or upgrade, run the Pre-Installation (i9Pi) System Check Tool before you start the installation or upgrade process. It is recommended 

that you verify the minimum system requirements.

Select one of the following options:
1. Run the Pre-Installation (i9Pi) System Check Tool
2. Run the Informatica Kerberos SPN Format Generator
3. Run the Informatica services installation
Select the option to proceed : (Default : 3)1
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
The value for the DISPLAY variable is not valid. Set the DISPLAY variable to the graphics display server or unset the variable.
Do you want to continue the Informatica Services Installation (y/n) ?y
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
The value for the DISPLAY variable is not valid. Set the DISPLAY variable to the graphics display server or unset the variable.
/opt/infa/svc-abc-snd/SOFT>unset DISPLAY
/opt/infa/svc-abc-snd/SOFT>./install.sh
OS detected is Linux

\***************************************************************************
\* Welcome to the Informatica 9.6.1 Server Installer.  *
\***************************************************************************

Before you continue, read the following documents:
* Informatica 9.6.1 Installation GuDEV and Release Notes.
* B2B Data Transformation 9.6.1 Installation, Configuration GuDEV and Release Notes.

You can find the 9.6.1 documentation in the Product Documentation section at http://mysupport.informatica.com.

Configure the LANG and LC_ALL variables to generate appropriate code pages and
create and connect to repositories and Repository Services.
Do you want to continue? (Y/N)Y
Installer requires Linux version 2.6.18-0 or later versions of the 2.6.18 series or version 2.6.32-0 or later versions of the 2.6.32 series.
Current operating system Linux version 2.6.32-431.
Current operating system meets minimum requirements.

Select to install or upgrade:

  1. Install or upgrade Informatica.
   Select this option if the machine does not have Informatica services installed or if it has Informatica 9.5.1 or an earlier version installed.

  2. Install or upgrade Data Transformation Engine Only.
   Select this option to install or upgrade only Data Transformation Engine.

Enter the choice(1 or 2):1
-----------------------------------------------------------
Checking for existing 9.6.1 product installation.
To verify whether the machine meets the system requirements for the Informatica installation or upgrade, run the Pre-Installation (i9Pi) System Check Tool before you start the installation or upgrade process. It is recommended 

that you verify the minimum system requirements.

Select one of the following options:
1. Run the Pre-Installation (i9Pi) System Check Tool
2. Run the Informatica Kerberos SPN Format Generator
3. Run the Informatica services installation
Select the option to proceed : (Default : 3)1
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

*********************************************************************************
Welcome - Step 1 of 4
*********************************************************************************

[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Informatica Pre-Installation (i9Pi) System Check Tool
The Pre-Installation (i9Pi) System Check Tool verifies the minimum system and database requirements for the Informatica services installation or upgrade.
Press to continue ...

*********************************************************************************
System Information - Step 2 of 4
*********************************************************************************

[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Informatica installation directory: (default :- /opt/infa/svc-abc-snd) :/opt/infa/svc-abc-snd/Informatica/9.6.1
Informatica starting port number: (default :- 6005) :7888

*********************************************************************************
Database and JDBC Connection Information - Step 3 of 4
*********************************************************************************

[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Use Custom String
      1->YES
    * 2->NO
:1

Database type:
      1->DB2
      2->SQLServer
    * 3->Oracle
      4->Sybase
:
Database user ID: (default :- INFA_DEV_SND_DOM) :
Database user password: :
Custom String :jdbc:informatica:Oracle://TEST-ora01.TESTING.com:1771;DatabaseName=indev

*********************************************************************************
System Check Summary - Step 4 of 4
*********************************************************************************

[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Informatica Pre-Installation (i9Pi) System Check Tool Results
[Pass] Disk Space: Available disk space is 18,628 MB. Sufficient for the Informatica installation.
[Pass] Processors: Available number of processors is 2. Sufficient for the Informatica installation.
[Pass] Physical Memory: Available physical memory is 16,326 MB. Sufficient for the Informatica installation.
[Pass] Temporary Space: Available temporary disk space is 4,379 MB. Sufficient for the Informatica installation.
[Pass] Ports: Port range is 7,080 - 7,084. All port numbers within the port range are available for the Informatica installation.
[Pass] Locale Environment Variable: The LANG environment variable is set to language C. The LC_ALL environment variable is set to language C. Sufficient for the Informatica installation.
[Pass] JRE_HOME Environment Variable: The JRE_HOME environment variable does not contain a value. Sufficient for the Informatica installation.
[Pass] File Descriptor Limits: The file descriptor limits per process is 1620107. Sufficient for the Informatica installation.
[Pass] RESOURCE Privilege: The database user account has the RESOURCE privilege. Sufficient for the Informatica installation.
[Pass] CREATE TABLE Privilege: The database user account has the CREATE TABLE privilege. The installer successfully created a database table.
[Pass] CREATE VIEW Privilege: The database user account has the CREATE VIEW privilege. The installer successfully created a database view.
[Information] Informatica Installation Directory: /opt/infa/svc-abc-snd/Informatica/9.6.1
[Information] Informatica Starting Port Number: 7080
[Information] Database Type: Oracle
[Information] Database User ID: INFA_DEV_SND_DOM
[Information] Operating System: Operating system is Linux. Operating system version is 2.6.32-431.11.2.el6.x86_64.
[Information] RAM: The memory module size is 16,326 MB.

Press Enter to quit the pre-installation system check...
Do you want to continue the Informatica Services Installation (y/n) ?y

Press Enter to quit the pre-installation system check...
Do you want to continue the Informatica Services Installation (y/n) ?y
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...

Configuring the installer for this system's environment...

*********************************************************************************
Installation Type - Step 1 of 7
*********************************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Select to install or upgrade:
    * 1->Install Informatica 9.6.1.
Select this option to perform a full installation of Informatica 9.6.1.
      2->Upgrade to Informatica 9.6.1.
Select this option to upgrade previous versions of Informatica products to Informatica 9.6.1.
:1
Enable Kerberos network authentication
    * 1->No
      2->Yes
:
*********************************************************************************
Installation Pre-Requisites - Step 2 of 7
*********************************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Verify the installation pre-requisites and complete the
pre-installation tasks before you continue.

Disk Space Requirement: 7 GB

Memory Requirement (RAM): 4 GB

Database Requirements
- Verify the Oracle, IBM DB2, Microsoft SQL Server, or Sybase ASE database version.
- Verify the database user account. The account must have permissions to create and
drop tables and views, and insert, update, and delete data.

Pre-installation Tasks
- Obtain the Informatica license key.
- Verify the minimum system requirements.
- Set the environment variables.
- Verify the port availability.
- Set up the keystore file.
- On UNIX, set the file descriptor limit.
- On UNIX, configure POSIX asynchronous I/O.
- Download and extract the Informatica installer files.
- Run the Informatica Pre-Installation (i9Pi) System Check Tool.
- If you are enabling Kerberos network authentication, run the Informatica Kerberos SPN Format Generator.
Press to continue ...
*********************************************************************************
License Key - Step 3 of 7
*********************************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Enter the license key file (default :- /opt/infa/svc-abc-snd/license.key) :/opt/infa/svc-abc-snd/SOFT/LicenseKeyName.key

*********************************************************************************
Installation Directory - Step 3 of 7
*********************************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Enter the installation directory (default :- /opt/infa/svc-abc-snd/Informatica/9.6.1) :
*********************************************************************************
Pre-Installation Summary - Step 4 of 7
*********************************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Product Name     :      Informatica 9.6.1 Services
Installation Type        :      New Installation
Installation Directory   :      /opt/infa/svc-abc-snd/Informatica/9.6.1
Disk Space Requirements
Required Disk Space      :      6,999 MB
Available Disk Space     :      18,628 MB
Press to continue ...

*********************************************************************************
Installing - Step 5 of 7
*********************************************************************************

 [==================|==================|==================|==================]
 [==================|==================|==================|==================]
 [==================|==================|==================|==================]
 [==================|==================|==================|==================]

*********************************************************************************
Domain Selection - Step 5A of 7
*********************************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

    * 1->Create a domain
      2->Join a domain
:

Enable secure communication for the domain
    * 1->No
      2->Yes
:
    * 1->Enable HTTPS for Informatica Administrator
      2->Disable HTTPS
:
Port: (default :- 8443) :8445
    * 1->Use a keystore file generated by the installer
      2->Specify a keystore file and password:
:
Generating keystore...
-
*********************************************************************************
Domain Configuration Repository - Step 5B of 7
*********************************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Configure the database for the domain configuration repository:
Database type:
    * 1->Oracle
      2->SQLServer
      3->DB2
      4->Sybase
:
Database user ID: (default :- INFA_DEV_SND_DOM) :
User password: :
Configure the database connection
      1->JDBC URL
    * 2->Custom JDBC Connection String
:
Custom String (default: jdbc:informatica:Oracle://TEST-Ora01.TEST:1771;DatabaseName=idev)

*********************************************************************************
Domain Security - Encryption Key - Step 5C of 7
*********************************************************************************

[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Keyword: : TESTING123
Encryption key directory: (default :- /opt/infa/svc-abc-snd/Informatica/9.6.1/isp/config/keys) :

Information !!! The encryption key will be generated in /opt/infa/svc-abc-snd/Informatica/9.6.1/isp/config/keys
with the file name siteKey. You must keep the name of the domain, the keyword for the encryption key,
and the encryption key file in a secure location. The domain name, keyword, and
encryption key are required when you change the encryption key for the domain or move a repository to another domain.

Select a Choice
    * 1->OK
:

*********************************************************************************
Domain and Node Configuration - Step 6 of 7
*********************************************************************************

[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Enter the following information for the Informatica domain.
Domain name: (default :- Domain_TEST-dapp-inf01.TESTING.com) :Domain_DEV96San
Node host name: (default :- TEST-dapp-inf01.TESTING.com) :TEST-dapp-inf01
Node name: (default :- node01_TEST-dapp-inf01.TESTING.com) :TEST-dapp-inf01
Node port number: (default :- 7080) :
Domain user name: (default :- Administrator) :Administrator
Domain password: (default :- ) :
Confirm password: (default :- ) :
Display advanced port configuration page
    * 1->No
      2->Yes
:

Executing Command...
---
Defining domain...
-
Registering plugins...
-
Starting service...
-
Pinging domain...
-
Pinging domain...
-
Pinging domain...
-
Pinging Administrator...
-
Pinging Administrator...
-
Pinging Administrator...
-
Pinging Administrator...
-

*********************************************************************************
Post-Installation Summary - Step 7 of 7
*********************************************************************************
Installation Status SUCCESS

The Informatica 9.6.1 installation is complete.

For more information, see the debug log file:
/opt/infa/svc-abc-snd/Informatica/9.6.1/Informatica_9.6.1_Services.log

Installation Type :New Installation

Informatica Administrator Home Page::
http://TEST-dapp-inf01.TESTING.com:7888

Product Name:  Informatica 9.6.1 Services