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 |
|---|---|---|---|
|
|
Yes |
|
Should be the same when you register the PPM instance |
|
|
Yes |
|
IP address of the PPM Oracle instance |
|
|
Yes |
|
The port of PPM database server |
|
|
Yes |
|
PPM Oracle database instance name |
|
|
Yes |
|
PPM Oracle database schema name |
|
|
Yes |
|
User name for the PPM Oracle instance |
|
|
Yes |
|
Password for the PPM Oracle Instance |
|
|
Yes |
|
How many months of which you want to extract data from PPM Oracle database |
|
|
No |
|
Defalue value is |
|
|
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
