Transcript Understanding RNI Database Updates

DATABASE UPDATES
RNI 3.1 SP1
© 2013 Sensus. All rights reserved.
C-PAMI-WGE-0006-01
Module Goals
2
The goal of this module is to:
Introduce changes and updates to RNI database
support.
Module Objectives
3
Following this module, you should be able to:
1. Identify key changes and new features of the
RNI database.
2. Use the Database Builder program to perform
small scale daily upgrades on your database.
Summary of Database Updates
Database Updates
• Both Microsoft SQL and Oracle are now supported by
RNI 3.x
• How data is read and stored has changed
– The structure of the database tables has been updated to
improve performance
– Transparent to day-to-day activities
˃ Does not require changes to scripts or other configurations
4
Impact of Database Updates
Database Updates
• During the installation process, Sensus recommends
a procedure for migrating read data prior to full
system migration to RNI 3.x
– Optional, but highly recommended, process that can be
used to upgrade the database from RNI 2.2.4 to 3.x
– Handles migration of a smaller amount of read data on a
daily basis (rather than all at once)
– Applies to every size of deployment
• Expect RNI 2.2.4 production system and RNI 3.x
system to run in parallel for a period of time
5
Database Migration Procedure: Steps 1-3
Database Upgrades
1. Log in to the RNI database server running the
Database Builder software
2. From the opening screen, click Read Migration
3. Click Enable Read Migration to install the scripts
which support the conversion process
6
Database Migration Procedure: Step 4-5
Database Upgrades
4. When the scripts have been installed,
– Click OK in the confirmation dialog, or
– Contact technical support for assistance if you receive an
error message
5. Select the day(s) of data to convert from the
displayed table.
7
Database Migration Procedure: Note
Database Upgrades
The Status column indicates the conversion status of
the read data for the given date
• U = unconverted (no attempts have yet been made to
convert data)
• S = successfully converted
• F = failed conversion
8
Database Migration Procedure: Step 6
Database Upgrades
A Status table appears on selection that displays the
tables that will be converted.
6. Click Convert Selected Day(s)
9
Database Migration Procedure: Step 7
Database Upgrades
A progress dialog displays, and when the migration
completes, an information dialog appears.
7. Click OK
10
Database Migration Procedure: Step 8
Database Upgrades
8. Select the day you just converted to view detailed
information about the conversion in the Status table
Status table shows the number of rows in the
original tables and the number of rows in the
converted tables
11
Database Migration Procedure: Step 9
Database Upgrades
9. Verify a successful conversion using the following
rule:
matrix_count = read_detail_count =
read_detail_value_count
Migration successful when
these three values match
12
Database Migration Procedure: Completion
Database Upgrades
• Repeat steps 1-9 until all, but the most recent five
days, of your data has been converted
Note: Sensus recommends leaving the most recent
five days of data for conversion through the
standard DBB upgrade process to be sure that any
new reads that are filling in data for missing reads
are included in the conversion.
13
Questions
14
Learning Check
15
Question:
1. RNI 3.x operates with which two of the
following databases?
a) IBM DB2
b) Microsoft Access
c) Microsoft SQL
d) Oracle
Learning Check
16
Question:
2. What of the following is a true statement with
respect to migrating from RNI version 2.2.4 to
3.1?
a) New data read model requires database
upgrade
b) New data write model requires database
upgrade
c) New data read model requires switch from
SQL to Oracle
d) New data write model requires switch from
SQL to Oracle
Learning Check
Question:
3. Indicate whether each of these statements
about migrating the database is true or false?
Statement
a) You must use the daily database
migration procedure.
b) You can migrate one or more days
at a time.
c) You should migrate all prior read
data before doing the complete
upgrade to 3.1.
d) You use the Database Builder utility
to perform the daily migration.
17
True False



