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>>


B2B DataExchange Upgrade from 9.0.1 to 9.1.0


Informatica B2B DataExchange Upgrade Steps from 9.0.1 to 9.1.0



/softwares/B2BDataExchange9.1.0/B2BDataExchange91/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...

Preparing CONSOLE Mode Installation...

===============================================================================
                                  (created with InstallAnywhere by Macrovision)
-------------------------------------------------------------------------------




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

This installer will guide you through the installation of B2B Data Exchange
9.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.1 and any of its components, or to upgrade an existing installation. You can upgrade from version 8.6.x or 9.0 to 9.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.1 or any of its components
    2- Upgrade to B2B Data Exchange 9.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 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- Data Exchange server plug-in for PowerCenter
  ->3- 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.1 repository or use an existing B2B Data Exchange 9.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:
   : 2




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




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




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




Enter database user ID (DEFAULT: DX_UPGRADE):




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



Enter database user password:*b2bdx*



===============================================================================
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 port number for JMS message Broker (FUSE).

FUSE 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/PowerCenter8.6.1)
   : /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://hostname: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_b2b


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:  707,656,699 bytes
    Available: 34,486,119,424 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.1 has been successfully installed in the following
directory:

    /infa/informatica/B2BDataExchange9.0.1

PRESS TO EXIT THE INSTALLER:







Register Plugin:

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


Invoked at Mon Aug 21 10:17:09 2017

 [08/21/2017 10:17:09-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 10:17:13.

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 10:17:14. Elapsed time is 0:00:01.
registerplugin completed successfully.

Completed at Mon Aug 21 10:17:14 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
10:27:53 INFO  Executing DX Repository command [VerifyContentAction]
10:27:53 INFO  Found DX Repository version [9.0.2.0 - 1600]
10:27:53 INFO  Executing rule [Event Associations]...
10:27:54 INFO  Executing rule [Event History Associations]...
10:27:54 INFO  Executing rule [Event Type Privilege Association]...
10:27:54 INFO  Executing rule [Profile Associations]...
10:27:54 INFO  Executing rule [Account Number Uniqueness]...
10:27:54 INFO  Executing rule [Object Names Lower Case Unique]...
10:27:54 INFO  Executing rule [Partner/Profile Have Account]...
10:27:54 INFO  Executing rule [Profile Event Attributes match Flow Template Event Attributes]...
10:27:54 INFO  Executing rule [Schedule Cron Expression Verification]...
10:27:54 INFO  Executing rule [User Login Names Lower Case Unique]...
10:27:54 INFO  Finished DX Repository command [VerifyContentAction]




B2B DataExchange Upgrade from 9.5.1 to 9.6.1


Informatica B2B DataExchange Upgrade Steps from 9.5.1 to 9.6.1




infa/infaabc/softwares/B2BDataExchange9.6.1>>./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
------------

The installer will guide you through the installation of B2B Data Exchange
9.6.1 HF1.

It is strongly recommended that you close all programs before you continue with
the installation.

In all installation stages, respond to each prompt to proceed to the next step,
type Back to make changes to the previous stage, or type Quit to cancel the
installation at any time.



PRESS TO CONTINUE:



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

Select whether to install B2B Data Exchange 9.6.1 HF1 and any of its
components, or to upgrade an existing installation. You can upgrade from
version 9.5, 9.5.1, or 9.6.1 to version 9.6.1 HF1.
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.6.1 HF1 or any of the installation components
    2- Upgrade to B2B Data Exchange 9.6.1 HF1

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




===============================================================================
PowerCenter Version
-------------------

Select the PowerCenter version for which B2B Data Exchange should be installed.


  ->1- PowerCenter version 9.6 and above
    2- PowerCenter version earlier than 9.6

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



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

Enter the installation directory:

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

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
      : /infa/informatica/B2BDataExchange9.0.1

INSTALL FOLDER IS: /infa/informatica/B2BDataExchange9.0.1
   IS THIS CORRECT? (Y/N): Y



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

Select components to install.

- B2B Data Exchange. B2B Data Exchange application.
- Partners Portal. Partners Portal application.
- Dashboard and Reports. Installed on the machine hosting the B2B Data Exchange
server.
- Server plug-in for PowerCenter. Installed on the machine hosting the
PowerCenter services.
- Managed File Transfer. Installed on the machine hosting the B2B Data Exchange
server.


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

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



===============================================================================
Metadata Repository
-------------------

The installer can create a B2B Data Exchange 9.6.1 HF1 repository or use an
existing repository. All data in the repository will be preserved and all user
accounts will remain valid in the new installation.
If you upgrade and select to use an existing repository from an earlier B2B
Data Exchange version, the installer will upgrade the repository to version
9.6.1 HF1.

  ->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




===============================================================================
Metadata Repository Connection
------------------------------

The repository you specify will store information about Operation Console
objects.

Enter the database type:

  ->1- Oracle
    2- SQLServer

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




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


Enter the database connection type:

  ->1- Database URL
    2- Custom connection string

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




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



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




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



Enter the database username (DEFAULT: B2BDX):




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



Enter the database user password:



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

Specify the Web Server (Tomcat) port numbers and connection details.

If you select HTTP and HTTPS ports, HTTPS will always be used and HTTP requests
will be redirected to the HTTPS port.

  ->1- Enable HTTPS
  ->2- Enable HTTP

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




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



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
---------------------

Define the PowerCenter domain information in Data Exchange.

Enter the PowerCenter directory.

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




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

Choose whether to connect to the PowerCenter Web Services Hub or skip this
step.

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

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




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

Specify the PowerCenter Web Services Hub URL.

Web Services Hub URL (DEFAULT: http://infa:7600/wsh):




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

Specify the PowerCenter Repository Service to use for the Data Exchange
workflows.


Repository Service name (DEFAULT: rs_stg_repo):




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

Specify the PowerCenter Repository Node host to use for B2B Data Exchange
workflows.

Node host: stg_node1



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

Specify the PowerCenter Repository Node port to use for B2B Data Exchange
workflows.

Node port: 6305



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



Repository username (DEFAULT: Administrator):




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



Repository password:



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



Repository security domain (optional): Native



===============================================================================
Informatica Domain
------------------

Specify the Informatica domain.

Domain name (DEFAULT: domain_stg):




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



Node name (DEFAULT: stg_node1):




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

Specify the PowerCenter administrator user account.

Username (DEFAULT: Administrator):




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



Password:



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

Specify the PowerCenter Integration Service to run the Data Exchange workflows.

Integration Service name (DEFAULT: is_stg_bbb):




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

Review the following installation information before you continue:

Product Name:
    B2B Data Exchange

Installation Directory:
    /infa/informatica/B2BDataExchange9.0.1

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

Disk Space Information (for installation Target):
    Required:  1,243,351,205 bytes
    Available: 26,645,999,616 bytes

PRESS TO CONTINUE:



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

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



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

The installation of B2B Data Exchange is complete. You must now take the
following steps:

* Use the Administrator tool to unregister and register the B2B Data Exchange
server plug-in for PowerCenter. The B2B Data Exchange plug-in file is located
in the following directory: /infa/informatica/B2BDataExchange9.0.1/DataExcha
nge/powercenter/plugin/dxplugin.xml.
* Restart the following PowerCenter services, in the following order:
* Repository Service
* Integration Service
   * Web Service Hub Service

PRESS TO CONTINUE:



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

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

    /infa/informatica/B2BDataExchange9.0.1

PRESS TO EXIT THE INSTALLER:
You have new mail in /usr/mail/b2buata1
infa/infaabc/softwares/B2BDataExchange9.6.1>>



Register Plugin:


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

Copyright (c) Informatica Corporation 1994 - 2014
All Rights Reserved.
This Software is protected by U.S. Patent Numbers 5,794,246; 6,014,670; 6,016,501; 6,029,178; 6,032,158; 6,035,307; 6,044,374; 6,092,086; 6,208,990; 6,339,775; 6,640,226; 6,789,096; 6,820,077; 6,823,373; 6,850,947; 6,895,471; 7,117,215; 7,162,643; 7,243,110; 7,254,590; 7,281,001; 7,421,458; 7,496,588; 7,523,121; 7,584,422; 7,676,516; 7,720,842; 7,721,270; 7,774,791; 8,065,266; 8,150,803; 8,166,048; 8,166,071; 8,200,622; 8,224,873; 8,271,477; 8,327,419; 8,386,435; 8,392,460; 8,453,159; 8,458,230; and RE44,478, International Patents and other Patents Pending.

Invoked at Mon Aug 21 18:54:55 2017

 [08/21/2017 18:54:56-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 18:54:59.

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 ...
Importing template: DX Notification ...
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 Start Publication ...
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 Publication 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 18:55:01. Elapsed time is 0:00:02.
registerplugin completed successfully.


verifyContents 


infa/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>./repoutil.sh -c verifyContents -t dx
19:07:18 INFO  Default system locale: English
19:07:20 INFO  Executing command [VerifyContentAction]
19:07:20 INFO  Found version [9.6.1.0 - 620] for [DX_REPOSITORY]
19:07:20 INFO  Executing rule [Event Associations]...
19:07:20 INFO  Executing rule [Event History Associations]...
19:07:20 INFO  Executing rule [Event Type Privilege Association]...
19:07:20 INFO  Executing rule [Profile Associations]...
19:07:20 INFO  Executing rule [Account Number Uniqueness]...
19:07:20 INFO  Executing rule [Object Names Lower Case Unique]...
19:07:20 INFO  Executing rule [Partner/Profile Have Account]...
19:07:20 INFO  Executing rule [Profile Event Attributes match Flow Template Event Attributes]...
19:07:20 INFO  Executing rule [Schedule Cron Expression Verification]...
19:07:20 INFO  Executing rule [User Login Names Lower Case Unique]...
19:07:20 INFO  Finished command [VerifyContentAction]

Thursday, February 23, 2017

Tuesday, January 24, 2017

Informatica KT Plan Templat

Hello Friends,

As most of you requested, please find attached KT plan Template for Informatica Admin Role.

https://drive.google.com/open?id=0BxoiTOkq3-YPVjFuZ3NzSzVtazQ

Instillation Guide for Informatica 7.1.1 on Windows



Hello Friends,

Based on requests from few of you, here is the attached Installation Steps for Informatica 7.1.1 on Windows Platform.

https://drive.google.com/open?id=0BxoiTOkq3-YPVUczUEdCQ1VZRXM


Friday, January 20, 2017

Informatica Metadata Queries - 1 DOMAIN & REPOSITORY



1.1         Check Master Domain Election of Node (on Multi Node Setup)


Select * from ISP_MASTER_ELECT_LOCK

1.2         Check Master Selection of Host, Node and Port Details (Domain tables)


Select * from ISP_MASTER_ELECTION  


1.3         Repository Information


SELECT PCSF_DOMAIN AS DOMAIN, REPOSITORY_NAME, DB_USER FROM OPB_REPOSIT_INFO

1.4         List Service Names, Grid, License Name and Service Type (Domain tables)


SELECT
PSD_DISCRIMINATOR AS SERVICE_TYPE,
POS_NAME AS SERVICE_NAME,
POD_GRIDNAME AS GRIDNAME,
POD_LICENSENAME AS LICENSENAME,
POD_SERVICETYPE AS SERVICETYPE,
POD_SERVICEVERSION AS SERVICEVERSION
FROM PO_DOMAINOBJ
ORDER BY 1,2

  

1.5         List of “Not Valid” objects in a Repository


SELECT REPOSITORY,FOLDER_NAME,WORKFLOW_OR_WORKLET,TASK_TYPE,    WORKLET_OR_SESSION,IS_VALID
FROM
(SELECT DISTINCT         
OPB_REPOSIT_INFO.REPOSITORY_NAME AS REPOSITORY,
OPB_SUBJECT.SUBJ_NAME AS FOLDER_NAME, OPB_TASK.TASK_NAME AS WORKFLOW_OR_WORKLET,
DECODE(OPB_TASK_INST.TASK_TYPE,58,'COMMAND',59,'DECISION',60,'EVENT WAIT',62,'START',65,'EMAIL',66,'TIMER',67,'ASSIGNMENT',68,'SESSION',70,'WORKLET',91,'CONTROL',NULL) TASK_TYPE,
OPB_TASK_INST.INSTANCE_NAME AS WORKLET_OR_SESSION,
DECODE (OPB_TASK_INST.IS_VALID,1,'VALID','NOT VALID') AS IS_VALID
FROM OPB_TASK_INST,OPB_OBJECT_TYPE,OPB_TASK,OPB_SUBJECT,OPB_REPOSIT_INFO
WHERE OPB_TASK_INST.TASK_TYPE != 62
AND OPB_TASK_INST.TASK_TYPE = OPB_OBJECT_TYPE.OBJECT_TYPE_ID
AND OPB_TASK_INST.WORKFLOW_ID = OPB_TASK.TASK_ID
AND OPB_TASK_INST.VERSION_NUMBER = OPB_TASK.VERSION_NUMBER
AND OPB_TASK.SUBJECT_ID = OPB_SUBJECT.SUBJ_ID
AND OPB_TASK.UTC_CHECKIN <> 0  )
WHERE IS_VALID = 'NOT VALID'
ORDER BY 2,3

1.6         Check Reposit DB User and Type



SELECT
REPOSITORY_ID,
REPOSITORY_NAME,
DATABASE_USER,
DECODE (REPOSITORY_TYPE,1,'GLOBAL',2,'STANDALONE',3,'LOCAL') REPOSITORY_TYPE
FROM
REP_REPOSIT_INFO
order by 2

1.7         List where all a table is used


Sometimes you want to know if certain tables are listed in sql overrides of Source Qualifier or Lookup transformation. This helps you identifying dependencies. The query below will list folder, attribute type and sql override as output.

SELECT DISTINCT REP_ALL_MAPPINGS.SUBJECT_AREA, REP_ALL_MAPPINGS.MAPPING_NAME,REP_WIDGET_ATTR.ATTR_NAME, REP_WIDGET_ATTR.ATTR_VALUE
FROM REP_WIDGET_ATTR, REP_WIDGET_INST, REP_ALL_MAPPINGS
WHERE REP_WIDGET_ATTR.WIDGET_ID = REP_WIDGET_INST.WIDGET_ID
AND REP_WIDGET_INST.MAPPING_ID = REP_ALL_MAPPINGS.MAPPING_ID
AND REP_WIDGET_ATTR.WIDGET_TYPE IN (3,11)
AND REP_WIDGET_ATTR.ATTR_ID = 1
AND REP_WIDGET_ATTR.ATTR_VALUE LIKE '%' || REPLACE('TABLE_NAME', '_', '/_') || '%' ESCAPE '/'
ORDER BY 1,2,3

1.8         List of all Jobs which are failed in last 5 days



SELECT Subject_Area AS Folder,
Session_Name,
Last_Error AS Error_Message,
DECODE (Run_Status_Code,3,'Failed',4,'Stopped',5,'Aborted') AS Status,
Actual_Start AS Start_Time,
Session_TimeStamp
FROM rep_sess_log
WHERE run_status_code != 1
AND TRUNC(Actual_Start) BETWEEN TRUNC(SYSDATE -5) AND TRUNC(SYSDATE)
order by 1,2


1.9         List All Integration Service Names available in Repository


SELECT Domain_Name,Server_Name as IntegrationService_Name FROM OPB_SERVER_INFO
order by 2

1.10      List comments of all objects


SELECT
B.SUBJECT_AREA AS FOLDER_NAME, A.OBJECT_NAME,A.COMMENTS,  A.VERSION_NUMBER
FROM
REP_VERSION_PROPS A, REP_SUBJECT B
WHERE B.SUBJECT_ID = A.SUBJECT_ID
AND A.COMMENTS IS NOT NULL
ORDER BY 1,2

1.11      List of Database used in Repository


The database definition view provides a list of all database definitions in the repository. A database definition includes the source database names, flat file or RDBMS, and the folder where the database definition resides.


select subject_area,database_name,def_source from REP_DATABASE_DEFS
order by 1,2,3

1.12      Query to check timestamp of objects last saved by user


SELECT
CASE
WHEN opb_version_props.object_type = 1 THEN 'Source Definition'                                 ELSE CASE
WHEN opb_version_props.object_type = 2 THEN 'Target Definition'                                   ELSE CASE
WHEN opb_version_props.object_type = 3 THEN 'Source Qualifier'                                    ELSE CASE
WHEN opb_version_props.object_type = 4 THEN 'Update Strategy'                                    ELSE CASE
WHEN opb_version_props.object_type = 5 THEN 'Expression'                                            ELSE CASE
WHEN opb_version_props.object_type = 6 THEN 'Stored Procedure'                                ELSE CASE
WHEN opb_version_props.object_type = 7 THEN 'Sequence'                           ELSE CASE
WHEN opb_version_props.object_type = 8 THEN 'External Procedure'                              ELSE CASE
WHEN opb_version_props.object_type = 9 THEN 'Aggregator'                                           ELSE CASE
WHEN opb_version_props.object_type = 10 THEN 'Filter'                                                                          ELSE CASE
WHEN opb_version_props.object_type = 11 THEN 'Lookup Procedure'                            ELSE CASE
WHEN opb_version_props.object_type = 12 THEN 'Joiner'                                                          ELSE CASE
WHEN opb_version_props.object_type = 13 THEN 'Procedure'                                                ELSE CASE
WHEN opb_version_props.object_type = 14 THEN 'Normalizer'                                               ELSE CASE
WHEN opb_version_props.object_type = 16 THEN 'Merger'                                                        ELSE CASE
WHEN opb_version_props.object_type = 17 THEN 'Pivot'                                                             ELSE CASE
WHEN opb_version_props.object_type = 18 THEN 'Session Obsolete'                                ELSE CASE
WHEN opb_version_props.object_type = 19 THEN 'Batch'                                                           ELSE CASE
WHEN opb_version_props.object_type = 20 THEN 'Shortcut'                             ELSE CASE
WHEN opb_version_props.object_type = 21 THEN 'Mapping'                             ELSE CASE
WHEN opb_version_props.object_type = 26 THEN 'Rank'                                                              ELSE CASE
WHEN opb_version_props.object_type = 27 THEN 'Star Schema'                                            ELSE CASE
WHEN opb_version_props.object_type = 28 THEN 'Folder Version'                                       ELSE CASE
WHEN opb_version_props.object_type = 29 THEN 'Folder'                                                          ELSE CASE
WHEN opb_version_props.object_type = 30 THEN 'Cube'                                                             ELSE CASE
WHEN opb_version_props.object_type = 31 THEN 'Dimension'                                                ELSE CASE
WHEN opb_version_props.object_type = 32 THEN 'Level'                                                            ELSE CASE
WHEN opb_version_props.object_type = 33 THEN 'Hierarchy'                                                  ELSE CASE
WHEN opb_version_props.object_type = 34 THEN 'Fact Table'                                                 ELSE CASE
WHEN opb_version_props.object_type = 35 THEN 'General Object'                                    ELSE CASE
WHEN opb_version_props.object_type = 36 THEN 'FTP Object'                                                ELSE CASE
WHEN opb_version_props.object_type = 37 THEN 'Oracle External Loader Object'  ELSE CASE
WHEN opb_version_props.object_type = 38 THEN 'Informix External Loader Object'                       ELSE CASE
WHEN opb_version_props.object_type = 39 THEN 'Sybase IQ External Loader Object'                    ELSE CASE
WHEN opb_version_props.object_type = 54 THEN 'Sybase IQ 12 External Loader Object'            ELSE CASE
WHEN opb_version_props.object_type = 53 THEN 'Tera Data External Loader Object'                    ELSE CASE
WHEN opb_version_props.object_type = 40 THEN 'File Object'                                               ELSE CASE
WHEN opb_version_props.object_type = 41 THEN 'Server Object'                                        ELSE CASE
WHEN opb_version_props.object_type = 42 THEN 'Database Object'                                  ELSE CASE
WHEN opb_version_props.object_type = 43 THEN 'Repository'                                                ELSE CASE
WHEN opb_version_props.object_type = 44 THEN 'Mapplet'                             ELSE CASE
WHEN opb_version_props.object_type = 45 THEN 'Application Source Qualifier'       ELSE CASE
WHEN opb_version_props.object_type = 46 THEN 'Input Transformation'                                               ELSE CASE
WHEN opb_version_props.object_type = 47 THEN 'Output Transformation'                                           ELSE CASE
WHEN opb_version_props.object_type = 50 THEN 'Advanced External Procedure'   ELSE CASE
WHEN opb_version_props.object_type = 48 THEN 'Business Component Framework'                    ELSE CASE
WHEN opb_version_props.object_type = 49 THEN 'Business Component'                                               ELSE CASE
WHEN opb_version_props.object_type = 51 THEN 'SAP Structure'                                       ELSE CASE
WHEN opb_version_props.object_type = 52 THEN 'SAP Function'                                        ELSE CASE
WHEN opb_version_props.object_type = 15 THEN 'Router'                                                        ELSE CASE
WHEN opb_version_props.object_type = 55 THEN 'XML Source Qualifier'                                               ELSE CASE
WHEN opb_version_props.object_type = 56 THEN 'MQ Source Qualifier'                                                 ELSE CASE
WHEN opb_version_props.object_type = 57 THEN 'MQ Connection Object'                                          ELSE CASE
WHEN opb_version_props.object_type = 58 THEN 'Command'                                                ELSE CASE
WHEN opb_version_props.object_type = 59 THEN 'Decision'                            ELSE CASE
WHEN opb_version_props.object_type = 60 THEN 'Event Wait'                                               ELSE CASE
WHEN opb_version_props.object_type = 61 THEN 'Event Raise'                                              ELSE CASE
WHEN opb_version_props.object_type = 62 THEN 'Start'                                                             ELSE CASE
WHEN opb_version_props.object_type = 63 THEN 'Abort'                                                           ELSE CASE
WHEN opb_version_props.object_type = 64 THEN 'Stop'                                                             ELSE CASE
WHEN opb_version_props.object_type = 65 THEN 'Email'                                                           ELSE CASE
WHEN opb_version_props.object_type = 66 THEN 'Timer'                                                          ELSE CASE
WHEN opb_version_props.object_type = 67 THEN 'Assignment'                                             ELSE CASE
WHEN opb_version_props.object_type = 68 THEN 'Session'                                                       ELSE CASE
WHEN opb_version_props.object_type = 69 THEN 'Scheduler'                                                ELSE CASE
WHEN opb_version_props.object_type = 70 THEN 'Worklet'                             ELSE CASE
WHEN opb_version_props.object_type = 71 THEN 'Workflow'                                                 ELSE CASE
WHEN opb_version_props.object_type = 72 THEN 'SessionConfig'                                        ELSE CASE
WHEN opb_version_props.object_type = 73 THEN 'Relational'                                                ELSE CASE
WHEN opb_version_props.object_type = 74 THEN 'Application'                                             ELSE CASE
WHEN opb_version_props.object_type = 75 THEN 'FTP'                                                                ELSE CASE
WHEN opb_version_props.object_type = 76 THEN 'External Loader'                                   ELSE CASE
WHEN opb_version_props.object_type = 77 THEN 'Queue'                                                        ELSE CASE
WHEN opb_version_props.object_type = 78 THEN 'Reader'                                                       ELSE CASE
WHEN opb_version_props.object_type = 79 THEN 'Writer'                                                        ELSE CASE
WHEN opb_version_props.object_type = 80 THEN 'Sorter'                                                         ELSE CASE
WHEN opb_version_props.object_type = 81 THEN 'Vendor'                                                       ELSE CASE
WHEN opb_version_props.object_type = 84 THEN 'App Multi-Group Source Qualifier'                  ELSE CASE
WHEN opb_version_props.object_type = 91 THEN 'Control'                                                      ELSE CASE
WHEN opb_version_props.object_type = 92 THEN 'Transaction Control'                          ELSE CASE
WHEN opb_version_props.object_type = 97 THEN 'Custom Transformation'                                          ELSE CASE
WHEN opb_version_props.object_type = 93 THEN 'Query'                                                          ELSE CASE
WHEN opb_version_props.object_type = 94 THEN 'Deployment Group'                           ELSE CASE
WHEN opb_version_props.object_type = 95 THEN 'Label'                                                           ELSE CASE
WHEN opb_version_props.object_type = 96 THEN 'Deployed Deployment Group'   ELSE CASE
WHEN opb_version_props.object_type = 98 THEN 'Server Grid'                                             ELSE CASE
WHEN opb_version_props.object_type = 99 THEN 'Profiling Ruleset'                                 ELSE CASE
WHEN opb_version_props.object_type = 100 THEN 'Template Extension'                                               ELSE CASE
WHEN opb_version_props.object_type = 101 THEN 'Global Profile Resource'                                      ELSE CASE
WHEN opb_version_props.object_type = 102 THEN 'Web Services Hub'                          ELSE CASE
WHEN opb_version_props.object_type = 103 THEN 'Lookup Extension'                            ELSE CASE
WHEN opb_version_props.object_type = 105 THEN 'Service Level'                                      ELSE CASE
WHEN opb_version_props.object_type = 106 THEN 'User Defined Function' ELSE 'Shortcut'
   END          END               END               END               END               END               END               END               END               END               END               END               END               END               END                        END               END               END               END               END              END               END               END               END               END               END               END               END               END                        END               END               END               END               END               END               END               END               END               END               END               END               END               END                        END               END               END               END               END               END               END               END               END               END               END               END               END               END                        END               END               END               END               END               END               END               END               END               END               END               END               END               END                        END               END               END               END               END               END               END               END               END               END               END               END               END               END                        END               END               END               END               END               END               END

END "OBJECT_TYPE",object_name,
REP_USERS.USER_NAME,
SUBSTR(opb_version_props.LAST_SAVED,1,10) LAST_SAVED
FROM REP_USERS,OPB_VERSION_PROPS,REP_SUBJECT
WHERE REP_USERS.USER_ID=opb_version_props.USER_ID
AND REP_SUBJECT.SUBJECT_ID = opb_version_props.SUBJECT_ID
and REP_USERS.status = 0
and  object_type = 1
ORDER BY 1,2,3,4


1.13      List the name of the object, type, date and last saved


SELECT c.subj_name, a.object_name, b.object_type_name,
         TO_DATE (a.last_saved, 'mm/dd/yyyyHH24:mi:ss') newdate
    FROM opb_version_props a, opb_object_type b, opb_subject c
   WHERE a.object_type = b.object_type_id
     AND a.subject_id = c.subj_id
     AND TO_DATE (a.last_saved, 'mm/dd/yyyyHH24:mi:ss') >
                       TO_DATE ('04/22/2012 00:00:00', 'mm/dd/yyyyHH24:mi:ss')
ORDER BY newdate DESC;

1.14      List Folder,wf,sess,maping,src and trg



SELECT
F.SUBJ_NAME AS FOLDER_NAME,
WF.TASK_NAME AS WORKFLOW_NAME,
SE.INSTANCE_NAME AS SESSION_NAME,
M.MAPPING_NAME,
SRC.INSTANCE_NAME AS SOURCE_NAME,
TGT.INSTANCE_NAME AS TARGET_NAME
FROM
OPB_SUBJECT F,
OPB_TASK WF,
(SELECT
WORKFLOW_ID,
INSTANCE_ID,
TASK_ID,
TASK_TYPE,
INSTANCE_NAME,
MAX(VERSION_NUMBER)
FROM OPB_TASK_INST SESS
WHERE
SESS.TASK_TYPE=68
GROUP BY
WORKFLOW_ID,INSTANCE_ID,TASK_ID,TASK_TYPE,INSTANCE_NAME) SE,
(SELECT SESSION_ID,MAPPING_ID,MAX(VERSION_NUMBER) FROM OPB_SESSION GROUP BY SESSION_ID,MAPPING_ID) S,
OPB_MAPPING M,
(SELECT MAPPING_ID,INSTANCE_NAME ,WIDGET_TYPE,MAX(VERSION_NUMBER) FROM OPB_WIDGET_INST GROUP BY MAPPING_ID,INSTANCE_NAME,WIDGET_TYPE) SRC,
(SELECT MAPPING_ID,INSTANCE_NAME ,WIDGET_TYPE,MAX(VERSION_NUMBER) FROM OPB_WIDGET_INST GROUP BY MAPPING_ID,INSTANCE_NAME,WIDGET_TYPE) TGT
WHERE WF.IS_VISIBLE = 1
AND WF.SUBJECT_ID = F.SUBJ_ID
AND SE.WORKFLOW_ID = WF.TASK_ID
AND WF.TASK_TYPE = 71
AND SE.TASK_ID = S.SESSION_ID
AND S.MAPPING_ID = M.MAPPING_ID
AND M.IS_VISIBLE = 1
AND SRC.MAPPING_ID=M.MAPPING_ID
AND SRC.WIDGET_TYPE=1
AND TGT.MAPPING_ID=M.MAPPING_ID
AND TGT.WIDGET_TYPE=2
AND F.SUBJ_NAME = 'ABC'

1.15      How to Remove Node


Go to the path: 
/opt/infa/svc-ide/Informatica/9.1.0/isp/bin
Execute the command:
./infacmd.sh removeNode

1.16      How to convert binary log to text format


Please use the below command if you need to convert binary session/workflow.. log file to text/XML format for your analysis.
(Since most of the jobs not having write backward compatible option enabled the logs are generated in binary format by default)

Syntax:

Infacmd.sh ConvertLogFile <-inputfile in=""> input_file_name [<-format fm=""> format_TEXT_XML] [<-outputfile lo=""> output_file_name]

Example:

/opt/infa/svc-infa/Informatica/9.1.0/server/bin
infacmd.sh Convertlogfile -in /opt/infa/svc-infa/Informatica/9.1.0/server/infa_shared/Logs/s_m_STG_SAP_PRPS_NA_1_60.log.6.bin -fm text -lo /opt/infa/svc-infa/Informatica/9.1.0/server/infa_shared/Logs/s_m_STG_SAP_PRPS_NA_1_60.log


1.17      PMSTACK


Go to /server/bin directory

2. Run the following command on the core file.

    /tools/debugtools/pmstack -c /server/bin/


1.18      Purging & Archiving DX Events in DX Repository




Proposed Solution:
1. When you run the archive script - based on the condition provided in the purge.xml file - the action takes place.
·   If you have choose both archive and purge =true and  =true - the data is backed up and purged 
·   if you choose - archive and no purge =true and  =false- the data is backed up
·   if you choose-no archive and purge =false and  =true - the data is purged completely from the DX repository.
2. The purge event will not be stored. It is deleting the data completely from the DX repository.
Only if you archive - the data is backed up.

3. 

Archive Rule One
(ALL)
c:\temp\archive\all

10d 0h 0m
true
true
false


When you run the archive script with the above xml - then all teh events which are older than 10 days will be archived (backedup) in the location - c:\temp\archive\all - as a zip file and then those events will be purged from database.



System Events
(SYSTEM)
c:\temp\archive\system
10d 00h 00m
false
true
true



When you run the archive script with the above xml - then all the events which are older than 10 days will be purged from database as you have set the  = false
 

Additional Info: Since you are using PC 9.6.1 - you can use ILM archive method to archive the events - this is faster than script.