1 Reply Latest reply on Jan 21, 2017 10:42 AM by nheinze

    Workflows which make use of DB2 connections

    New Member

      Hi Team,

       

      We do have lot of folders in Informatica . Each folder contains many workflows.

       

      My task is to find out which workflows make use of DB2 connections.

       

      How could this be done , as I told there are lot many folders with many workflows.

       

      Can this be done with Metadata / OPB tables something. If you guys are aware of it. Please help me about it with the steps. Please.

       

       

      Thanks,

      Praveena A

        • 1. Re: Workflows which make use of DB2 connections
          Guru

          For PowerCenter the answer is: you may be able to find out what connection type is defined for each source / target / lookup (via the view REP_SESSION_CNXS), but you cannot find out for sure whether these connections have indeed been used when the sessions ran. The point is that defined connections are one thing but that connections can also be set as session parameters via a parameter file; and the fact which real connection a session parameter was used for any particular mapping execution can only be found in the workflow / session log files, nowhere else.

           

          About IDQ I cannot tell, I don't know whether session connections (do they exist in IDQ?) can be parameterised.

          No matter whether this works or not, if there's no Metadata Exchange view for IDQ which shows the connection, you can still export all affected IDQ workflows to XML files and parse these files. Please don't ask me what to parse for, no idea.

           

          Regards,

          Nico