Informatica commands

Informatica Commands:

 

pmrep command : pmrep is used to perform repository metadata administration tasks, such as listing repository objects.

infacmd command : infacmd is used to perform service-related functions, such as creating or removing a Repository Service.

infasetup command : infasetup to back up, restore, define, and delete domains, and to define and update nodes

pmcmd command : pmcmd is used to communicate with PowerCenter Integration Services in order to manage the Informatica workflows (start, stop, recover, …)

----------------------------------------------------------------------------------------------------------------------------

Ping integration service :
pmcmd pingservice -sv <Integration service name> -d <Domain_name>

Ping repository service  :
pmrep connect -r <Repository service name> -h <hostname> -o <port> -n Administrator -x <Admin_passwd>

Create Backup file:
pmrep backup -o <file_name.rep>

Restore Backup file:
pmrep restore -i <file_name.rep> -u <Domain_User> -p <Domain_Passwd>

Check list of dependent object of workflow:
pmrep listobjectdependencies -n <workflow_name> -o workflow -f <Workflow_Folder_name> -d session -p children

Run Workflow:
pmcmd startworkflow -sv <Integration service_name> -d <Domain_Name> -u Administrator -p <Admin_Passwd> -f <Workflow_Folder_name> -lpf <Parameter file full path> <WORKFLOW_NAME>
option: -lpf is used for local machine parameter file path. Else use option -paramfile $PMROOTDir

Start Session Task:
pmcmd starttask -uv Administrator -pv <Admin_Passwd> -s <HOSTNAME:PORT> -f <Folder_Name> -w <Workflow_name> -lpf <Parameter_File> <Task_Name>

Get  status of the session :
pmcmd getsessionstatistics -sv <Integration_service> -d <Domain_Name> -u Administrator -p <Admin_Passwd> -f <Folder_name> -w <Workflow_name> <Session_Task_Name>

Change node properties:
infasetup updateGatewayNode -na <hostname:port> -hs <https_port> -kf "$INFA_HOME\tomcat\conf\Default.keystore" -kp <passwd>

Create domain manually:
infasetup defineDomain -dn <domain_name> -ad <Administrator> -pd <Administrator_passwd> -ld \"$INFA_HOME\infa_shared\log\" -nn <node_name> -na <hostname:port> -mi <min_port> -ma <max_port> -sv <service port> -rf nodeoptions.xml

PMCMD command in informatica

                Pmcmd command is utility provided to interact with Informatica server from command line/unix prompt. When you run pmcmd in command line mode, you enter connection information such as domain name, Integration Service name, user name and password in each command.

                First you can check whether pmcmd utility is available or not by typing

Find . –name “PMCMD”

                And then set SHLIB_PATH environment variable as below (for example) and export

                                SHLIB_PATH=$PATH:/appl/inform/Informatica/9.0.1/server/bin

                                export SHLIB_PATH

Examples:

Start the workflow:

Pmcmd startworkflow –s integration_service –d domain_name –u user_name –p password –f folder_name –w workflow_name

Stop the workflow: stopworkflow

Scheduling the workflow: scheduleworkflow

Start the workflow from task:

Pmcmd starttask –s integration_service –d domain_name –u user_name –p password –f folder_name –w workflow_name -startfrom task-name

Stopping a task:

Pmcmd stoptask –s integration_service –d domain_name –u user_name –p password –f folder_name –w workflow_name task-name

Aborting workflow and task:

Pmcmd abortworkflow –s integration_service –d domain_name –u user_name –p password –f folder_name –w workflow_name

Pmcmd aborttask –s integration_service –d domain_name –u user_name –p password –f folder_name –w workflow_name task-name

Some more commands:

stoptask : To stop a task
gettaskdetails : To retrieve task details
starttask : To Execute a task
aborttask : To abort a task
waittask : To Run a task in wait mode workflow specific

getworkflowdetails : To retrieve workflow details

waitworkflow : To Run a workflow in wait mode