Powercenter Command Line Utilities

It’s never suggested to update the repository meta data tables, it always recommended to be done through Informatica Application or through the command line interfaces. There are various Utilities available for Informatica in order to interact with the PowerCenter repository and integration service at command Line. Informatica provides below CLIs

• pmrep
• pmcmd
• csm.sol
• pmtack
• pstack

pmrep :

pmrep utility will be installed automatically as and when the PowerCenter server is installed. No need to install it separately. With this utility you can directly interact with powercenter repository. pmrep is one of the robust utility which allows you to perform below operations.

•  Insert, Delete, Update Informatica meta objects.
•  List the Informatica meta objects.
•  You can have the deployments, migrations.
•  Sequence generator updations
•  Property changes for powercenter objects.
•  Plug In installation (Salesforce,SAP)

pmcmd :

pmcmd also comes up when powercenter server is installed no need to install it separately. With this utility you can directly interact with Integration Service.pmcmd provides you the options to have below operations.

• Trigger(kickoff),Abort the powercenter jobs.
•  Get the statistics of the status powercenter jobs.

csm.sol :

csm.sol needs to be installed separately and it doesn’t comes up with the powercenter installation. You will have to get the csm.sol xml from informatica vendor’s site and keep it in the informatica binary directory. CSM as the name indicates it used to get the configuration for the whole powercenter environment, when you run the csm following information will be captured in the xml format so that you can send that xml to vendor for analysis in case of any server crash or unnecessary break up in the environment.

pmstack or pstack

even pmstack/pstack either one has to be downloaded from the informatica vendor’s site and installed in the $INFA_HOME/server/bin directory.

Why pmstack or pstack are needed ?

Whenever the informatica service (integration service)crashed a core file will be generated in the $INFA_HOME/server/bin directory. The core file holds the information and errors related to service crash but the core file will not be in the human readable format rather it will be in the binary format which needs to converted to the ASCII human readable format. Using the pstack or pmstack you can generate the trace files on the core which contains the readable data.