Format
VERIFY [ qualifier ] ... anchor-name ,...
1 – Parameters
1.1 – anchor-name
Specifies the anchor of the repository you are verifying.
2 – Qualifiers
2.1 /ALL
Performs all the verification options, except for the REBUILD_
DIRECTORY and COMPRESS options.
The /ALL qualifier includes the /NOFIX qualifier by default. If
you want to use the /FIX qualifier as the default to the VERIFY
/ALL command, define the CDD$VERIFY_ALL_FIX logical name to be
any value. Define the CDD$VERIFY_ALL_FIX logical name at the
process level or higher.
If you specify the VERIFY/ALL command without specifying a /FIX
or /NOFIX qualifier, and if you have not defined the CDD$VERIFY_
ALL_FIX logical name, an informational error message, CDO-I-
VF_ALL_NOFIX, will display and the VERIFY command will continue
using the default /NOFIX qualifier.
2.2 /COMPRESS
Format options:
/COMPRESS
/NOCOMPRESS (default)
Specifies whether CDO compresses the CDD$DATABASE.SNP file to
its original size at the time you created the repository. If you
specify the /COMPRESS qualifier, you cannot include any other
qualifier in your command.
2.3 /DIRECTORY
Format options:
/DIRECTORY
/NODIRECTORY (default)
Specifies whether CDO checks all directory names against a stored
definition.
When you also specify the /FIX qualifier, the /DIRECTORY
qualifier removes directory names that do not refer to any stored
definition.
2.4 /EXTERNAL_REFERENCES
Format options:
/EXTERNAL_REFERENCES
/NOEXTERNAL_REFERENCES (default)
Specifies whether CDO checks all relationships where either the
owner or member is outside the repository you specified.
When you also specify the /FIX qualifier, the /EXTERNAL_
REFERENCES qualifier fixes the errors it detects.
2.5 /FIX
Format options:
/FIX
/NOFIX (default)
Specifies whether CDO corrects errors found by the other
qualifiers you specify.
2.6 /LOCATION
Format options:
/LOCATION
/NOLOCATION (default)
Specifies whether CDO checks that the repository is in the
correct directory and is correctly referenced by other
repositories on the system.
When you also specify the /FIX qualifier, the /LOCATION qualifier
fixes the errors it detects.
2.7 /LOG
Format options:
/LOG
/NOLOG (default)
Specifies whether CDO sends informational and error text to the
default output location for your system. Specifying the /NOLOG
qualifier displays only error text.
2.8 /ORPHANS
Format options:
/ORPHANS
/NOORPHANS (default)
Specifies whether CDO searches for definitions with no directory
names and no owners. The /ORPHANS qualifier also checks
relationships to ensure that they have valid owners and members.
When you also specify the /FIX qualifier, it places homeless
definitions in a directory called CDD$ORPHANS. CDO creates
directory names for them while the VERIFY command executes. The
/FIX qualifier deletes relationships without valid owners and
members.
CAUTION
If you specify the /ORPHANS qualifier and the /LOG
qualifier, CDO generates text for every element that is not
an orphan. This could potentially be a very large number.
2.9 /REBUILD_DIRECTORY
Format options:
/REBUILD_DIRECTORY
/NOREBUILD_DIRECTORY (default)
Specifies whether CDO checks that the repository is in the
correct directory and is correctly referenced by other
repositories on the system, then deletes and re-creates all
directory entries for the repository anchor you specify. If
there are no directories to delete and re-create, the /REBUILD_
DIRECTORY qualifier builds a directory for the repository.
Use the /REBUILD_DIRECTORY qualifier to recover a corrupted
repository system only when corruption is so severe that all
other qualifiers fail. The /REBUILD_DIRECTORY qualifier requires
SYSPRV or BYPASS privilege.
NOTE
Use system backup utilities to back up your repository
before using the /FIX qualifier or the /REBUILD_DIRECTORY
qualifier. See Using Oracle CDD/Repository on OpenVMS
Systems for information on performing a backup operation.
3 – Description
The VERIFY command determines whether a repository is
structurally correct. This command requires read access. If you
include the /FIX qualifier, you may also need write access. The
/FIX qualifier requires SYSPRV or BYPASS privilege.
The /COMPRESS and /REBUILD_DIRECTORY qualifiers correct the
errors they encounter; all other qualifiers require the /FIX
qualifier to correct errors. The /ALL qualifier corrects any
errors it finds if the logical name CDD$VERIFY_ALL_FIX has been
defined.
The /COMPRESS qualifier requires the following:
o You must have SYSPRV privilege. Otherwise, CDO displays a no
privilege error.
o You must issue the VERIFY command with the /COMPRESS qualifier
as the first CDO command in a CDO session. Otherwise, CDO
reports a conflict error with other users.
o You must be the only user of the repository when you issue the
VERIFY/COMPRESS command. Otherwise, CDO reports an Oracle Rdb
lock conflict error.
If you are working with remote repositories, issue the VERIFY
/EXTERNAL_REFERENCES command by itself before you issue the
VERIFY/EXTERNAL_REFERENCES command with the /FIX qualifier. If
a remote device is not mounted, the VERIFY/EXTERNAL_REFERENCES
command returns an error that the /FIX qualifier attempts to
correct. Until a device is mounted, the command cannot complete.
Use the VERIFY/LOCATION command if you issued the OpenVMS
DCL COPY command to copy a repository or change the name of
your anchor directory. Use the /LOCATION qualifier with the
/EXTERNAL_REFERENCES qualifier if you have other repositories
that reference the repository you are verifying.
4 – Examples
CDO> VERIFY /LOCATION /FIX [SMITH.REP]
In this example, the VERIFY /LOCATION /FIX command checks that
the [SMITH.REP] repository is in the correct directory and is
correctly referenced by other repositories on the system. This
command also corrects any errors detected.