Wednesday, April 03, 2013

How to check whether PowerExchange Listener is running or not from PowerExchange Navigator?


It can be checked using DTLREXE utility.

c:\Informatica\PowerExchange9.1.0>dtlrexe loc=MainFrameDEV prog=ping
PWX-00750 DTLREXE Input LOC=MainFrameDEV, PROG=PING, PARMS=, UID=<>.
PWX-33304 10.*.*.*:* : taskid: 0, operation timeout: (none) secs, heartbeat interval: 30 secs
PWX-00755 DTLREXE Command OK!

Pick up the loc from dbmover.cfg.

Labels:

How to get the filename associated with various data maps in mainframe using Informatica PowerExchange?



Create dtlurdmo.ini as follows:-
OUTPUT D:\MY_PWX_SCRIPTS\TGT;
USER mypwxuser;
PWD mypwxpassword;
TARGETUSER mypwxusertgt;
TARGETPWD mypwxpasswordtgt;
SOURCE MVSDEV;
TARGET local;
DETAIL;
VALIDATE;
DM_COPY;

Run it as:-
c:\Informatica\PowerExchange9.1.0>dtlurdmo D:\MY_PWX_SCRIPTS\dtlurdmo.ini

Check Detail.logs in PWX installation directory for the filenames.

Labels: