Registering PPM Instances with InstanceRegister.sh

To register PPM instances, use the InstanceRegister.sh command.

Vertica for PPM supports multiple PPM instances. During installation, you need to set up only one PPM instance. Later, if you want to connect to more PPM instances, you can use this command.

After registering new PPM instances, you also need to schedule ETL jobs for the new PPM instances with the crontab command. For detailed steps, see Scheduling ETL with crontab.

Note: Keep some buffer when setting the ETL schedule with the crontab command, so as to ensure that no ETL jobs for two PPM instances are run in parallel.

The log file of the InstanceRegister.sh command is under <VDW_HOME>/logs/ Installation.log.

The following table describes the supported parameters.

Parameter

Mandatory?

Sample Value

Description

instancename

Yes

ppm01

Should be the same when you register the PPM instance

ip

Yes

16.186.77.109

IP address of the PPM Oracle instance

port

Yes

1521

The port of PPM database server

database

Yes

DBNAME

PPM Oracle database instance name

schema

Yes

SCHEMANAME

PPM Oracle database schema name

user

Yes

username

User name for the PPM Oracle instance

password

Yes

password

Password for the PPM Oracle Instance

initialloadperiod

Yes

1

How many months of which you want to extract data from PPM Oracle database

timezone

No

Asia/Shanghai

Defalue value is UTC

help

No

 

Prints out the help message

For example, to register the a PPM instance to the Vertica for PPMdata warehouse with the name PPM02, use the following command:

sh InstanceRegister.sh --instancename PPM02 --ip 16.157.132.52 --port 1521 --database PPMSH13 --schema AIG_PPM_PHY --user AIG_PPM_PHY --password AIG_PPM_PHY --initialloadperiod 12