Oracle RMU Reference Manual

Oracle Rdb7(tm) for OpenVMS

Oracle RMU(tm) Reference Manual

Release 7.0

Part No. A41741-1

Corporate Copyright Notice

IMPORTANT - READ CAREFULLY BEFORE VIEWING AND/OR USING THIS DOCUMENTATION IN ANY WAY. NO PART OF THIS DOCUMENTATION MAY BE REPRODUCED OR TRANSMITTED IN ANY FORM OR BY ANY MEANS, ELECTRONIC OR MECHANICAL, FOR ANY PURPOSE, WITHOUT THE EXPRESS WRITTEN PERMISSION OF ORACLE CORPORATION.

This software contains proprietary information of Oracle Corporation; it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free.

Restricted Rights Legend Programs delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the programs shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, programs delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the programs shall be subject to the restrictions in FAR 52.227-14, Rights in Data---General, including Alternate III (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

The programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, back up, redundancy and other measures to ensure the safe use of such applications if the programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the programs.

Oracle is a registered trademark of Oracle Corporation, Redwood City, California. Hot Standby, Oracle CDD/Repository, Oracle CODASYL DBMS, Oracle Expert, Oracle Rdb, Oracle RMU, Oracle RMUwin, Oracle SQL/Services, Oracle Trace, and Rdb7 are trademarks of Oracle Corporation, Redwood City, California.

All other company or product names are used for identification purposes only and may be trademarks of their respective owners.

Send Us Your Comments

Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this publication. Your input is an important part of the information used for revision.

You can send comments to us in the following ways:

Electronic mail --- nedc_doc@us.oracle.com
FAX --- 603-897-3334 Attn:Oracle Rdb Documentation

Postal service

Oracle Corporation 
Oracle Rdb Documentation 
One Oracle Drive
Nashua, NH  03062
USA

If you like, you can use the following questionnaire to give us feedback. (Edit the online release notes file, extract a copy of this questionnaire, and send it to us.)

Did you find any errors?
Is the information clearly presented?
Do you need more information? If so, where?
Are the examples correct? Do you need more examples?
What features did you like most about this manual?

If you find any errors or have any other suggestions for improvement, please indicate the chapter, section, and page number (if available).

Preface

Purpose of This Manual

Oracle Rdb is a general-purpose database management system based on the relational database model. Oracle RMU, the Oracle Rdb management utility, is the portion of Oracle Rdb that you can use to perform database maintenance tasks, and monitor and display information about Oracle Rdb databases.

This manual provides the syntax, semantics, and reference material for Oracle RMU.

Intended Audience

To use this manual effectively, you should be familiar with data processing procedures, basic database management concepts and terminology, and the OpenVMS operating system.

Structure

This manual contains three chapters, one appendix, and an index, as follows:

Chapter 1 Describes the new and changed features for Oracle Rdb V7.0.

Chapter 2 Describes the syntax and semantics of Oracle RMU commands. Oracle RMU commands allow you to display information about, monitor, and manage Oracle Rdb databases.

Chapter 3 Describes the syntax and semantics of the RMU/ALTER commands available in the RdbALTER utility.

Appendix A Describes the date-time syntax generated for specially formatted output files (.rrd files) by some Oracle RMU commands.

Related Manuals

For more information on Oracle Rdb, see the other manuals in this documentation set. See the Oracle Rdb7 Release Notes for a list of manuals in the Oracle Rdb documentation set.

Oracle RMU Command Syntax Diagrams

This manual uses the following conventions to present the syntax of Oracle RMU commands:

Oracle RMU commands and qualifiers appear in initial capitals. Commands and qualifiers can be entered in upper-, lower-, or mixed-case type.
Command parameters and variables are represented in lowercase type These format elements represent parameters or variables for which you must supply a value.
Horizontal ellipsis points (...) mean you can enter additional information, such as parameters or qualifier arguments.
Brackets ([ ]) enclose optional clauses from which you can choose one or none.
A comma (,) separating qualifier arguments means you can specify one or more arguments with the qualifier.
A vertical bar (|) separating qualifier arguments in syntax diagrams means you can specify only one argument with the qualifier.

For example, the following is the format for the RMU Analyze Placement command:

RMU/Analyze/Placement root-file-spec [index-name[,...]]

The Analyze command and the Placement qualifier can be entered as upper-, lower-, or mixed-case type. The root-file-spec parameter indicates that you must supply a root file specification. The index-name enclosed in brackets (and followed by a comma and ellipses in brackets) indicates that you can supply one or more index-names, separated by commas.

RdbAlter Syntax Diagrams

This manual uses syntax diagrams to graphically present the syntax of RdbAlter statements. Syntax diagrams portray optional, required, and repeating characteristics of any Oracle Rdb statement. You can learn the syntax of a command by reading that command's syntax diagram.

To read a syntax diagram, start from the left and follow the arrows until you exit from the diagram at the right. When you come to a branch in the path, choose the branch that contains the option you want. If you want to omit an option, choose the path with no language elements. If a diagram occupies more than one horizontal line, the arrow returns to the left margin. Syntax diagrams can contain:

Names of syntax diagrams
If a diagram is named, the name appears in lowercase type above and to the left of the diagram. Syntax diagrams can refer to each other by name. The equal sign (=) indicates that the name is equivalent to the diagram and that the diagram can be substituted wherever the name appears.
If the diagram contains the name of another diagram, substitute that other diagram where the name appears. Such a substitution is similar to putting the name of a field where "field-name" appears. Most named syntax diagrams appear as subdiagrams following the main diagram.
Keywords
Keywords appear in uppercase type. If a keyword is underlined, you must include it in the command. A keyword without underlining is optional, but the keyword makes the command more readable. Omitting an optional keyword does not change the meaning of a command.
Punctuation marks
Punctuation marks are included in the diagram when required by the syntax of the command.
User-supplied elements
User-supplied elements appear in lowercase type. These elements can include names, expressions, and literals. They are usually defined in text following the diagram.

Figure 1 shows a portion of the syntax diagram for the RdbALTER DISPLAY command.

Figure 1 A Sample Syntax Diagram

DISPLAY	Is in uppercase and underlined on the main line of the diagram. Therefore, you must supply the keyword (which can usually be abbreviated).
page-number	Is in lowercase on a branch of the diagram. Therefore, the page-number clause is optional; if you include it, you must supply a substitute for page-number.
display-data	Is in lowercase on a branch. Because it parallels an empty branch, the display-data clause is optional. The subdiagram expands the definition of display-data.

Conventions

OpenVMS means both the OpenVMS Alpha and OpenVMS VAX operating system.

In this manual, Oracle Rdb refers to Oracle Rdb for OpenVMS. Version 7.0 of Oracle Rdb software is often referred to as V7.0.

The SQL interface to Oracle Rdb is referred to as SQL. This interface is the Oracle Rdb implementation of the SQL standard ANSI X3.135-1992, ISO 9075:1992, commonly referred to as the ANSI/ISO SQL standard or SQL92.

Oracle CDD/Repository software is referred to as the dictionary, the data dictionary, or the repository.

In examples, an implied carriage return occurs at the end of each line, unless otherwise noted. You must press the Return key at the end of a line of input.

The following conventions are also used in this manual:

.
.
. Vertical ellipsis points in an example mean that information not directly related to the example has been omitted.

... Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted.

e, f, t Index entries in the printed manual may have a lowercase e, f, or t following the page number; the e, f, or t is a reference to the example, figure, or table, respectively, on that page.

[ ] In format descriptions, brackets enclose optional clauses from which you can choose one or none. In a prompt, brackets indicate that the enclosed item is the default response. For example, [y] means the default response is Yes.

$ The dollar sign represents the DIGITAL Command Language prompt in OpenVMS and the Bourne shell prompt in Digital UNIX.

boldface
text Boldface type in text indicates a term defined in the text, the glossary, or in both locations.

Next | Contents

Library
Product

Chapter 1	Describes the new and changed features for Oracle Rdb V7.0.
Chapter 2	Describes the syntax and semantics of Oracle RMU commands. Oracle RMU commands allow you to display information about, monitor, and manage Oracle Rdb databases.
Chapter 3	Describes the syntax and semantics of the RMU/ALTER commands available in the RdbALTER utility.
Appendix A	Describes the date-time syntax generated for specially formatted output files (.rrd files) by some Oracle RMU commands.

. . .	Vertical ellipsis points in an example mean that information not directly related to the example has been omitted.
...	Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted.
e, f, t	Index entries in the printed manual may have a lowercase e, f, or t following the page number; the e, f, or t is a reference to the example, figure, or table, respectively, on that page.
[ ]	In format descriptions, brackets enclose optional clauses from which you can choose one or none. In a prompt, brackets indicate that the enclosed item is the default response. For example, [y] means the default response is Yes.
$	The dollar sign represents the DIGITAL Command Language prompt in OpenVMS and the Bourne shell prompt in Digital UNIX.
boldface text	Boldface type in text indicates a term defined in the text, the glossary, or in both locations.