UPDATE STMM TUNING command by using the ADMIN_CMD procedure

The UPDATE STMM TUNING command updates 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:
  • DBADM
  • DATAACCESS
  • SQLADM

Required connection

Database

Command syntax

Read syntax diagramSkip visual syntax diagramUPDATESTMMTUNING MEMBER member-number

Command parameter

member-number
The value of member-number is an integer.
In a partitioned database environment:
  • If a valid member number is specified, the database server runs the STMM memory tuner on that member.
  • If -1 or a nonexistent member number is specified, the 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, database server runs the STMM memory tuner on that member.
  • If -2 is specified, then the database server enables STMM tuners to run and tune independently on each member.
  • If -1 or a nonexistent member number is specified, the database server selects 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 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 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.

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.