Wednesday, September 25, 2019

List of users connected to client tools



SELECT c.cnx_id,
  SUBSTR(u.name,1,30),
  SUBSTR(c.login_time,1,20),
  SUBSTR(c.app_name1,1,20),
  SUBSTR(c.host_name,1,25),
  c.host_port
FROM opb_client_conn c,
  opb_user_group u
WHERE c.login_id                                  =u.id
AND to_date(SUBSTR(login_time,1,10),'mm/dd/yyyy')!=trim(sysdate)
AND app_name1 IN ('Designer' ,'Workflow Manager' , 'Workflow Monitor', 'Repository Manager')
ORDER BY Host_name,
  app_name1,
  Login_time;



Wednesday, September 18, 2019

Purging BDM workflows from the workflow database



Please make sure to have proper backups before you work on below commands (safer side), on Informatica BDM this command will help to purge workflow transnational details from workflow database.


Starting from Informatica 10.2 HotFix 1, there is a new command available to delete workflow process data from workflow DB. You can configure the command to delete all of the process data in the workflow database. Or, you can delete the process data that the workflows generated during a time period that you specify.

The pruneOldInstances command deletes process data only. The command does not delete any data that a workflow instance or any object in the workflow reads or writes. Likewise, the command does not delete any workflow object metadata.

To delete the process data, you must have the Manage Service privilege on the domain.

The infacmd wfs pruneOldInstances command uses the following syntax:

pruneOldInstances
<-domainname dn=""> domain_name
<-servicename sn=""> service_name
<-username un=""> user_name
<-password pd=""> password
[<-securitydomain sdn=""> security_domain]
<-days d=""> days
[<-resiliencetimeout re=""> timeout_period_in_seconds]


https://kb.informatica.com/faq/7/Pages/21/560591.aspx



Tuesday, September 17, 2019

Troubleshoot steps when Integration Services are Hung


Troubleshoot steps when Integration Services are Hung

When you are unable to connect Integration Service from client, make sure Integration Service is available in Administrator Console

Login to one of the nodes in the IS grid and try pmcmd connect to Integration Service

pmcmd> connect  -sv   -d -u -p

Please share the output.

Please collect below information:-

1.Stack traces using pmstack on pmserver process

     pmstack -p

pmstack should be available in $INFA_HOME/tools/debugtools/pmstack directory. Refer to KB 13652 for more information.

2.List of open files using lsof on pmserver process

     lsof -p

You need to redirect the output to file as shown below:

     lsof -p 324564 > lsof_324564_1.txt

3.System calls using strace on pmserver process

     strace -ttTfo strace_pmserver.txt -p         (Linux)
     truss -faedEl -o truss_pmrepagent.txt -p     (AIX/Solaris)

You need to end strace manually. Let it run for two minutes and then end it.
Please make sure you run each of above commands minimum four times with an interval of two minutes.
Please note that you cannot run pmstack and strace on a process at the same time. You could run strace between pmstack intervals.

4.Core file using gcore on pmserver process on all the nodes in grid(only once)

     gcore -o pmserver_dump

Informatica support needs libscollector output from pmserver core file and not the actual core file. You could refer KB 144522 to run libscollector. This can be done at the end, once you are done collecting all the details.

You need to run all above commands on all the nodes in the grid.

5.Stack traces on associated Repository Service using pmstack

6.jstack on the node Java process. You need to collect this on all the nodes in the grid.

jstack -l > jstack1.txt

jstack should be available in $INFA_HOME/tools/debugtools/java/bin directory.

You need to run it four times with an interval of one minute.

7.netstat output on all the nodes in the grid

netstat -peano > netstat.out

8.Domain, Repository and Integration Service logs for the day separately.

9.Node logs(catalina.out, exceptions.log, node.log, ispLogs.log , node_jsf.log from $INFA_HOME\logs\ directory) from all the nodes

Wednesday, August 7, 2019

BDM List Workflow Running Processes


BDM List Workflow Running Processes


./infacmd.sh wfs listRunningProcesses -dn DOMAIN -un admin -pd admin -sn DIS_BDMPROD >> listRunningProcesses.txt

BDM - List Active Workflow Instances


List Active Workflow Instances

