The STEPWISE_REDISTRIBUTE_DBPG procedure redistributes
part of the database partition group according to the input specified
for the procedure, and the setting file created or updated by the
SET_SWRD_SETTINGS procedure.
Syntax
>>-STEPWISE_REDISTRIBUTE_DBPG--(--inDBPGroup--,----------------->
>--inStartingPoint--,--inNumSteps--)---------------------------><
The schema is SYSPROC.
Procedure parameters
- inDBPGroup
- An input argument of type VARCHAR (128) that specifies the name
of the target database partition group.
- inStartingPoint
- An input argument of type SMALLINT that specifies the starting
point to use. If the parameter is set to a positive integer and is
not NULL, the STEPWISE_REDISTRIBUTE_DBPG procedure
uses this value instead of using the nextStep value
specified in the setting file. This is a useful option when you want
to rerun the STEPWISE_REDISTRIBUTE_DBPG procedure from a particular
step. If the parameter is set to NULL, the nextStep value is used.
- inNumSteps
- An input argument of type SMALLINT that specifies the number of
steps to run. If the parameter is set to a positive integer and is
not NULL, the STEPWISE_REDISTRIBUTE_DBPG procedure
uses this value instead of using the stageSize value
specified in the setting file. This is a useful option when you want
to rerun the STEPWISE_REDISTRIBUTE_DBPG procedure with a different
number of steps than what is specified in the settings. For example,
if there are five steps in a scheduled stage, and the redistribution
process failed at step 3, the STEPWISE_REDISTRIBUTE_DBPG procedure
can be called to run the remaining three steps once the error condition
has been corrected. If the parameter is set to NULL, the stageSize value is used. The value -2 can be used in this procedure to indicate that the
number is unlimited.
Note: There is no parameter for specifying the equivalent
of the NOT ROLLFORWARD RECOVERABLE option on
the REDISTRIBUTE DATABASE PARTITION GROUP command.
Logging is always performed for row data redistribution performed
when the STEPWISE_REDISTRIBUTE_DBPG procedure is used.
Authorization
- EXECUTE privilege on the STEPWISE_REDISTRIBUTE_DBPG procedure
- SYSADM, SYSCTRL or DBADM
Example
Redistribute the database partition
group "IBMDEFAULTGROUP" according to the redistribution plan stored
in the registry by the SET_SWRD_SETTINGS procedure. It is starting
with step 3 and redistributes the data until 2 steps in the redistribution
plan are completed.
CALL SYSPROC.STEPWISE_REDISTRIBUTE_DBPG('IBMDEFAULTGROUP', 3, 2)
For a full usage example of the stepwise
redistribute procedures, refer to STEPWISE_REDISTRIBUTE_DBPG procedure.
Usage notes
If the registry value for processState is updated to 1 using
the SET_SWRD_SETTINGS procedure after the STEPWISE_REDISTRIBUTE_DBPG
procedure execution is started, the process stops at the beginning
to the next step and a warning message is returned.
As the
SQL COMMIT statement is called by the redistribute process, running
the redistribute process under a Type-2 connection is not supported.