DB2 10.5 for Linux, UNIX, and Windows

UPDATE STMM TUNING command by using the ADMIN_CMD procedure

Update the user preferred database member number on which the self-tuning memory manager (STMM) tuner is created.

Authorization

The privileges that are 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

The value of member-number is an integer.

In a partitioned database environment:

If a valid member number is specified, DB2® database server runs the STMM memory tuner on that member.
If -1 or a nonexistent member number is specified, DB2 database server selects an appropriate member on which to run the STMM memory tuner.

In a DB2 pureScale® environment:

If a valid member number is specified, DB2 database server runs the STMM memory tuner on that member.
If -2 is specified, then the DB2 database server enables STMM tuners to run and tune independently on each member.
If -1 or a nonexistent member number is specified, DB2 database server selects 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 moves to the user preferred STMM tuning member if member-number exists and is an active member. If the specified STMM tuning member does not exist, the DB2 database server selects an appropriate member. After 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.