When your target server is DB2, you can work with options on the Using Clause tab on the Index or Tablespace editor to specify additional storage parameters in the Using Clause of the CREATE INDEX or TABLESPACE statement in the schema.
To specify DB2 z/OS Using Clause parameters
Work with the following components for the USING specification:
Specifies the name for a user-managed data set.
Specifies the storage group to use. Select a storage group name from the drop-down list.
Specifies the minimum primary space allocation for a DB2-managed data set. Enter an integer in the text box.
Specifies the minimum secondary space allocation for a DB2 managed data set. Enter an integer in the text box.
Specifies that the DB2-managed data set is erased when deleted during the execution of a utility or a SQL statement that drops the index.
Work with the following options for free specification:
Specifies how often to leave a page of free space when index entries are created. Enter an integer in the text box.
Specifies the percentage of each index or tablespace to leave as free space. Enter a value in the text box.
Specify the following group bufferpool option:
Specifies the group bufferpool type. Select a value from the drop-down list; valid values are Changed, All, None, or System.
Note: When you are working on the Index Editor, you cannot select System as a value for the Group Bufferpool Type field.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|