Displays the contents of the AIP (Area Inventory Pages)
structure. The AIP structure provides a mapping for logical areas
to physical areas as well as describing each of those logical
areas. Information such as the logical area name, length of the
stored record, storage thresholds and other information can be
displayed using this simple command interface.
1 – Description
The RMU Show AIP command allows the database administrator to
display details of selected logical areas or all logical areas in
the database.
2 – Format
(B)0[mRMU/Show AIP root-file-spec [larea-name]
[4mCommand[m [4mQualifiers[m x [4mDefaults[m
x
/Brief x See description
/Larea=(n [,...]) x See description
/Parea=(n [,...]) x See description
/Option=Rebuild_Spams x See description
/Output=output-filename x /Output=SYS$OUTPUT
/Type=type-name x See description
3 – Parameters
3.1 – root-file-spec
The file specification for the database root file to be
processed. The default file extension is .rdb.
3.2 – larea-name
An optional parameter that allows the logical areas to be
selected by name. Only those AIP entries are displayed. This
parameter is optional and will default to all logical areas being
displayed.
Any partitioned index or table will create multiple logical areas
all sharing the same name. This string may contain standard
OpenVMS wildcard characters (% and *) so that different names
can be matched. Therefore, it is possible for many logical areas
to match this name.
The value of larea-name may be delimited so that mixed case
characters, punctuation and various character sets can be used.
4 – Command Qualifiers
4.1 – Brief
Brief
Displays AIP information in a condensed, tabular form (see
example below).
4.2 – Larea
Larea=(n [,...])
Specifies a list of logical area identifiers. The LAREA qualifier
and larea-name parameter are mutually exclusive. The default
if neither the LAREA or PAREA qualifiers nor the larea-name
parameter is specified is to display all AIP entries.
4.3 – Parea
Parea=(n [,...])
Specifies a list of physical area identifiers. The PAREA
qualifier and larea-name parameter are mutually exclusive. The
default if neither the PAREA or LAREA qualifiers nor the larea-
name parameter is specified is to display all AIP entries.
4.4 – Option
Option=REBUILD_SPAMS
Display only those logical areas which have the REBUILD_SPAMS
flag set.
4.5 – Output
Output [ = output-filename ]
This qualifier is used to capture the output in a named file. If
used, a standard RMU header is added to identify the command and
database being processed. If omitted, the output is written to
SYS$OUTPUT and no header is displayed.
4.6 – Type
Type = type-name
Legal values for type-name are TABLE, SORTED_INDEX, HASH_INDEX,
LARGE_OBJECT, and SYSTEM_RECORD.
This qualifier is used in conjunction with larea-name to select
a subset of the AIP entries that may match a name. For instance,
it is legal in Rdb to create a table and an index with the name
EMPLOYEES. So using EMPLOYEES/TYPE=TABLE will make the selection
unambiguous. It also allows simpler wildcarding. Commands using
*EMPLOYEE*/TYPE=TABLE will process only those tables that match
and not the associated index logical areas.
5 – Usage Notes
o The database administrator requires RMU$DUMP privilege as
this command is closely related to the RMU DUMP LAREA=RDB$AIP
command.
o Only AIP entries that are in use are displayed. In contrast,
the RMU Dump command also displays deleted and unused AIP
entries.
6 – Examples
Example 1
This example uses the name of a known database table to display
details for this single logical area.
$ RMU/SHOW AIP SQL$DATABASE JOBS
Logical area name JOBS
Type: TABLE
Logical area 85 in mixed physical area 7
Physical area name JOBS
Record length 41
Thesholds are (0, 0, 0)
AIP page number: 151
ABM page number: 0
Snapshot Enabled TSN: 64
Example 2
The wildcard string "*EMPLOYEE* matches both indices and table
logical areas, so here we use /TYPE to limit the display to just
table logical areas. The table EMPLOYEES in the MF_PERSONNEL
database is partitioned across three storage areas and hence
there exists three logical areas.
$ RMU/SHOW AIP SQL$DATABASE *EMPLOYEE*/TYPE=TABLE
Logical area name EMPLOYEES
Type: TABLE
Logical area 80 in mixed physical area 3
Physical area name EMPIDS_LOW
Record length 126
Thesholds are (0, 0, 0)
AIP page number: 150
ABM page number: 0
Snapshot Enabled TSN: 4800
Logical area name EMPLOYEES
Type: TABLE
Logical area 81 in mixed physical area 4
Physical area name EMPIDS_MID
Record length 126
Thesholds are (0, 0, 0)
AIP page number: 151
ABM page number: 0
Snapshot Enabled TSN: 1504
Logical area name EMPLOYEES
Type: TABLE
Logical area 82 in mixed physical area 5
Physical area name EMPIDS_OVER
Record length 126
Thesholds are (0, 0, 0)
AIP page number: 151
ABM page number: 0
Snapshot Enabled TSN: 1504
Example 3
This example shows the REBUILD_SPAMS option used to locate
logical areas that require SPAM rebuilds. This may occur because
the stored row length changed size or THRESHOLDS were modified
for the index or storage map.
$ RMU/SHOW AIP/OPTION=REBUILD_SPAMS
_Root: SQL$DATABASE
_Logical area name:
Logical area name ACCOUNT_AUDIT
Type: TABLE
Logical area 86 in uniform physical area 1
Physical area name RDB$SYSTEM
Record length 12
Thesholds are (10, 100, 100)
Flags:
SPAM pages should be rebuilt
AIP page number: 151
ABM page number: 1004
Snapshot Enabled TSN: 5824
Logical area name DEPARTMENTS_INDEX
Type: SORTED INDEX
Logical area 94 in uniform physical area 10
Physical area name DEPARTMENT_INFO
Record length 430
Thesholds are (30, 65, 72)
Flags:
SPAM pages should be rebuilt
AIP page number: 151
ABM page number: 2
Snapshot Enabled TSN: 7585
Example 4
The /BRIEF qualifier specifies that a condensed tabular output
format be used. The /PAREA qualifier is used here to specify that
only logical areas stored in physical areas 4 and 5 are to be
displayed.
$ RMU /SHOW AIP /BRIEF MF_PERSONNEL /PAREA=(4,5)
*------------------------------------------------------------------------------
* Logical Area Name LArea PArea Len Type
*------------------------------------------------------------------------------
RDB$SYSTEM_RECORD 60 4 215 SYSTEM RECORD
RDB$SYSTEM_RECORD 61 5 215 SYSTEM RECORD
EMPLOYEES_HASH 79 4 215 HASH INDEX
EMPLOYEES 82 4 121 TABLE
JOB_HISTORY_HASH 85 4 215 HASH INDEX
JOB_HISTORY 88 4 42 TABLE
DEPARTMENTS_INDEX 89 5 430 SORTED INDEX
DEPARTMENTS 90 5 55 TABLE
The columns displayed include:
o Logical Area Name - Name of the logical area stored in the AIP
entry
o LArea - Logical area number stored in the AIP entry
o PArea - Physical area number stored in the AIP entry
o Len - Object length stored in the AIP entry
o Type - Object type stored in the AIP entry. The following
object types may be displayed:
o UNKNOWN - The logical area type is unknown or has not been
set
o TABLE - A data table type
o SORTED INDEX - A sorted index type
o HASH INDEX - A hashed index type
o SYSTEM RECORD - A system record type
o LARGE OBJECT - A large object (BLOB) type