SQL/MP Installation and Management Guide

Format 2 Partitions
HP NonStop SQL/MP Installation and Management Guide—523353-004
C-2
Planning for SQL Format 2-Enabled Tables and
Format 2 Partitions
Migration, in contrast, enables you to modify tables a partition at a time to Format 2.
Most of the steps involved in this process can be done while your applications continue
to access and modify data in the tables.
Whether you attempt conversion or migration of your tables, the steps required have
many common elements. Planning is an important part of the process.
Figure C-1 illustrates the possible approaches for migration and fallback planning if
your system is currently running a G06.03 through G06.12 RVU.
For more information, see Fallback Scenario 2 on page C-8.
Figure C-1. Migration and Fallback Planning, G06.03 Through G06.12
VST0C01.vsd
Note: Fallback SPRs are available only
for G06.03 - G06.12 RVUs.
Fallback Path
Migration Path
G06.03
|
G06.12
Not recommended and
allowed only if fallback
SPRs are applied (See
Fallback Scenario 3)
Not
recommended
See Fallback
Scenario 2
G06.13 RVU
with Format
2-enabled
tables
G06.13
Baseline (no
Format 2-enabled
tables)