SQL/MP Installation and Management Guide

Format 2 Partitions
HP NonStop SQL/MP Installation and Management Guide—523353-004
C-9
Fallback Scenario 3
1. Convert all Format 2 partitions back to Format 1, with or without SHARED
ACCESS, then convert all Format 2-enabled tables back to Format 1 enabled.
Alternately, if some Format 2-enabled tables are not important or if their data is first
reloaded back into Format 1 enabled tables, you can instead use the SQLCI
DROP command to eliminate them.
2. Downgrade all version 350 SQL catalogs on your system to version 345 or lower.
3. Take new TMF online dumps or backups of all the tables and SQL catalogs that
were changed in Step 1 and Step 2. Note that you must include all the partitions
that were part of Format 2-enabled tables (Format 1 partitions in addition to Format
2) and their associated index partitions and views.
4. Achieve a clean TMF shutdown, with all audited disks up, using the TMFCOM
STOP TMF command.
5. If you have any programs or third-party products that use TMFARLIB to read the
audit trail on your system, after the fallback, you must ensure that they do not read
audit records created before the fallback. Alternately, you must use versions of
these programs rebound with a version of TMFARLIB that contains fallback
support. (For more information, see Fallback Scenario 3).
However, other fallback considerations might still apply because of intervening RVUs
that your fallback bypassed or the use of other features introduced in these RVUs.
Fallback Scenario 3
If you have created any SQL Format 2-enabled tables on your system but you are
unwilling or unable to perform all the cleanup steps described in Scenario 2 before
falling back, these fallback considerations apply:
•
HP strongly recommends that, before you fall back, you find and record the
location of all Format 2-enabled tables (including all their Format 1 and Format 2
partitions and all their associated index partitions and views) and all version 350
SQL catalogs on your system. You can find Format 2 partitions of Format
2-enabled tables (but not their Format 1 partitions) by using this command in
SQLCI:
FILEINFO $*.*.* WHERE SQL AND FORMAT2
Note. Because there might now be additional data in each Format 2 partition, the original
Format 1 partition definitions might be too small to accommodate all the data. You might
need to convert certain Format 2 partitions back to multiple Format 1 partitions if the
original Format 1 partition was nearly full when it was migrated to Format 2.