AMI Database Configuration

Modify the following items in the 02_RxAmiViews.sql file before executing the database scripts:

1. Replace 'US/Mountain' by 'US/Eastern' or appropriate time zone based on server location.

2. Modify the stale threshold in the section that creates the RXINT_AMI_CALLS_TO_SUBMIT_VW view.

3. Modify the momentary threshold in the section that creates the LP_HIST_NON_MOMENTARY view. The default value is 1 minute. If an outage is shorter than the set threshold, it is considered a momentary outage.

Open a command prompt and execute the install_AMI.bat script, which is located at:

For Oracle, the batch script is located in C:\Program Files (x86)\Miner and Miner\Responder\Integration\Ami Service\IntegrationScripts\Oracle

This script requires the following files, which should be in the same folder:

1. 01_RxAmiCustomTables.sql

2. 02a_RxAmiDownEventViews.sql

3. 02b_RxAmiUpEventViews.sql

4. 02d_RxAmiTiltViews.sql

5. 02e_RxAmiCallsViews.sql

6. 02f_RxAmiRestoresViews.sql

7. 03_RxAmiIndexes.sql

8. Ping_Request_Table.sql

9. RxIntAmiKillSP.sql

10. RXINT_CONFIGURATION_oracle.sql

11. Set_RXINT_CONFIG_oracle.sql

For MS-SQL, the batch script is located in C:\Program Files (x86)\Miner and Miner\Responder\Integration\Ami Service\IntegrationScripts\MS-SQL\

This script requires the following files, which should be in the same folder:

1. 01_RxAMICustomTables.sql

2. 02_RxAmiViews.sql

3. 03_RxAMIConfiguration.sql

4. RxIntAmiKillSP.sql

Provide the Responder your username, password, and database instance when prompted. For example:

User name: responder (or any preconfigured user with database admin rights)

Password@Instance: password@tnsname

The batch script runs the SQL scripts to create the necessary database structures for AMI integration.

Execute the install_Archive_AMI.bat script, in the same location.

This script requires the following files, which should be in the same folder:

1. 01_RxAmiCustomArchiveTables

Provide the Archive schema username, password, and database instance when prompted. For example:

User name: rxarchive (or any preconfigured user with database admin rights)

Password@Instance: rxarchive@tnsname

The batch script runs the SQL scripts to create the necessary database structures in the archive tables for AMI integration as listed below.

• Adds the following tables:

  • RXINT_METER_EVENT

  • RXINT_METER_EVENT_HISTORY

  • RXINT_PROCESS_LOGS

  • RXINT_PING_REQUESTS

  • RXINT_PING_REQUEST_METERS

• Adds the RXINT_CONFIGURATION table and sets the values for those selected during install.

• Adds the RxInt Ping Meter task and assigns it to the Dispatcher role.

• Adds the RXINT_AMI_TIME_RESTORED field to the RX_CALLS, RX_CALLS_HISTORY, and RX_CALLS_ARCHIVE tables.

• Adds the rx_calls_trg trigger to the RX_CALLS table.

• Adds the following Views:

  • LAST_EVENT_VW

  • RXINT_AMI_DOWN_COUNT_VW

  • RXINT_AMI_DOWN_EBI_VW

  • RXINT_AMI_DOWN_FLAG_VW

  • RXINT_AMI_DOWN_KM_VW

  • RXINT_AMI_DOWN_RATE_VW

  • RXINT_AMI_DOWN_TILT_INTRVL_VW

  • RXINT_AMI_TILT_DOWN_INTRVL_VW

  • RXINT_AMI_TILT_EVNT_VW

  • RXINT_AMI_DWN_EVNT_VW

  • RXINT_AMI_UP_COUNT_VW

  • RXINT_AMI_UP_EBI_VW

  • RXINT_AMI_UP_FLAG_VW

  • RXINT_AMI_UP_KM_VW

  • RXINT_AMI_UP_RATE_VW

  • RXINT_PING_RESPONSES_VW

• Adds the CheckAmiKillTriggers Stored Procedure.