DB2 Version 10.1 for Linux, UNIX, and Windows

UPDATE STMM TUNING command using the ADMIN_CMD procedure

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:

Database


>>-UPDATE--STMM--TUNING----MEMBER----member-number-------------><

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.

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' )

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.

For compatibility with previous versions:

DBPARTITIONNUM can be substituted for MEMBER, except when the DB2_ENFORCE_MEMBER_SYNTAX registry variable is set to ON.