DB2 Server for VSE & VM: Operation

SHOW TARGETWS

Displays the current target working storage size of the database.

Syntax

>>-SHOW TARGETWS-----------------------------------------------><

Description

This command displays the following information about the database's:

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

The target working storage size and the working storage size are measured in megabytes. The former is the amount of main and expanded storage that the database manager will try to use for the database. The default is 32 megabytes.

Example

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