Update the user preferred self tuning
memory manager (STMM) tuning database member number.
Authorization
The privileges
held by the authorization ID of the statement must include at least
one of the following authorities:
Required connection
Database
Command syntax
>>-UPDATE--STMM--TUNING----MEMBER----member-number-------------><
Command parameter
- member-number
- member-number is an integer. In a partitioned
database environment, if -1 or a nonexistent member
number is used, DB2® will automatically
select an appropriate member on which to run the STMM memory tuner.
In a DB2 pureScale® environment, if -1 or a nonexistent member number is used, DB2 will randomly select an appropriate
member on which to run the STMM memory tuner.
Example
In a partitioned database environment,
update the user preferred self tuning memory manager (STMM) tuning
database partition to member 3.
CALL SYSPROC.ADMIN_CMD( 'update stmm tuning member 3' )
Usage notes
- The STMM tuning process periodically checks for a change in the
user preferred STMM tuning member number value. The STMM tuning process
will move to the user preferred STMM tuning member if member-number exists and is an active member. Once this command changes the STMM
tuning member number an immediate change is made to the current STMM
tuning member number.
- Command execution status is returned in the SQLCA resulting from
the CALL statement.
- This command commits its changes in the ADMIN_CMD procedure.
Compatibilities
For compatibility
with previous versions:
- DBPARTITIONNUM can be substituted for MEMBER, except when the DB2_ENFORCE_MEMBER_SYNTAX registry variable is set to ON.