Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Run ETLCRTLS from a command prompt
Go
New
Search
Notify
Tools
Reply
  
Run ETLCRTLS from a command prompt
 Login/Join
 
Gold member
posted
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
 
Posts: 60 | Location: Kingsey-Falls, Québec, Canada | Registered: May 14, 2008Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: September 30, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Run ETLCRTLS from a command prompt

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.