SQL/MP Installation and Management Guide

Format 2 Partitions
HP NonStop SQL/MP Installation and Management Guide—523353-004
C-4
Planning for SQL Format 2-Enabled Tables and
Format 2 Partitions
Figure C-3 illustrates an alternate approach for migration and fallback planning if your
system is running an RVU prior to G06.03. In general, this approach involves slightly
more risk than the approach illustrated in Figure C-2 on page C-3, unless all Format 2-
enabled tables are cleaned up before falling back. For a description of the required
cleanup steps, see Fallback Scenario 2 on page C-8.
For more information, see Fallback Scenario 3 on page C-9.
Figure C-3. Migration and Fallback Planning, pre G06.03 RVU
VST0C03.vsd
Not
recommended
Not allowed
Note: No fallback SPRs are available to
fall back to pre-G06.03 RVUs. A two-step
fallback is required.
Fallback Path
Migration Path
Pre
G06.03 RVU
See Fallback
Scenario 3
G06.13 RVU
with Format
2-enabled
tables
G06.03 - G06.12
RVUs plus fallback
SPRs Baseline
(with Format
2-enabled tables
when falling back)