Monday, July 23, 2018

Informatica 10.1.1 HF2 Upgrade from 9.6.1




[infadev@devnode1 INF10]$ ./install.sh

\***************************************************************************
\* Welcome to the Informatica 10.1.1 Hotfix 2 Server Installer.  *
\***************************************************************************



Before you continue, read the following documents:
* Informatica 10.1.1 Hotfix 2 Installation Guide and Release Notes.
* B2B Data Transformation 10.1.1 Hotfix 2 Installation, Configuration Guide and Release Notes.

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

Configure the LANG and LC_ALL variables to generate the appropriate code pages and
create and connect to repositories and Repository Services.
Do you want to continue? (Y/N)Y

Select one of the following options to install or upgrade:

  1. Install Informatica.
   Choose this option if the machine does not have Informatica services installed.


  2. Upgrade Informatica.
   .Choose this option if the following condition is true:
   * You want to upgrade the Informatica services on a machine that has Informatica version 10.1.0 or an earlier version installed.


  3. Install or upgrade Data Transformation Engine Only.
   Choose this option to install or upgrade only Data Transformation Engine.


  4. Apply Hotfix 2 to Informatica 10.1.1 or roll back the hotfix.
   .Choose this option to apply the hotfix to Informatica version 10.1.1 or roll back the hotfix.


Enter the choice(1 or 2 or 3 or 4):2

-----------------------------------------------------------
Checking for an Informatica 10.1.1 Hotfix 2 installation.
Select one of the following options:
1. Run Informatica Upgrade Advisor
2. Run the Informatica services upgrade installation
Select the option to proceed : (Default : 1)2
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 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]

I agree to the terms and conditions
    * 1->No
      2->Yes
(Default: 1):2

Version 10.1.1 HotFix 2 does not support big data functionality.
If you install or upgrade to version 10.1.1 HotFix 2, the big data functionality will not be available.
Do you want to continue?
    * 1->No
      2->Yes
(Default: 1):2


******************************************************************************************************
Upgrade Prerequisites - Step 2 of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]

Verify the upgrade prerequisites and complete the pre-upgrade tasks before you continue.

 Database Requirements: -Requires Oracle, IBM DB2, Microsoft SQL Server or Sybase ASE.

 One of the following product versions must be installed on this machine:
 - Informatica 9.5.1
 - Informatica 9.6.1
 - Informatica 10.0.0
 - Informatica 10.1.0
 - Data Transformation Engine 9.5.1
 - Data Transformation Engine 9.6.1
 - Data Transformation Engine 10.0.0
 - Data Transformation Engine 10.1.0

 Disk Space Requirement: 10 GB
 Memory Requirement (RAM): 6 GB

   Pre-upgrade tasks:
 - Back up the domain configuration repository.
 - For a DB2 database, verify that the tablespace has a page size of 32K.
 - While performing upgrade please verify that the domain is shut down.
 - The Reporting and Dashboards Service and Reporting Service are obsolete.
 If the services are present in the domain, the installer deletes the services during the upgrade process.
 For more information about generating the reports, see the Knowledge Base article: https://kb.informatica.com/howto/6/Pages/18/496097.aspx
Press to continue ...

******************************************************************************************************
Upgrade Directory - Step 3 of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Enter the installation directory


Enter the directory of the Informatica product to upgrade: (default :- /home/infadev/Informatica/10.1.0) :/dev/informatica/9.6.1

Enter the directory for Informatica 10.1.1 Hotfix 2: (default :- /dev/informatica/10.1) :/dev/informatica/10.1.1

Allow changes to the node configuration.

Select this option to change the node host name, port numbers, or domain configuration repository database during the upgrade. This option requires additional configuration tasks after the upgrade.
    * 1->No
      2->Yes
(Default: 1):

Stopping the service...
-
Executing the Command...
-----

******************************************************************************************************
Domain Security - Encryption Key - Step 3C of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Encryption key directory: (default :- /dev/informatica/10.1.1/isp/config/keys) :

Domain user name: :Administrator

Domain password: :


******************************************************************************************************
Pre-Installation Summary - Step 4 of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Product Name     :      Informatica 10.1.1 Hotfix 2 services

Installation Type        :      Upgrade

Installation Directory   :      /dev/informatica/10.1.1

Required Disk Space      :      10,733 MB

Available Disk Space     :      19,014 MB

Press to continue ...

Stopping the service...
-
Warning !!! Ensure the Informatica domain is shutdown before you upgrade.

