pmrep updatestatistics command

You can update repository statistics with the pmrep updatestatistics command to improve PowerCenter repository performance.

To perform this action you will need to do it in 2 steps

1. Connect to repository
2. update the statistics.

Let start.

STEP 1 – connect to the repository

>  ${INFA_HOME}/server/bin/pmrep connect -r <REPOSITORY_NAME> -n <ADMIN USER> -x <ADMIN PASS> -h <GTWAY_HOSTNAME> -o <GTWAY_PORT_NO> -s Native

NOTE: If you already encrypted your password, you can use the -X PASSWORD

STEP 2 – Update the statistics

>  ${INFA_HOME}/server/bin/pmrep updatestatistics

Here is ksh script that you can copy and modify to your needs.


#!/bin/ksh
###########################################################################
# ENV VARS
###########################################################################
INFA_HOME="/appl/informatica/"
REP_NAME="REPOSITORYNAME"
PC_USER="Administrator"
PC_PASS="MYPASS"
GTWAY_HOSTNAME=`hostname`
GTWAY_PORT_NO=PORTNUM
###########################################################################
# MAIN
###########################################################################
#STEP 1 - connect to repository
${INFA_HOME}/server/bin/pmrep connect -r ${REP_NAME} -n ${PC_USER} -x ${PC_PASS}" -h ${GTWAY_HOSTNAME} -o ${GTWAY_PORT_NO} -s Native
#STEP 2 - update statistics
${INFA_HOME}/server/bin/pmrep updatestatistics


Please note, you need to update all the parameter marked in bold blue.