DB2 Version 9.7 for Linux, UNIX, and Windows

UPDATE STMM TUNING DBPARTITIONNUM command using the ADMIN_CMD procedure

Update the user preferred self tuning memory manager (STMM) tuning database partition.

Authorization

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


>>-UPDATE--STMM--TUNING--DBPARTITIONNUM--partitionnum----------><

Command parameter

partitionnum: partitionnum is an integer. If -1 or a nonexistent database partition number is used, DB2® will automatically select an appropriate database partition on which to run the STMM memory tuner.

Example

Update the user preferred self tuning memory manager (STMM) tuning database partition to database partition 3.

CALL SYSPROC.ADMIN_CMD( 'update stmm tuning dbpartitionnum 3' )

Usage notes

The STMM tuning process periodically checks for a change in the user preferred STMM tuning database partition number value. The STMM tuning process will move to the user preferred STMM tuning database partition if partitionnum exists and is an active database partition. Once this command changes the STMM tuning database partition number an immediate change is made to the current STMM tuning database partition number.

Command execution status is returned in the SQLCA resulting from the CALL statement.

This command commits its changes in the ADMIN_CMD procedure.