1.19 Client Tools

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, […]

4.8 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 […]

3.17 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 […]