DB2 Server for VSE & VM: Operation

SET TARGETWS

Sets the target working storage size of the database.

Syntax

>>-SET TARGETWS--n---------------------------------------------><

n

Sets the target working storage size for the database to n megabytes. This limits the amount of main and expanded storage that the database machine will use. While the database machine may exceed this target, the database manager will to keep you at or below it if possible. Valid values are integers from 1 to 999,999 megabytes. The default is 32 megabytes.

Description

This command lets you dynamically change the target working storage size. It also displays the following information about the database's:

• Previous target working storage size
• Current target working storage size
• Current working storage size
• How much of the current working storage is in main storage and how much is in expanded storage.

Example

+--------------------------------------------------------------------------------+
|set targetws 30                                                                 |
|Previous TARGETWS = 32 MB                                                       |
|TARGETWS = 30 MB                                                                |
|Current Working Storage = 5 MB                                                  |
|                          (5 MAIN + 0 EXPANDED)                                 |
|ARI0065I Operator command processing is complete.                               |
+--------------------------------------------------------------------------------+