Showing posts with label pmrep. Show all posts
Showing posts with label pmrep. Show all posts

Thursday, 2 August 2018

What are the checks to be performed before using pmrep deployment group?

The following are the commands to be run:

1. Login to Host1 and run the following:

cd $INFA_HOME/server/bin
./pmrep connect -r <rep_name> -d <domain_name> -n <username> -x <password> -sdn <Native/LDAP domain>

2. Login to Host2 and run  the following:

cd $INFA_HOME/server/bin
./pmrep connect -r <rep_name> -d <domain_name> -n <username> -x <password> -sdn <Native/LDAP domain> 

If the $INFA_HOME/server/bin is in PATH environment variables then you can the pmrep command from anywhere.

3. Check if the below objects are created if you are using dynamic deployment groups in source repository. 
  • Label
  • Query

4. Check if you are able to connect source repository from target host where you run the deployment or vice versa.

The username (and password) is the one that you use to connect to the repository through the power center clients (such as repository manager).
The sdn is the security domain which is either Native or the LDAP domain. (enter the same details as the one on the PowerCenter client).


The Connect command uses the following syntax:

pmrep help connect
-r <repository_name> {-d <domain_name> |
{-h <portal_host_name>
-o <portal_port_number>}}
[{ <user_name>
[-s <user_security_domain>] [-x <password> |
-X <password_environment_variable>]} |
-u <connect_without_user_in_kerberos_mode>] [-t <client_resilience>]

To use -X option configure INFA_DEFAULT_DOMAIN_PASSWORD on UNIX:
1. At the command line, type:
pmpasswd <password>
pmpasswd returns the encrypted password.
2. In a UNIX C shell environment, type:
setenv INFA_DEFAULT_DOMAIN_PASSWORD <encrypted password>
    In a UNIX Bourne shell environment, type:
export INFA_DEFAULT_DOMAIN_PASSWORD=<encrypted password> 

Tuesday, 16 August 2016

Informatica PowerCenter Domain Status Checking

There are multiple ways to check the Domain Status.
  1. From Command prompt:
    1. Run the below command in UNIX/LINUX
      1. $INFA_HOME/isp/bin/infacmd.sh isp ping -dn <Domain_name>
    2. Run the below command in Windows
      1. change the directory to $INFA_HOME/isp/bin/. If the PATH variables are set to $INFA_HOME/server/bin you can run this command from any where.
        1. infacmd.bat/sh ping -dn <Domain_name>
        2. to check the admin console service status run the below command.  infacmd.bat/sh ping -dn <Domain_name> -sn _Admin_Console
  1. From database:
    1. Connect to Domain database.
    2. Run the sql query : select * from ISP_MASTER_ELECTION; -- this will return you a record with the host and post details.
  2. From Browser:
    1. Open the admin console URL. if the URL is opening then the domain is running.