Unix and Informatica

Document Sample
Unix and Informatica Powered By Docstoc
					Steps to start a pmcmd command to run a workflow from informatica server

Steps to start a pmcmd command to run a workflow from informatica server
1. At the command prompt, switch to the directory where the pmcmd executable is located.
By default, the PowerCenter installer installs pmcmd in the \server\bin directory
.2. Enter pmcmd followed by the command name and its required options and arguments:
pmcmd command_name [-option1] argument_1 [-option2] argument_2...
if your not pretty sure where the excutable is present or not just type and pmcmd command in
your server and check for the message if throws an "command not found"
then check for this file in your home directory(.cshrc_infa) file this file contains
#ident "@(#)local.cshrc 1.2 00/05/01 SMI"umask 022set path=(/bin /usr/bin /usr/ucb /etc .)if (
$?prompt ) then set history=32endif
setenv ODBCHOME /(server name)/app/informatica/pc_server/ODBC5.2setenv ODBCINI
$ODBCHOME/odbc.inisetenv INFA_HOME /mounts/infdev/app/informatica/pc_serversetenv
DOMAINS_INFA /(servername)/app/informatica/pc_serversetenv ORACLE_HOME
/mounts/ora_home/app/oracle/product/10.2.0.3setenv ORACLE_SID infdev
setenv TNS_ADMIN /(mainserver name)/app/oracle/network
setenv PATH
${PATH}:/Mounts/ora_home/app/oracle/product/10.2.0.3/bin:$ODBCHOME/bin:$INFA_HOM
E/server/binsetenv LD_LIBRARY_PATH
$ORACLE_HOME/lib:$ODBCHOME/lib:$INFA_HOME/server/bin

then type csh command and then source your file .csh source .cshrc_infa
and then run pmcmd command
synatx is as follows
pmcmd scheduleworkflow <-serveraddr-s> [host:]portno <<-user-u> username<-uservar-uv>
user_env_var> <<-password-p> password<-passwordvar-pv> password_env_var> [<-folder-f>
folder] workflow
--------------------------------- pmcmd startworkflow -sv Integartion service name -d domain -u
username -p password -f 'folder' workflow name


If you are alreadyin pmcmd prompt then follow the below mentioned steps

The following commands were helpful for pmcmd:
pmcmd>connect -sv Service -d domain -u username -p password
pmcmd>startworkflow -f 'folder' workflow
pmcmd>getworkflowdetails -f 'folder' -rin workflow
pmcmd>gettaskdetails -f 'folder' workflow
pmcmd>stoptask -f 'folder' workflow
pmcmd>getsessionstatistics -f 'folder' workflow
pmcmd>scheduleworkflow -f 'folder' workflow
pmcmd>unscheduleworkflow -f 'folder' workflow
pmcmd>disconnect -sv Service -d domain -u username -p password
Pmcmd is perform following tasks

1.start and stop the sessions and batches
2.process the sesson recovery
3.stop the informatica server
4.check whether informatica server working or not.



pmcmd means powermart command prompt which used to perform the tasks from command prompt
and not from Informatica GUI window

Suppose during one process a file is generated in one path and during the running of the worflow you
want it to place in another path so for this we need to use unix command "cp soure pathname targt
pathname".

Generally all informatica jobs are automated and for this automation we need a tool in general unix
based tools are prefered like control-m autosys.. etc. so for the job to run tru tools it must be in the unix
script form so there pmcmd worflow name ... etc will be used/




Unix commands for Informatica

The thing is we need to understand why should we learn Unix commands for Informatica


step1: run pmcmd
You will get pmcmd prompt
pmcmd>

step2:. run connect command to connect to repository/ cd to go to informatica server directory
pmcmd>connect
it will ask repository name/password

step3: run whatever command you need (startworkflow,stopworkflow,abortworkflow,starttas
t.....)

Some more useful commands would be
PMREP
The pmrep is a command line program that you use to update repository
information and perform repository functions. It´s installed in Repository
Server installation directory, it is usually ( $PM_HOME/repserver ). You can
execute this command like a command line or you can execute from a script
UNIX.
This command has got a lot of options, for example, you can connect to a
repostory if you execute the following command:

pmrep connect
-r
-n
-x
-h
-o

INFASETUP

INFAREP
INFACMD

infasetup is under .../server
infacmd is under .../server/bin

during one process a file is generated in one path and during the running of the worflow you
want it to place in another path so for this we need to use unix command "cp soure pathname
targt pathname".

Generally all informatica jobs are automated and for this automation we need a tool in general
unix based tools are prefered like control-m autosys.. etc. so for the job to run tru tools it must be
in the unix script form so there pmcmd worflow name ... etc will be used/

RE: What is use of UNIX in Informatica?

Unix will provide security by providing authentications. so most of the developers use unix for
their development.

What is use of UNIX in Informatica?


Hi

These are some ways unix works with Informatica.

     1) In unix box we can create a SCRIPT which calls informatica session and make the
        session run.
        2) We can UPDATE STATISTICS or CLEANUP files by creating pre defined functions.
        3) Also I can call sql files through the scripts to create/drop staging tables creta index....
        4) Create dependencies among various sessions.
        5) create parameter files and define session and mapping variables like
        DBCONNECTION proc_dt badfile name log file name...
     2) ram
   3) Re: Basi Unix Commands that we use in Informatica
   4) Hi,
   5)
   6) These are required commands to invoke informatica workflows and Basic unix script.
   7)
   8) 1.PMCMD
   9) 2.MKDIR
   10) 3.RM
   11) 4.CP
   12) 5.<condition statements> ie IF ELSE
   13) 6.GREP
   14) 7.ZIP COMMANDS
   15) 8.LS(with different options)
   16) 9.TOUCH
   17) 10.MV
   18)
   19)
   20) I'd suggest you that the mentioned commands most frequently using one but you should
       study rest of the unix commands because it helps you to write your script very effective.
   21)
   22)




Not very much sure how to install informatica on unix

				
DOCUMENT INFO