Display Options For Database Allocations And Database Activity Displays
Use this panel to specify filtering criteria for the output that is displayed in the Database Allocations and Database Activity panels.
________________ ZOJDO VTM O2 V550./C DA31 07/24/13 16:58:49 2
> Help PF1 Back PF3
>
> OBJECT ANALYSIS: Enter a selection letter on the top line.
>
> A-DATABASE ALLOCS B-DATABASE ACTIVITY *-DISPLAY OPTIONS
===============================================================================
> DISPLAY OPTIONS FOR
> DATABASE ALLOCATIONS AND DATABASE ACTIVITY DISPLAYS
OJDO
+ Following options applied to both displays ;
: SPACENAM=________ Filter display output by spacename
: BPID=____ " " by buffer pool id
+
+ Following options applied to DATABASE ALLOCATION display
: EXTSDSN>_____ Filter display output by extents/dataset ratio
: MAXEXTS>_____ " " by max extents/dataset
: TYPE=____ " " by object type
+
+ Following options applied to DATABASE ACTIVITY display
: PERCGETP>___ Filter display output by % of getpage activity
: PERCIO>___ " " by % of I/O activity
: RATE=___ Display activity rates or counts (yes/no)
=============================================================================== Navigation
For additional information about other topics, use the PF keys.
Fields
- SPACENAM=
- Enter a spacename (maximum 8 characters) if you
want to limit the displayed information to a particular space or group
of spaces.
You can specify a wildcard by entering a question mark (?), or you can use an asterisk (*) for generic filtering. For example, DSN* would select all databases that begin with DSN, and DSN??010 would select all databases that begin with DSN, end with 010, and have any two characters in between.
- BPID=
- If you want to display database allocation and activity information that applies
only to a particular buffer pool, enter the buffer pool ID. Note: Omit the 'BP' prefix when you specify the buffer pool ID.
- EXTSDSN>
- If you want to display database allocation information that applies only to spaces with more than n extents per data set, enter a number that is greater than 0.
- MAXEXTS>
- If you want to display object allocation information that applies only to spaces with more than n total extents per data set, enter a number that is greater than 0.
- TYPE=
- If you want to limit the displayed information to
a particular object type, enter one of the following values:
- INDX
- An index
- IXCL
- A clone of an index
- LBTS
- A LOB tablespace
- PTIX
- A partitioned index
- PTTS
- A partitioned tablespace
- SEGM
- A segmented tablespace
- TBLS
- A simple tablespace
- TSCL
- A clone of an universal tablespace
- TSPG
- A partition by growth universal tablespace
- TSPR
- A partition by range universal tablespace
- XMTS
- An XML tablespace
- UNDT
- Undetermined
This can occur if the database DBD is currently not loaded in the EDM pool.
- PERCGETP>
- If you want to display database activity information that applies only to spaces with a percentage of total Getpage that is greater than n, enter a number from 0 - 100.
- PERCIO>
- If you want to display database activity information that applies only to spaces with a percentage of total I/O that is greater than n, enter a number from 0 - 100.
- RATE=
- If you want to display database activity information as rates rather than counts, enter YES. The default is NO. Rates are calculated dividing each count field by the interval elapsed time.