The partition number for which you are adding information. You cannot change this number.
Specifies that you will manage the data set yourself. You will need an ICF catalog name.
Specifies that DB2 create a data set for the partition with the aid of the associated storage group name. The data set is defined during the execution of this statement. DB2 assumes one and only one data set for each partition. The ICF catalog must not contain an entry for the data set.
Specify the ICF catalog name for the data set. This supplies the first level qualifier for the data set name. You must use the short identifier (no more than 8 characters) of the catalog name in the VSAM catalog name field. If the name of the integrated catalog facility (ICF) catalog is longer than eight characters, you must type an alias name in this field. DB2 assumes one data set per partition.
Specify a storage group name. You can type the name or click the button to select one. The storage group must exist at the current server. Each volume serial number must identify a volume that is accessible to MVS for dynamic allocation of the data set. All identified volumes must be of the same device type. The ICF catalog must not contain an entry for the data set.
Opens a window to search for a list of available storage groups to use in this field.
Type a value (PRIQTY) in kilobytes. Valid with DB2 managed data sets only. DB2 specifies the PRIQTY to access method services using the smallest multiple of pKB, where p=the page size of the table space. The allocated space can be greater than the amount of space requested by DB2. At least one of the volumes of the identified storage group must have enough available space for the primary quantity. Otherwise, the primary space allocation will fail.
Type a value (SECQTY) in kilobytes. Valid with DB2 managed data sets only. DB2 specifies the SECQTY to access method services using the smallest multiple of pKB, where p=the page size of the table space. The allocated space can be greater than the amount of space requested by DB2.
Select to erase the data sets during the execution of a utility or an SQL statement that drops the table space. DB2 overwrites all the data in the data sets with zeroes before deletion. If not selected, the data in the data sets is still accessible, though not through DB2.
If selected, you chose a space management scheme in terms of a number of data sets or as a percentage of free space.
Specify how many data pages there should be between each free page. The value selected can be in the range of 0 to 255. If you select a value of 0, no pages are left free. Do not specify an amount here if the table space is in a work file database.
Specify the percentage of each page to leave as free space (PCTFREE) when the table space is loaded or reorganized. The value can be in the range of 0 to 99. Do not specify an amount here if the table space is in a work file database.
Specifies that in a data sharing environment, only the updated pages are written to the group buffer pool.
Specifies that in a data sharing environment, all pages are cached as they are read in from DASD.
Select to compress the data rows after you finish loading a table space.
Submits the data in the window and closes the window.
Closes the window with no changes.