Select a Choice
    * 1->OK
(Default: 1):


******************************************************************************************************
Upgrading - Step 5 of 8
******************************************************************************************************



Upgrading... 5%

Upgrading... 10%

Upgrading... 15%

Upgrading... 20%

Upgrading... 25%

Upgrading... 30%

Upgrading... 35%

Upgrading... 40%

Upgrading... 45%

Upgrading... 50%

Upgrading... 55%

Upgrading... 60%

Upgrading... 65%

Upgrading... 70%

Upgrading... 75%

Upgrading... 80%

Upgrading... 85%

Upgrading... 90%

Upgrading... 95%

Upgrading... 100%

******************************************************************************************************
Domain Configuration Repository - Step 5B of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


The upgrade wizard will use the following settings for the domain configuration repository upgrade:
Database type: ORACLE
Database user ID: INF_DOMdev
User password: ******************
Database address: devdb:1521
Database service name: infdev
Press to continue ...

Executing the Command...
--
Executing the Command...
---
Upgrading node...
-
Updating node...
-
Registering the plugins...
-
Starting the service...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Removing Reporting Service...
-
Removing Dashboards Service...
-

******************************************************************************************************
Post-Installation Summary - Step 8 of 8
******************************************************************************************************
Upgrade Status SUCCESS

The Informatica 10.1.1 Hotfix 2 installation is complete.

The system services are disabled by default after the installation is complete.
You must configure the services and then enable them in the Informatica Administrator tool.

For more information, see the debug log file:
/dev/informatica/10.1.1/Informatica_10.1.1_HotFix_2_Services_Upgrade_2018_07_12_20_12_34.log

For more information about the upgrade, see the debug log file:
/dev/informatica/10.1.1/logs/upgrade.log

Installation Type :Upgrade


Informatica Administrator Home Page::
http://devnode1.com:6101

Product Name:  Informatica 10.1.1 Hotfix 2 services


Press to continue ...

Pre Requisite’s for Informatica 10.1.1 HF2 Upgrade from 9.6.1



Pre Requisite’s for Informatica 10.1.1 HF2 Upgrade from 9.6.1



Pre Requisite’s                
1.          Operating system patches and libraries compatible with Informatica 10(RHEL 7 compatible to Informatica 10)
2.          Hardware requirement check (use lscpu, uname -a ,uname -p) command to check
3.          Review the environment variables.(Oracle Home path, Installation directory path, Java Home)
4.          Extract the installer files and provide full privilege
5.          Run the pre-installation (i10Pi) system check tool (on all users domain ,repo)
6.          Installation of Java Developer Kit when you upgrade Informatica 10 on zLinux.
7.          Verify that the operating system meets the file descriptor requirement (ulimit -a)
8.          Back up the Power Center repository.
9.          Verify the user account permissions for the database(Domain user account, Repository user)
10.       Back up any reference data directory at a non-default location in the PowerCenter directory structure.
11.       Record the ODBC data source names of the ODBC connections in the domain.
12.       Verify user account requirements for the domain configuration repository database
13.       DB Backups Create Ticket to take backups od domain and repos
14.       Infa Backups – Infa admins to take backups of Domain and Repo using script level
15.       Check-DB Refresh Interval on Domain properties.
16.       Storage Backups – Create ticket to Linux / Storage to take backup of Server
17.       Take the backup of 961 folders in unix on all servers
18.       Shut down the domain. To shut down the domain, stop the Informatica service process on each node in the domain
19.       Node Configuration
20.       Naming standards for Node creation
21.       take the backup of node properties
22.       Verify that the locale setting is compatible with the code page for the repository.(ISO WESTERN EUROPEAN)
23.       Check the port number availability using netstat -na|grep "port Num",netstat -tulpn|grep 6005
24.       Set the OPEN_CURSORS parameter to 4000 or higher
25.       Domain Configuration
26.       Domain name should be set
27.       You must shut down the domain before you back up domain and then upgrade the domain
28.       Before you upgrade the domain, you must back up the configuration metadata for the domain.(nodemeta,domains.infa)


