SQL/MP Installation and Management Guide

Format 2 Partitions
HP NonStop SQL/MP Installation and Management Guide—523353-004
C-5
General Planning Considerations
General Planning Considerations
•
G06.13 RVU baseline
Establishing a baseline is an important step prior to migration. HP recommends
installing G06.13 RVU and running applications in production prior to using any
Format 2-enabled tables. Establishing the baseline is a precaution if issues arise
during migration and require temporarily suspending or partially undoing migration
activities. Most migrations should be able to proceed as planned; however, not all
customer migration scenarios can be tested. As with any software and feature
upgrades, you should consider these questions: What can I do if the upgrade runs
into problems? How do I fall back to the previous working environment?
Establishing a G06.13 RVU baseline separates general G06.13 RVU issues from
issues specific to Format 2 partitions or Format 2-enabled tables.
•
Fallback baseline
You might not always be able to establish a G06.13 RVU baseline. For those
situations, a set of fallback SPRs are available for G06.03 through G06.12 RVUs.
The SPRs allow those earlier RVUs to tolerate the presence of Format 2-enabled
tables, as much as possible, and to purge them or any of their associated partitions
and views. No operations other than FILEINFO and PURGE are allowed when a
Format 2 partition resides on an earlier RVU. Attempts to execute other operations
result in appropriate errors being issued. Attempts to perform operations against a
Format 2 partition from an earlier RVU where the necessary fallback SPRs have
not been installed produce indeterminate results, possibly including data corruption
or processor failures. This scenario is also applicable for Format 1 partitions in a
Format 2-enabled table.
•
Upgrade catalog
Format 2-enabled tables are version 350 tables and must be registered in version
350 SQL catalogs. Therefore, before you create new Format 2-enabled tables, you
must upgrade the catalog where those tables are to be registered to version 350.
Before you alter existing tables to be Format 2-enabled, you must upgrade the
catalogs where those tables are registered, to version 350. If any Format
2-enabled tables are to be registered in the system catalog, you must upgrade the
system catalog to version 350. If you have a separate application catalog, you
need not upgrade the system catalog.
•
Enable tables
You can create new Format 2-enabled tables by setting the PARTITION ARRAY
value to Format 2-enabled. Similarly, you can alter existing tables by changing their
PARTITION ARRAY value to Format 2-enabled. This action implicitly makes the
table and all of its indexes Format 2-enabled. All existing partitions are implicitly
still Format 1 partitions.