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