Upgradation                     
1.       Informatica10 Software License check
2.       Unix ID creation and connectivity check
3.       Oracle ID Creation and connectivity check
4.       Reviewing the permissions for the Unix users
5.       Review permissions for the oracle users
6.       Oracle client Installation on Centene Development servers
7.       Adding TNS entries and check the DB access from the server level
8.       Copying Informatica software to all the Centene Development servers
9.       Unzip the software and provide privileges on the folder
10.    testing the Informatica jobs on new Sen
11.    provide permissions for the installation folder
12.    Verify the DB User   having all permissions on the DB level
13.    Check the users connectivity Domain user and Repository User
14.    Cross check the naming convention of Domain, repository, IS ,Web services, Node
15.    Informatica 10.x can be upgrade with our current version 9.6.1 HF4
16.    Review the environment variables
17.    Create a New Informatica 10 Installation directory provide full privileges to the folder
18.    login to the same machine with same  Unix user which we have installed previous 9.6 Informatica version
19.    Stop all process that are running on the server
20.    go to installation file click on ./install.sh
21.    Press 1 to Install or Upgrade Informatica
22.    Press 3 to run Informatica installation services
23.    Press y to continue the installation
24.    Press 2 to upgrade Informatica 10.x
25.    enter 1 to use the same node configuration
26.    Installer displays warning to shut down the previous domain click on enter
27.    enter the directory key for encryption of domain
28.    Review the Information of Informatica 10.x upgrade click on enter
29.    check the Installation log and domain log in case of any errors
30.    Review the maximum heap size setting.

Admin Level Testing                         
1.  Create test wfs (Admin Level)
2.  Create sample connections  (Admin Level)
3.  Execute test wfs  (Admin Level)

Wednesday, October 25, 2017

How to Enable HTTPS on PowerCenter Admin Console

How to Enable HTTPS on PowerCenter Admin Console

  
11.   Generate a keystore file.

Provide valid values for CN, OU, O, L, S, C when prompted. The value for CN is the host name of the server where PowerCenter is installed. It can be a fully qualified name or just the host name depending on how you access the Administration Console.

[infadev@infadev 9.6.1]$ cd /sbx/informatica/9.6.1/java/jre/bin
[infadev@infadev bin]$ keytool -genkey -alias tomcat -keyalg RSA -keysize 2048 -validity 1000 -keystore tomcat.keystore
Enter keystore password:
Re-enter new password:
What is your first and last name?
  [Unknown]:  Infa
What is the name of your organizational unit?
  [Unknown]:  Infa
What is the name of your organization?
  [Unknown]:  Infa
What is the name of your City or Locality?
  [Unknown]:  Infa
What is the name of your State or Province?
  [Unknown]:  CA
What is the two-letter country code for this unit?
  [Unknown]:  US
Is CN=Infa, OU=Infa, O=Infa, L=Infa, ST=CA, C=US correct?
  [no]:  Y

Enter key password for
        (RETURN if same as keystore password):
Re-enter new password:
[infadev@infadev bin]$

[infadev@infadev bin]$ ls -ltr tomcat*
-rw-rw-r-- 1 infadev uxa_info_sbx_adm_l 2201 Oct 23 16:39 tomcat.keystore
[infadev@infadev bin]$


22.   View the contents of the keystore:


[infadev@infadev bin]$ keytool -list -v -alias tomcat -keystore tomcat.keystore
Enter keystore password:
Alias name: tomcat
Creation date: Oct 23, 2017
Entry type: PrivateKeyEntry
Certificate chain length: 1
Certificate[1]:
Owner: CN=Infa, OU=Infa, O=Infa, L=Infa, ST=CA, C=US
Issuer: CN=Infa, OU=Infa, O=Infa, L=Infa, ST=CA, C=US
Serial number: 111ef740
Valid from: Mon Oct 23 16:39:26 CDT 2017 until: Sun Jul 19 16:39:26 CDT 2020
Certificate fingerprints:
        
         Version: 3

Extensions:

#1: ObjectId: 2.5.29.14 Criticality=false
SubjectKeyIdentifier [
KeyIdentifier [
]
]


33.  Self-signed Certificate

Generate a self-signed certificate using the MD5 algorithm and add it to the keystore. (Note: Enter the password which was provided in step 1 when prompted)


[infadev@infadev bin]$ keytool -selfcert -alias  tomcat -sigalg "SHA256withRSA" -keypass Changeme1 -storepass Changeme1 -validity 365 -dname "CN=Infa, OU=Infa, O=Infa, L=Infa, ST=CA, C=US" -keystore tomcat.keystore


44.  View the contents of the keystore:



