Administration Tools - oodumpcatalog

Printer-friendly version
Generates a textual report of the files in a federated database.
[-ap apSysName | -id apId]
[-outfile filename
[-exists ask | delete | quit]]
[-format hostlocal | native]
-ap apSysName
(HA) System name of the autonomous partition that controls the files to be listed. You can omit both this option and the -id option to list all of the files in the federated database.
-id apId
(HA) Integer identifier of the autonomous partition that controls the files to be listed. You can omit both this option and the -ap option to list all of the files in the federated database.
-outfile fileName
Name of the file in which to write the generated report. You can edit this file to drive a standard backup tool. You can omit this option to send all output to stdout.
-exists ask | delete | quit
Action to take if the file specified with the -outfile option already exists.
ask Prompts whether to overwrite the existing file. If the answer is No, the program terminates. No is the default.
delete Overwrites the file in the destination directory.
quit Terminates without creating the file.
The default value is ask.
-format hostlocal | native
Format for printing filenames.
hostlocal Filename printed in host format, as hostName::localPath—for example, mach3::/mnt/fred/project/myfd.FDB
native Filename printed as full path using the native operating system’s format—for example, /net/mach3/usr/mnt/project/myfd.FDB
The default value is hostlocal.
Suppresses the labeling of files in the output. By default, each filename in the output is labeled.
(HA) Lists the controlling autonomous partition for each file.
Nonconcurrent mode. Use this option if no lock server is running or to bypass a running lock server.
Warning: Corruption can occur if concurrent access to the federated database is attempted while any process is using this mode.
Suppresses the copyright notice and program title banner. Useful when invoking the tool from another tool or product.
Prints the tool syntax and definition to the screen.
Path to the boot file of the federated database containing the files to be listed. You can omit this argument if you set the OO_FD_BOOT environment variable to the correct path. (HA) You can specify the boot file of any autonomous partition.
This tool shows information from the federated database’s global catalog and from the catalogs of any databases that have external containers. These catalogs describe the properties of objects that are physically represented as files—that is, databases, external containers, autonomous partitions, and database images. (Embedded containers are therefore not listed.)
You typically use this tool to inspect the distributed structure of a federated database or to see the locations and other properties of each file-based object. For example, you can use this tool to find out which databases (if any) have been made read-only or to see whether any databases have external containers.
This tool shows catalog information in a simple textual format. Use ooexportcatalog to represent catalog information in an XML document.
Note: Certain information, such as storage-page size, is displayed only for Release 9.0 (or later) federated databases.
(HA) By default, the output lists the system-database files, boot files, and journal directories of all autonomous partitions. Use the -ap or -id option to report catalog information about the files controlled by a particular autonomous partition.
(HA) The output lists the individual image files for each database that has multiple images. The output also lists the tie-breaker partition, if any, for each database.
See also

Tuesday, October 30, 2012