Dictionary Maintenance
Data Definition Language (DDL) Reference Manual — 426798-002
10 -16
Moving an Audited Dictionary
disable auditing before using FUP DUP to duplicate files, then use FUP ALTER to
reenable auditing after duplicating the files.
•
When you use FUP ALTER to disable auditing on a file that uses alternate keys,
FUP also disables auditing on the associated alternate key file. As a result, any
other files that use the same alternate key will be associated with a nonaudited
alternate key file. But you cannot use FUP ALTER to disable auditing on a file that
has a nonaudited alternate key file, so you must reenable auditing on the alternate
key file in order to disable auditing on a file using that alternate key file.
•
Conversely, when you use FUP ALTER to enable auditing on a file, it automatically
enables auditing on any alternate key file used by the file. But you cannot use FUP
ALTER to enable auditing on a file that uses an audited alternate key file, so you
must disable auditing on any alternate key file before enabling auditing on a file
that uses that alternate key file.
To move an audited dictionary:
1. Disable auditing using FUP ALTER commands. Where necessary, reenable
auditing on alternate key files before disabling auditing on files that use the
alternate key files.
2. Duplicate the dictionary files on another subvolume using FUP DUP commands.
3. Change the subvolume name of the alternate key file in the file label of each
dictionary file that has alternate keys using FUP ALTER commands.
4. Enable auditing on the new subvolume using FUP ALTER commands. Where
necessary, disable auditing on alternate key files before enabling auditing on files
that use the alternate key files.
5. Note that the DICTDDF file should never be audited.
6. Optionally, purge the dictionary from the old subvolume.
7. If you keep the original dictionary, you might want to reenable auditing as
described in Step 4.
While you can enter these commands interactively, it is best to create a FUP source
file containing these commands and execute that file.
Содержание DDL D40
Страница 36: ...Introduction to DDL Data Definition Language DDL Reference Manual 426798 002 1 14 Examining a Dictionary ...
Страница 66: ...Named Constants Data Definition Language DDL Reference Manual 426798 002 4 10 Standard SPI Constants ...
Страница 230: ...Dictionary Manipulation Statements Data Definition Language DDL Reference Manual 426798 002 8 14 SHOW USE OF Statement ...
Страница 370: ...Dictionary Maintenance Data Definition Language DDL Reference Manual 426798 002 10 24 Converting a Dictionary ...
Страница 456: ...Sample Schemas Data Definition Language DDL Reference Manual 426798 002 B 12 ASSNDDL Statements ...
Страница 470: ...DDL Data Translation Data Definition Language DDL Reference Manual 426798 002 C 14 ...
Страница 528: ...Dictionary Reports Data Definition Language DDL Reference Manual 426798 002 E 8 Requesting Reports ...
Страница 552: ...DDL Alignment Rules Data Definition Language DDL Reference Manual 426798 002 H 4 FIELDALIGN_SHARED8 Alignment Rules ...
Страница 576: ...Index Data Definition Language DDL Reference Manual 426798 002 Index 22 Special Characters ...