[infadev@infadev bin]$ keytool -list -v -alias tomcat -keystore tomcat.keystore
Enter keystore password:
Alias name: tomcat
Creation date: Oct 23, 2017
Entry type: PrivateKeyEntry
Certificate chain length: 1
Certificate[1]:
Owner: CN=Infa, OU=Infa, O=Infa, L=Infa, ST=CA, C=US
Issuer: CN=Infa, OU=Infa, O=Infa, L=Infa, ST=CA, C=US
Serial number: 32bc32f8
Valid from: Mon Oct 23 16:47:09 CDT 2017 until: Tue Oct 23 16:47:09 CDT 2018
Certificate fingerprints:
         Version: 3

Extensions:

]
]


Step 5 : Copy the generated keystore file to the INFA_HOME/tomcat/conf directory on the server.

Step 6: Shut down the node process by running infaservice.sh shutdown.

Step 7: CD to the INFA_HOME/server directory, and run the updateGatewayNode command. Please take a backup of the INFA_HOME/isp/config/nodemeta.xml file before running this command.

./infasetup.sh updategatewaynode -da DBHost:1521 -du INFDOM -dp dbpwd -ds infapp -dn Domain_dev -hs 8443 -kf /sbx/informatica/9.6.1/tomcat/conf/tomcat.keystore -kp Changeme1


Step 8: Start Node

Step 9: Log into Admin Console with host:port address -  The page should redirect to the HTTPS URL.


Saturday, September 16, 2017

B2B DX Truncate Events Command


B2B DX Truncate Events Command



infa/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>./repoutil.sh -c truncateEvents -l "jdbc:informatica:oracle://oracdevinfa:1521;Servicename=infa" -u B2BDX -p password -t dx
19:09:18 INFO  Default system locale: English
Are you sure you want to truncate 'events' from the repository, as well as the document store (YES/NO)? YES
19:09:32 INFO  Executing command [TruncateEventsAction]
19:09:32 INFO  Found version [9.6.1.0 - 620] for [DX_REPOSITORY]
19:09:33 INFO  Truncating table: EVENT
19:09:34 INFO  Truncating table: DX_EVENT_BLOBS
19:09:35 INFO  Truncating table: DX_DOCSTORE_FILES
19:09:35 INFO  Truncating table: DX_DOCSTORE_HISTORY
19:09:35 INFO  Truncating table: MONITOR_USER_EVENT
19:09:35 INFO  Truncating table: EVENT_HISTORY
19:09:36 INFO  Truncating table: EVENT_EVENT_PROPERTIES
19:09:36 INFO  Truncating table: DX_CORRELATION
19:09:36 INFO  Truncating table: DX_CORRELATION
19:09:36 INFO  Truncating table: DX_SAVEPOINT
19:09:37 INFO  Truncating table: DX_SAVEPOINT_PROPERTIES
19:09:37 INFO  Truncating table: DX_EVENT_EXTENSIONS
19:09:37 INFO  Truncating table: DX_EVENT_EXTENSIONS
19:09:37 INFO  Truncating table: DX_EVENT_EXTENSIONS
19:09:37 INFO  Truncating table: DX_SUBSCRIPTION_EXT_LIST
19:09:38 INFO  Cleaning document store located at: /b2bprdshr/B2BDataExchange901
19:09:38 INFO  Finished command [TruncateEventsAction]
infa/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>

B2B DX Pre-Installations and Challenges



B2B DX Pre-Installations and Challenges



Hi Friends,
Below are few challanges which you can come across when you go for DX Upgrade.


1. Multiple Java Path Issues

Make sure to set or execute these commands before you start installation in case if you have multiple Java installations on your Server.

export PATH=$INFA_HOME/java/jre/bin:$PATH
export LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/sparcv9/jli:$LD_LIBRARY_PATH
export JAVA_HOME=/infa/informatica/PowerCenter9.6.1/java


2. Try to connect and recheck for any issues

infa/infaabc/softwares/B2BDataExchange9.6.1>>pmrep connect -r rs_stg_repo -d  domain_abc -n Administrator -x password

3. Recheck JVMClassPath


infa/infa/informatica/PowerCenter/isp/bin>>./infacmd.sh getServiceProcessOption -dn domain_stg -un Administrator -pd pwd -sn is_stg_abc1 -nn stg_node -op JVMClassPath

/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/dx-iface-api-8.6-9.0.1.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/dx-iface-api-8.6.1-9.0.1.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/dx-client-powercenter-9.1.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/activemq-all-5.4.2-fuse-02-00.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/dx-client-powercenter-9.5.1.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/commons-logging-1.1.1.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/log4j-1.2.16.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/activemq-all-5.5.1-fuse-02-02.jar:/infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/lib/slf4j-log4j12-1.5.11.jar
Command ran successfully.

