SQL/MP Installation and Management Guide

Format 2 Partitions
HP NonStop SQL/MP Installation and Management Guide—523353-004
C-11
Fallback Scenario 3
continue with the next file, but without indicating that they have been excluded.
In both cases, the dump otherwise completes successfully.
°
The TMFCOM RECOVER FILES command will not recover any partitions of
Format 2-enabled tables (both Format 1 and Format 2 partitions) or their
associated index partitions and views from online dumps. If you include any in
the file-set list specified for this command (explicitly or by using wild cards),
TMFDR logs an EMS message, drops them from the set of files being
recovered, and continues with the next file. TMFDR recognizes only that a
given file is associated with a Format 2-enabled table (version = 350) when it is
about to restore it from the dump.
°
BACKUP will not dump any partitions of Format 2-enabled tables (both Format
1 and Format 2 partitions) or their associated index partitions and views. If you
explicitly include any of them by name in the qualified file-set list, BACKUP
displays an error message and continues with the next file. Wild-card file sets
will exclude each of the previously mentioned items from the resulting set of
files being dumped, but without indicating that they have been excluded. In
both cases, the backup otherwise completes successfully.
°
RESTORE will not restore any partitions of Format 2-enabled tables (both
Format 1 and Format 2 partitions) or their associated index partitions and
views, from backup tapes. If you include any in the qualified file-set list
(explicitly or by using wild cards), RESTORE displays an error message and
continues with the next file.
°
TACL FILEINFO and FUP INFO commands display error 584 for Format 2
partitions (both table and index partitions) of Format 2-enabled tables and
continue with the next file in the file-set list. The information for Format 1
partitions (both table and index partitions) of Format 2-enabled tables and any
associated views will be displayed normally.
°
DSAP will display error 584 if it encounters Format 2 partitions (both table and
index partitions) of Format 2-enabled tables and will indicate that they are Lost
Free Space. It will then continue reporting on the other files on the disk.
°
DCOM will skip Format 2 partitions of Format 2-enabled tables and indexes,
and will continue with the other files on the disk. Format 1 partitions (both table
and index partitions) will be relocated along with other files to allow the
fragments of free space to be collected together.
°
If you have any programs or third-party products that read the audit trail on
your system, and if they might read any audit created before the fallback, they
must be rebound with a version of TMFARLIB that contains fallback support:
°
The version of TMFARLIB supplied with RVUs that support Format
2-enabled tables also contains fallback support. It detects when it is
running on an RVU that does not support SQL Format 2 partitions and then
functions appropriately. Therefore, if you rebound these programs or third-
party products with the new version of TMFARLIB when you migrated, you
can continue to use them after falling back.