Data Definition Language (DDL) Reference Manual

Dictionary Maintenance
Data Definition Language (DDL) Reference Manual—529431-004
10-21
Rebuilding an Audited Dictionary
Example 10-16 on page 10-21 rebuilds a dictionary with a schema generated from a
corrupted dictionary.
In some cases, you cannot generate a schema from a corrupted dictionary. To protect
your dictionary from such an occurrence, keep a fairly current backup schema of any
important dictionary.
Rebuilding an Audited Dictionary
Audited dictionaries rarely need to be rebuilt. The TMF subsystem protects your
dictionary from becoming corrupt by packaging changes into transactions, or units of
recovery. A transaction either modifies the dictionary, or it fails. If a transaction fails,
the TMF subsystem undoes the changes and restores the dictionary to its initial state.
You need to rebuild an audited dictionary only if the TMF system failure occurs.
In Example 10-17 on page 10-21:
•
The dictionary was created on the subvolume $DATA.SALES.
•
All dictionary files are audited except DICTDDF.
If you have a system failure and must rebuild the audited files, follow the procedures in
the TMF Management Programming Manual.
Example 10-16. Rebuilding a Nonaudited Dictionary
65> DDL
!?DICT $data.sales
!?DDL $data.newsales.ddlsrc
!OUTPUT *
!?NODDL
!?DICT $data.newsales
!?SOURCE $data.newsales.ddlsrc
!EXIT
Example 10-17. Determining If a Dictionary is Audited
66> FUP INFO $data.sales.*
CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK
$DATA.SALES
DICTALT 201A 12288 17:06 8,47 CUCU K 38 4096
DICTCDF 207A 12288 17:06 8,47 CUCU K 11 4096
DICTDDF 200 30 17:06 8,47 CUCU
DICTKDF 206A 12288 17:06 8,47 CUCU KA 94 4096
DICTMAP 209A 12288 17:06 8,47 CUCU K 22 4096
DICTOBL 204A 36864 17:06 8,47 CUCU KA 194 4096
DICTODF 202A 16384 17:06 8,47 CUCU KA 86 4096
DICTOTF 203A 12288 17:06 8,47 CUCU K 145 4096
DICTOUF 208A 16384 17:06 8,47 CUCU KA 65 4096
DICTOUK 208A 16384 17:06 8,47 CUCU K 98 4096
DICTRDF 205A 12288 17:06 8,47 CUCU KA 89 4096
DICTTKN 209A 12288 17:06 8,47 CUCU K 6 4096
DICTTYP 209A 12288 17:06 8,47 CUCU K 24 4096
DICTVER 209A 12288 17:06 8,47 CUCU K 19 4096