B2B DataExchange Upgrade from 9.1.0 to 9.5.1


Informatica B2B DataExchange Upgrade Steps from 9.1.0 to 9.5.1



/softwares/B2BDataExchange9.5.1/Solaris_sparc>>./Install.bin -i console
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...

Launching installer...

===============================================================================
                                                 (created with InstallAnywhere)
-------------------------------------------------------------------------------

Preparing CONSOLE Mode Installation...




===============================================================================
Introduction
------------

This installer will guide you through the installation of B2B Data Exchange
9.5.1.

It is strongly recommended that you quit all programs before you continue with
this installation.

In this and all succeeding screens, respond to each prompt to proceed to the
next step, type Back to make changes to the previous entry, type Quit to cancel
the installation at any time.

PRESS TO CONTINUE:



===============================================================================
Install or Upgrade
------------------

Select whether to install B2B Data Exchange 9.5.1 and any of its components, or to upgrade an existing installation. You can upgrade from version 9.1 or 9.5 to 9.5.1.
If you select to add components or to upgrade B2B Data Exchange, stop all B2B Data Exchange services before you continue.

  ->1- Install B2B Data Exchange 9.5.1 or any of its components
    2- Upgrade to B2B Data Exchange 9.5.1

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 2




===============================================================================
Installation Directory
----------------------

Enter the installation directory:

  Default Install Folder: /infa/informatica/B2BDataExchange9.0.1

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
      :



===============================================================================
Installation Components
-----------------------

Select the components to install.

Select B2B Data Exchange to install the B2B Data Exchange application.
Select B2B Data Exchange Dashboard and Reports to install this component on the
machine hosting B2B Data Exchange server. The B2B Data Exchange Dashboard and
Reports component supports only Oracle databases.
Select Data Exchange server plug-in for PowerCenter to install the Data
Exchange server plug-in on the machine hosting the PowerCenter services. This
option also configures the PowerCenter services to work with B2B Data Exchange.
Register the server plug-in to a PowerCenter Repository Service after
installation.
Select B2B Managed File Transfer to install this component on the machine
hosting B2B Data Exchange server.


  ->1- B2B Data Exchange
    2- B2B Data Exchange Dashboard and Reports
  ->3- Data Exchange server plug-in for PowerCenter
  ->4- B2B Managed File Transfer

ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
   PRESS TO ACCEPT THE DEFAULT:



===============================================================================
Configure Database
------------------

The installer can create a B2B Data Exchange 9.5.1 repository or use an existing B2B Data Exchange 9.5.1 repository. If you use an existing repository, all data in the repository will be preserved and all user accounts will remain valid in the new installation.


  ->1- Create a B2B Data Exchange repository
    2- Use an existing B2B Data Exchange repository

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 2




===============================================================================
Database Connection
-------------------

Enter the database connection details below.


Enter database type:

  ->1- Oracle
    2- SQLServer

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT::




===============================================================================


Enter database connection type:

    1- Database URL
  ->2- Custom connection string

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT::




===============================================================================




