Object Administration Utility Default Values
The Object Administration Default Values screen (Object Administration Default Values screen) displays when you select option 5 from the User Parms menu. It lets you specify the default table space and database and is also used to set default values for table space and index creation.
Object Administration Default Values screen
COMMAND ===>
Display Object Administration "Getting Started" Window ===> Y (Y/N)
DATABASE Name ===> DBNAME
TABLESPACE Name ===> TSNAME
-------------------------- TABLESPACE Creation Default Values ------------------
STOGROUP ===> STOGP FREEPAGE ===> BUFFERPOOL ===> BPO
PRIQTY(K) ===> PCTFREE ===> 25 LOCKSIZE ===> ANY
SECQTY(K) ===> CLOSE ===> YES
ERASE ===> NO
TRACKMOD ===> SEGSIZE ===>
-- OR --
VCAT ===>
--------------------------- INDEX Creation Default Values ----------------------
STOGROUP ===> STOGP FREEPAGE ===> ===> 4
PRIQTY(K) ===> PCTFREE ===> 25 BUFFERPOOL ===> BPO
SECQTY(K) ===> COPY ===> CLOSE ===> YES
ERASE ===> NO
COPY ===>
-- OR --
VCAT ===>
Display Object Administration “Getting Started” Window (Y/N)
Displays the Getting Started with the Object Administration Utility window, once you are within Object Administration. Refer to Getting Started with the Object Administration Utility for more information.
DATABASE Name
Name of the database used as a default.
TABLE SPACE Name
Name of the table space used as a default.
Table space Creation Default Values Area
STOGROUP
Name of the set of volumes where the Db2 data for the table space is stored. This field and the VCAT field are mutually exclusive.
PRIQTY
Amount of space (in kilobytes) for the data set where your table space or partition resides.
SECQTY
Amount of space (in kilobytes) allocated for the data set if it exceeds the primary quantity.
ERASE
Specify whether the data set is erased if it is dropped.
TRACKMOD
Indicate whether Db2 tracks modified pages in the space map pages of the tables pace or partition.
VCAT
VSAM catalog that contains the data sets for the table space. This field and the STOGROUP field are mutually exclusive.
FREEPAGE
Rate at which a page is left free when the table space or partition is loaded or reorganized.
PCTFREE
Percentage of each page left free when the table space or partition is loaded or reorganized.
BUFFERPOOL
Name of the buffer pool associated with the table space.
LOCKSIZE
Required locking level for the table space. Valid entries are ANY, PAGE, TABLESPACE, and TABLE.
CLOSE
Indicate whether the data sets supporting the table space are closed when no users are using the table space.
SEGSIZE
Specify whether the table space is segmented, and if so, how many pages are assigned to each segment.
Index Creation Default Values Area
STOGROUP
Name of the set of volumes where the Db2 data for an index is stored. This field and the VCAT field are mutually exclusive.
PRIQTY
Amount of space (in kilobytes) allocated for the data set where your index resides.
SECQTY
Amount of space (in kilobytes) allocated for the data set if it exceeds the primary quantity.
ERASE
Indicate whether the data set is erased if it is dropped.
COPY
Indicate whether Image copy of the index is allowed.
VCAT
VSAM catalog containing the data sets for the index. This field and the STOGROUP field are mutually exclusive.
FREEPAGE
Rate at which a page is left free when the index is created or reorganized.
PCTFREE
Percentage of each page left free when the index is created or reorganized.
BUFFERPOOL
Name of the buffer pool associated with the index.
CLOSE
Indicate whether the data sets supporting the index are closed when no users are using it.
Related topics