Version 8



    FormatUserConnections is a java-based utility, which can be used to retrieve connections to your PowerCenter repository from various clients like Sessions, Designer, and Integration Service etc. This productivity tool improves readability of pmrep listuserconnections lists connections to a repository.



    FormatUserConnections provides the below features:

    Listing Connections


    • Lists of “All” pmrep connections.
    • Lists of pmrep connections filtered on a clientType (wsh | pmserver | pmdtm | pmrep).
    • Lists of pmrep connections filtered for a particular user.
    • Writes all pmrep connections to an Output File.
    • Lists of connections filtered on active or broken pmrep connections.
    • Summary of connections based on clientType and user.


    Kill Connection(s):


    • Kill specific connection(s) [delimited by space].
    • Kill connections for a particular user.
    • Kill all connections.


    System Requirements


    The following are the environment pre-requisites to run this Java based script:


    • Ensure that the tool runs from a machine where PowerCenter client/server is installed.
    • Ensure that INFA_DOMAINS_FILE is set.
    • Ensure that INFA_JDK_HOME is set on AIX and HP-UX and INFA_HOME is set on all other environments.


    Supported Informatica Products


    • PowerCenter 9.1
    • PowerCenter 9.5
    • PowerCenter 9.6
    • PowerCenter 10.0


    License Info


    • Free download


    Current Version


    • FormatUserConnections 1.1




    • (See Attachment below)


    How to Install


    1. Download the FormatUserConnections zip file, which can list the connections to a Repository.
    2. Execute the script on Windows using formatuserconnections.bat and on UNIX as, as below:



            For listing connections:

    formatuserconnections.bat -r <Repository Name> -d <Domain_Name> -n <Domain_Username> {-x <Domain_Password> | -X <Encrypted_Domain_Password>}  [-c <Security_Domain>]  -list [-f <Process_Name> (wsh | pmserver | pmdtm | pmrep)] [-u <Filter_Domain_Username>] [-o <Output_File_Directory>]


    For killing connection(s):

    formatuserconnections.bat -r <Repository Name> -d <Domain_Name> -n <Domain_Username> {-x <Domain_Password> | -X <Encrypted_Domain_Password>}  [-c <Security_Domain>] -kill [-i <ConnectionIDs> | -s <LoginID> | -a]



            For listing connections: -r <Repository Name> -d <Domain_Name> -n <Domain_Username> {-x <Domain_Password> | -X <Encrypted_Domain_Password>}  [-c <Security_Domain>] -list [-f <Process_Name> (wsh | pmserver | pmdtm | pmrep)] [-u <Filter_Domain_Username>] [-o <Output_File_Directory>]

    For killing connection(s): -r <Repository Name> -d <Domain_Name> -n <Domain_Username> {-x <Domain_Password> | -X <Encrypted_Domain_Password>}  [-c <Security_Domain>] -kill [-i <ConnectionIDs> | -s <LoginID> | -a]




    1. Run the tool (formatuserconnections.bat (Windows) and (UNIX)) without any arguments to see a quick help.
    2. Ensure that the environment variables for starting the Informatica services are sourced, before running the pmrep command.
    3. Ensure that the LANG setting matches the repository service, or you may get an error from the tool like the following:

      [[REP_61082] pmrep's code page (UTF-8 encoding of Unicode) is not one-way compatible to repository Repository_Service’s code page (MS Windows Latin 1 (ANSI), superset of Latin1).]

    4. In case of tool hanging on “Attempting pmrep connect”, ensure that the pmrep works outside using command line. You may get the below error message after quite a while though: Cannot connect to domain [Domain_Name] to look up service [Repository_Service].
    5. Ensure that INFA_HOME and INFA_DOMAINS_FILE point to the same PC version. Or you may get the below error:No gateway connectivity is found for domain [DOMAINNAME].
    6. Console provides all errors from the utility However to troubleshoot any issue, ensure that “pmrep -r <Repository Name> -d <Domain_Name> -n <Domain_Username> {-x  <Domain_Password>|-X <Encrypted_Domain_Password>} [-s <Security_Domain>]” works fine externally on the command prompt..


    Release History


    Sl No.Version HistoryRelease Date