Enter custom JDBC connection string (DEFAULT:
   jdbc:informatica:oracle://oracdev:1521;Servicename=infa;):




===============================================================================




Enter database user ID (DEFAULT: B2BDX):




===============================================================================



Enter database user password:



===============================================================================
Web Server
----------

Specify Web Server (Tomcat) port numbers and HTTPS settings.

In case both HTTP and HTTPS ports are selected, HTTPS will always be used and HTTP request will be redirected to HTTPS.

    1- Enable HTTPS
  ->2- Enable HTTP

ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
   PRESS TO ACCEPT THE DEFAULT:




===============================================================================




HTTP connector port number (DEFAULT: 18080):




===============================================================================




Web server shutdown listener port number (DEFAULT: 18005):




===============================================================================
Port Number
-----------

Specify the JMX listener port number for the B2B Data Exchange JMS Broker.

JMX listener port number (DEFAULT: 18098):




===============================================================================
PowerCenter Directory
---------------------

Set up the PowerCenter domain information in Data Exchange.

Enter the PowerCenter directory.

PowerCenter directory (DEFAULT: /infa/informatica/PowerCenter9.6.1):




===============================================================================
PowerCenter Web Services Hub
----------------------------

Specify whether to connect to PowerCenter Web Services Hub.

  ->1- Connect Web Services Hub
    2- Skip Web Services Hub

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT::




===============================================================================
PowerCenter WebServices URL
---------------------------

Specify the PowerCenter WebServices URL.

WebServices URL (DEFAULT: http://infa:7600/wsh):




===============================================================================
PowerCenter Repository Service
------------------------------

Specify the PowerCenter Repository service to use for the Data Exchange workflow.


Repository Service (DEFAULT: rs_stg_repo):




===============================================================================




Repository user name (DEFAULT: Administrator):




===============================================================================



Repository password::



===============================================================================
PowerCenter Domain
------------------

Specify the PowerCenter domain.

Domain name: domain_stg


PRESS TO CONTINUE:



===============================================================================




Node name (DEFAULT: stg_node1):




===============================================================================
PowerCenter Domain
------------------

Specify the PowerCenter administrator user account.

User name (DEFAULT: Administrator):




===============================================================================



Password::



===============================================================================
PowerCenter Integration Service
-------------------------------

Integration Service name: is_stg_bbb


PRESS TO CONTINUE:



===============================================================================
Pre-Installation Summary
------------------------

Review the following installation information before continue:

Product Name:
    B2B Data Exchange

Install Folder:
    /infa/informatica/B2BDataExchange9.0.1

Installation Components:
    B2B Data Exchange
    Data Exchange server plug-in for PowerCenter
    B2B Managed File Transfer

Disk Space Information (for installation Target):
    Required:  799,022,409 bytes
    Available: 31,568,395,264 bytes

PRESS TO CONTINUE:




===============================================================================
Installing...
-------------

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



===============================================================================
Post-Installation Actions
-------------------------

Use the PowerCenter Administration Console to unregister and register the Data
Exchange plug-in to the Repository Service. The Data Exchange plug-in file is /
infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/pluginN>/dxplugin.xml.
You must restart the Repository Service and the Integration Service after
registering the Data Exchange plug-in.

PRESS TO CONTINUE:



===============================================================================
Installation Complete
---------------------

B2B Data Exchange 9.5.1 has been successfully installed in the following
directory:

    /infa/informatica/B2BDataExchange9.0.1

PRESS TO EXIT THE INSTALLER:





Register Plugin:


/infa/informatica/B2BDataExchange9.0.1/DataExchange>>pmrep registerplugin -i /infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/plugin951/dxplugin.xml -e -N


 [08/21/2017 14:17:57-The requested resilience timeout of 180 second(s) exceeded the Repository Service [rs_stg_repo] limit on resilience timeouts. The new resilience timeout is 0 second(s).]
Register Plug-in operation on repository [rs_stg_repo] started at 08/21/2017 14:18:00.

Importing plugin: DX ...
Importing template: DX Add Document To Event ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Aggregate ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Complete Correlation ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Create Event ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Event Attribute ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Event Details ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Generate Temporary File ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Get Document File Path ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Increment Profile Parameter ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Initiate Correlation ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Release Delayed Events ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Resolve Profile ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Throw Error ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Profile Parameters ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...

Post validation on imported plug-ins...
The number of plug-ins that registered successfully is 1.
The number of plug-ins that failed to register is 0.
Register Plug-in operation on repository [rs_stg_repo] ended at 08/21/2017 14:18:03. Elapsed time is 0:00:03.
registerplugin completed successfully.


Completed at Mon Aug 21 14:18:07 2017



verifyContents 


/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>./repoutil.sh -c verifyContents -l "jdbc:informatica:oracle://oracdev:1521;Servicename=infa" --authMode Native -u B2BDX -p password
14:19:19 INFO  Executing DX Repository command [VerifyContentAction]
14:19:19 INFO  Found DX Repository version [9.5.1.0 - 220]
14:19:19 INFO  Executing rule [Event Associations]...
14:19:19 INFO  Executing rule [Event History Associations]...
14:19:19 INFO  Executing rule [Event Type Privilege Association]...
14:19:19 INFO  Executing rule [Profile Associations]...
14:19:19 INFO  Executing rule [Account Number Uniqueness]...
14:19:19 INFO  Executing rule [Object Names Lower Case Unique]...
14:19:19 INFO  Executing rule [Partner/Profile Have Account]...
14:19:19 INFO  Executing rule [Profile Event Attributes match Flow Template Event Attributes]...
14:19:19 INFO  Executing rule [Schedule Cron Expression Verification]...
14:19:19 INFO  Executing rule [User Login Names Lower Case Unique]...
14:19:19 INFO  Finished DX Repository command [VerifyContentAction]
::/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>