Data Definition Language (DDL) Reference Manual (G06.24+)

Dictionary Maintenance
Data Definition Language (DDL) Reference Manual—426798-002
10-15
Moving a Nonaudited Dictionary
Moving a Nonaudited Dictionary
To move a nonaudited dictionary:
1. Duplicate the dictionary files on another subvolume using FUP DUP commands.
2. 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. (You can
determine which files use alternate keys by looking for the symbol A in the TYPE
column of a FUP INFO display; then use FUP INFO, DETAIL on those files to
determine the alternate key name.)
3. Optionally, you can purge the dictionary from the old subvolume.
You can enter these commands interactively, or you can build a file containing these
commands and then execute the file.
For example, to move a dictionary from $DATA.SALES to $MKT.SALESDIC, you can
build and then execute a file that contains the following commands:
Suppose this file was created on subvolume $DATA.SALES and its name is
DICMOVE. You can execute the commands in DICMOVE by entering the following
command:
57> OBEY $data.sales.dicmove
If you no longer need the original dictionary on $DATA.SALES, you can purge the
dictionary files as described in Purging a Dictionary on page 10-18.
Moving an Audited Dictionary
Moving an audited dictionary requires more steps than moving a nonaudited dictionary
because of these actions of the FUP utility on audited files:
•
When you FUP DUP an audited file, FUP automatically disables auditing on the file
but does not disable auditing on or change pointers to any associated alternate key
files. As a result, duplicated files that use alternate keys point to audited alternate
key files on the original subvolume. For this reason, you must use FUP ALTER to
VOLUME $data.sales
FUP DUP (DICTALT,DICTCDF,DICTDDF,DICTKDF,DICTMAP), $mkt.salesdic.*
FUP DUP (DICTOBL,DICTODF,DICTOTF,DICTOUF,DICTOUK), $mkt.salesdic.*
FUP DUP (DICTRDF,DICTTKN,DICTTYP,DICTVER), $mkt.salesdic.*
VOLUME $mkt.salesdic
FUP ALTER DICTKDF, ALTFILE (0,DICTALT)
FUP ALTER DICTOBL, ALTFILE (0,DICTALT)
FUP ALTER DICTODF, ALTFILE (0,DICTALT)
FUP ALTER DICTOUF, ALTFILE (0,DICTOUK)
FUP ALTER DICTRDF, ALTFILE (0,DICTALT)
Default volume & subvolume
New default volume & subvolume
Change alternate-key
subvolume names in the file
labels of all files with alternate
keys
VST1010.vsd