1 – ABMS Only
Specifies that the RMU/DUMP command will only dump ABM pages
in uniform storage areas or in logical areas contained within
uniform storage areas.
The ABM pages can be dumped within a limited page range specified
by the START and END qualifiers.
If there are no ABM pages within the specified page range or
the storage area is a mixed format area or the logical area
is contained within a mixed storage area, no ABM pages will be
dumped.
This qualifier cannot be specified in the same Dump command as
the SPAMS_Only qualifier. This qualifier cannot be specified in
the same Dump command with the Snapshots qualifier.
2 – Areas
Areas [=storage-area-list]
Noareas
Specifies a display that consists of storage area pages. You can
specify storage areas by name or by the area's ID number.
If you specify more than one storage area, separate the storage
area names or ID numbers in the storage area list with a comma,
and enclose the list within parentheses.
You can also specify the Areas=* qualifier to display all storage
areas. If you do not specify the Areas qualifier, none of the
storage areas are displayed.
You can use the Start and End qualifiers to display a range of
storage area pages.
The Areas qualifier can be used with indirect file references.
See the Indirect-Command-Files help entry for more information.
3 – End
End=integer
Specifies the highest-numbered area or snapshot page to include
in the display. The default is the last page.
If you also use the Lareas qualifier, note that the Start and End
qualifiers specify a page range relative to the logical area, not
a specific storage area page number.
4 – Header
Header
Noheader
Header[=(detail-opt, type-opts)]
Indicates whether to include the database header in the output.
Specify the Header qualifier to include all database header
information in the output. Specify the Noheader qualifier to
suppress the database header listing. Specify the Header=(detail-
opt, type-opts) qualifier to limit the output from the header to
specific items of interest. Use the detail-opt options (Brief or
Detail) to limit the amount of output. Use the type-opt options
to limit the output to specific types of information.
RMU Dump Command Header Options summarizes the Header options and
the effects of specifying each option.
Table 8 RMU Dump Command Header Options
Option Effect
All Generates the full output of all the header
information. If you specify this option and
other Header options, the other options are
ignored. This is the default option.
Areas Output displays information about active
storage areas and snapshot areas.
Backup Output displays information about backup and
recovery.
Brief Generates a summary of the requested database
root file information.
Buffers Output displays information about database
buffers.
Corrupt_Page Output displays the Corrupt Page Table (CPT).
Detail Generates a complete report of the requested
database root file information. This is the
default.
Fast_Commit Output displays information about whether
fast commit is enabled or disabled, whether
commit to AIJ optimization is enabled or
disabled, the AIJ checkpointing intervals,
and the transaction interval.
Hot_Standby Output displays information regarding hot
standby databases.
Locking Output displays information about database
locking, such as whether or not adjustable
record locking, carry-over lock optimization,
and lock tree partitioning are enabled or
disabled, and fanout factors.
Journaling Output displays information about RUJ and AIJ
journaling.
Nodes Output displays names of nodes that are
accessing the specified database.
Parameters Output displays basic root file header
information.
Root_Record Output describes the Oracle Rdb specific
section of the database root. This includes
backup, restore, verify, and alter timestamps,
as well as flags that indicate that no such
operation has been performed. The bootstrap
DBKEY is used to locate the RDB$DATABASE
row for this database, and then the other
system tables. If an alternate bootstrap
DBKEY exists, then this database has been
converted using RMU Convert Nocommit command.
In this case, the current metadata version is
displayed.
Row_Caches Output displays information about row caches.
Security_Audit Output displays information about security
auditing.
Sequence_Numbers Output displays database sequence numbers.
Users Output displays information about active
database users.
If you specify both the Detail option and the Brief option,
Detail takes precedence. If you specify the All option and other
detail-opt options, the All option takes precedence. If you
specify the Brief option or the Detail option only, the default
for the type-opt is All. If you specify type-opts options, but do
not specify a detail-opt option, the default for the detail-opt
is Detail.
If you specify more than one option, separate the options with
commas and enclose the list within parentheses.
See the Usage_Notes help entry under this command for information
on understanding the derived values found in the database header.
The Header=All and Header=Root_Record qualifiers output
information on the use of the RMU Alter command on the specified
database. For example, you see the following line in the output
if you have never used the RMU Alter command on the database:
Database has never been altered
Do not confuse this with alterations made by SQL ALTER
statements. Information about alterations made with the SQL
ALTER statement is not included in the output from the RMU Dump
command.
If you specify the Areas, Lareas, or Snapshots qualifier, the
Noheader qualifier is the default. Otherwise, Header=(All,
Detail) is the default.
It is invalid to specify the Header=Root_Record and the
Option=Debug qualifiers in the same Oracle RMU command line.
See the Oracle Rdb7 and Oracle CODASYL DBMS: Guide to Hot
Standby Databases manual for information about the "Hot Standby"
references in the database header.
For complete information on the contents of the database header,
see the Oracle Rdb Guide to Database Maintenance.
5 – Lareas
Lareas[=logical-area-list]
Nolareas
Specifies a display that consists of storage area pages allocated
to a logical area or areas. In a single-file database, each table
in the database is stored in its own logical area.
You cannot use the Lareas qualifier with logical areas that are
stored in storage areas that have a mixed page format.
If you specify more than one logical area name, separate the
storage area names in the logical area list with a comma, and
enclose the list within parentheses.
You can also specify the Lareas=* qualifier to display all
logical areas that have a uniform page format.
The default is the Nolareas qualifier.
The Lareas qualifier can be used with indirect file references.
See the Indirect-Command-Files help entry for more information.
6 – Option
Option=type
Specifies the type of information and level of detail the output
will include. Three types of output are available:
o Normal
The output includes summary information. This is the default.
o Full
In addition to the Normal information, the output includes
more detailed information.
o Debug
In addition to Normal and Full information, the output
includes internal information about the data. In general,
use the Debug option for diagnostic support purposes.
7 – Output
Output=file-name
Specifies the name of the file where output is to be sent. The
default is SYS$OUTPUT. The default output file type is .lis, if
you specify a file name.
8 – Restore Options
Restore_Options=file-name
Generates an options file designed to be used with the Options
qualifier of the RMU Restore command.
The Restore_Options file is created by reading the database root
file. Therefore, there is no guarantee that this options file
will work with all backup files you attempt to restore with
a Restore operation. For example, if areas have been added or
deleted from the database since the backup file was created,
there will be a mismatch between the Restore_Options file and the
backup file. Similarly if the backup file was created by a backup
by-area operation, the Restore_Options file may refer to areas
that are not in the backup file.
By default a Restore_Options file is not created. If you
specify the Restore_Options qualifier and a file, but not a file
extension, Oracle RMU uses an extension of .opt by default.
9 – Snapshots
Snapshots[=storage-area-list]
Nosnapshots
Specifies a display that consists of snapshot file pages. The
RMU Dump command does not display snapshot pages if you omit the
Snapshots qualifier or if you specify the Nosnapshots qualifier.
In a single-file database, there is only one snapshot file. In
a multifile database, each storage area has a corresponding
snapshot file. Note that this parameter specifies the storage
area name, not the snapshot file name. If you specify more than
one storage area name, separate the storage area names with
commas, and enclose the storage-area-list within parentheses.
If you specify the Snapshots qualifier without a storage area
name, information is displayed for all snapshot files.
You can use the Start and End qualifiers to display a range of
snapshot file pages.
The default is the Nosnapshots qualifier.
The Snapshots qualifier can be used with indirect file
references. See the Indirect-Command-Files help entry for more
information.
10 – Spams Only
Spams_Only
Allows you to dump only the space area management (SPAM) pages in
the selected areas and page range.
A common usage for the RMU Dump command is to track down problems
with storage allocation and record placement. When this qualifier
is used, the SPAM pages are dumped, allowing you to locate the
individual data pages that you want to examine.
There is no negated form for this qualifier, and, if it is
omitted, all the selected pages are dumped.
The Start and End qualifiers can be used with the Spams_Only
qualifier.
11 – Start
Start=integer
Specifies the lowest-numbered area or snapshot page to include in
the display. The default is the first page; that is, the Start=1
qualifier.
If you also use the Lareas qualifier, note that the Start and End
qualifiers specify a page range relative to the logical area, not
a specific storage area page number.
12 – State
State=Blocked
Specifies a list of all unresolved distributed transactions in
the blocked database. A blocked database is a database that is
not committed or rolled back and is involved in an unresolved
distributed transaction. The State=Blocked qualifier displays the
following information about each transaction:
o Process identification (PID)
o Stream identification
o Monitor identification
o Transaction identification
o Name of the recovery journal
o Transaction sequence number (TSN)
o Distributed transaction identifier (TID)
o Name of the node on which the failure occurred
o Name of the node initiating the transaction (parent node)
You can use the State=Blocked qualifier only with the Users
qualifier. For information on resolving unresolved transactions
with the RMU Dump command, see the Oracle Rdb7 Guide to
Distributed Transactions.
13 – Users
Users
Nousers
Lists information about the current users of the database,
including all users in a VMScluster environment. Oracle RMU does
not consider a process that is running the Performance Monitor
(with the RMU Show Statistics command or through the Windowing
interface) to be a database user.
The default is Nousers.