Focal Point
Run ETLCRTLS from a command prompt

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/134101071

July 03, 2009, 09:35 AM
Pascal Bellerose
Run ETLCRTLS from a command prompt
Hi,

We are running Datamigrator on an ISeries and we have setup some iMonitors that sends us an email when ETLLOG.foc reaches 1,5 Gb.

We'd like to run the recreate procedure (ETLCRTLS.fex) instead of sending an email.

Is it possible to run a fex from a qshell/unix command prompt?

Thanks


WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2
July 03, 2009, 10:38 AM
thenmozhi
hi,

CMRUN command is used to run the flow from command prompt..

iWay communication file (odin.cfg) must be configured for the DataMigrator Server.

CMRUN program is a standalone program for initiating flows. It also allows you to specify values for user-defined variables. CMRUN is provided with DataMigrator for z/OS, most UNIX systems, i5/OS, OpenVMS, and Windows NT/2000/XP. It may be called from an z/OS job stream, a UNIX shell script, or a Windows shortcut or command file.

syntax:

CMRUN Server=server, [User=userid, [Password=password,] [,x=ddname], Request=request [,Appname=appname] [,Wait=minutes] [,I=seconds]
[,V=variable] [,B=begin] [,E=end]
where:

server Is the name of the DataMigrator Server. This value is required.

userid Is a valid user ID for the server.

password Is the password associated with the user ID.

ddname Is the location of the external password.

request Is the name of the flow, up to 32 characters long.

appname Is the application directory where the flow is located.

minutes Is the number of minutes the server waits for a flow to complete. The default is 0, which specifies not to wait.

seconds Is the number of seconds the server waits before checking if the flow has completed. The default is 15 seconds.

variable The syntax for the variable parameter differs for different operating systems:

for unix varible is For Unix:

variable=\"\&\&VAR1=value1, &\&VAR2=value2...\"]

example
-----------
#!/bin/ksh
export EDAHOME=/home/ibi/srv76/home
export EDACONF=/home/ibi/srv76/dm
export SHLIB_PATH=$EDAHOME/bin:/usr/lib:/lib
export EDACS3=$EDACONF/etc/odin.cfg
$EDAHOME/bin/cmrun.out s=EDASERV, r=runtest, u=edachk, password=pass,w=10, b=2, e=5, v=\"\&\&v1=x,\&\&v2=y\"

-----------

please check this..

thanks

thenmozhi