./infacmd.sh wfs listactiveworkflowinstances -dn DOMAIN -un admin -pd admin -sn DIS_BDMPROD >> listactiveworkflowinstances.txt

BDM Metadata Queries


1.1          Application name and object information

select app_id, app_name,Feature_name from MRX_APP_DETAILS
order by 1,2, 3 asc

1.2          Application summary and path details

select project_name, Parent_Path, App_name from MRX_APP_SUMMARY
order by 1,2,3

1.3          Connections and Connection types

select * from MRX_CONNECTIONS


1.4          Mapping Information

Select project_name,Parent_path,Mapping_name from MRX_MAPPINGS

1.5          List data objects for each mapping.

Select * from MRX_MAP_SRCCNT


1.6          List Project and Objects details.


Select Project_name,object_name,object_path from MRX_OBJECT_SUMMARY


1.7          List Physical Data Objects in a Project


select project_name,Parent_path,PDO_name as "Physical_data_Object" from MRX_PDO 


1.8          List of Application Deployed on DIS.

select dis_name,app_name,design_app_name from MRX_RT_APP_SUMRT
order by 1,2,3


1.9          List source and mapping information

Select  MAPPING_NAME,DOINST_NAME, DATA_OBJECT_NAME, DATA_OBJECT_TYPE from MRX_TX_SOURCES

Friday, June 14, 2019

Informatica PowerExchange 10.2.0 HF2 Installation.


Informatica PowerExchange 10.2.0 HotFix 2 Installation.

Update Environment variables

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin
export JAVA_HOME=/etc/alternatives/jre
export PATH=$PATH:$JAVA_HOME/bin


#Set up the Informatica variables

export PWX_HOME=/pwx/informatica/pwx_1011
export PWX_LICENSE=/pwx/informatica/pwxpub/pwxcdcpub100_linux_x64/license.key
export PWXPUB_HOME=/pwx/informatica/pwxpub/pwxcdcpub100_linux_x64

# Set up the environment variables

export  IATEMPDIR=/home/tmp
export LD_LIBRARY_PATH=$PWX_HOME
export PATH=$PATH:$PWX_HOME:$PWXPUB_HOME/bin



Begin Installation: 


[User@pwxSerever1001]:/pwx/informatica/pwx1020 # ./install.sh


******************************************************************************************************
Welcome - Step 1 of 6
******************************************************************************************************
[ 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. ]

Welcome to the Informatica PowerExchange 10.2.0 HotFix 2 installer.

Copyright (c) 1993-2019 Informatica LLC. All Rights Reserved.
See patents at https://www.informatica.com/legal/patents.html
Press to continue ...


******************************************************************************************************
Enter License Key - Step 2 of 6
******************************************************************************************************
[ 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. ]


Please enter the 44 or 64 character License key(including hyphens) in upper or lower case :Provide Key received by Informatica Vendor.


******************************************************************************************************
Installation Directory - Step 3 of 6
******************************************************************************************************
[ 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. ]


Choose the installation directory (default :- /home/Informatica/PowerExchange10.2.0) :/pwx/informatica/PowerExchange10.2.0


******************************************************************************************************
Pre-Installation Summary - Step 4 of 6
******************************************************************************************************
[ 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 PowerExchange 10.2.0 HotFix 2

Installation Directory   :      /pwx/informatica/PowerExchange10.2.0

Disk Space Requirements

Required Disk Space      :      275 MB

Available Disk Space     :      54,436 MB

Press to continue ...


******************************************************************************************************
Installing - Step 5 of 6
******************************************************************************************************


Installing... 5%

Installing... 20%

Installing... 25%

Installing... 30%

Installing... 35%

Installing... 40%

Installing... 45%

Installing... 55%

Installing... 65%

Installing... 70%

Installing... 75%

Installing... 80%

Installing... 100%

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

Informatica PowerExchange 10.2.0 HotFix 2 installation completed successfully

For more information, see the debug log file:
/pwx/informatica/PowerExchange10.2.0/Informatica_PowerExchange10.2.0_HotFix_2.log

Product Name
Informatica PowerExchange 10.2.0 HotFix 2

Press to continue ...
[user@pwxSerever1001]:/pwx/informatica/pwx1020 #