Authorities
and privilegesUse the Step Properties notebook (for DB2 UDB reorg) to create a step that can be used to reorganize data in a DB2 Universal Database table.
Note: The table that is to be reorganized must be linked as both the source and target.
To reorganize a table:
Specify information for your step:
In the Name field, you can type a new name for the step. Otherwise, you can keep the name that the Data Warehouse Center automatically supplied for the step. This field is required.
In the Administrator field, type the name of the person who is responsible for the maintenance of this step. This field is optional.
In the Description field, type a business description for your step. This description can be a maximum of 255 characters. This field is optional.
In the Notes field, type detailed information that might be helpful to users who can access this step. This field is optional.
Optional: On the Parameters page, specify information for the reorganization step (the fields on this page are available only if the table that is to be reorganized is linked as both the source and target on the Process Modeler):
In the Using temporary table space field, type the name of the temporary table space that should be used during the reorganization step.
In the Using index field, type the name of the index that should be used during the reorganization step.
On the Processing Options page, in the Agent Site list, select an agent site where you want your step to run. The selections in this list are agent sites that are common to the target table and the step that you are defining.
If you want to have the option to run your step at any time, select the Run on demand checkbox. Your step must be in test or production mode before you can run it.
Optional: Select the Populate externally check box if the step is populated externally, meaning that it is invoked in some way other than by the Data Warehouse Center. The step does not have to have any other means of running in the Data Warehouse Center in order to change the mode to production.
If Populate externally is not selected, then the step must either have a schedule, be linked to a transient table that is input to another step, or be started by another program in order to change the mode to production.
In the Retry area, specify how many times you want the step to run again if it needs to be retried and the amount of time that you want to pass before the next run of the step.
Click OK to accept the parameters specified in this notebook and save the reorganization step.
Related information
Exporting data from a table or view
For more information about temporary table spaces and index fields, see the Administration Guide.