How To
Summary
You can query data deduplication statistics for all types of storage pools.
Steps
1. QUERY OCCUPANCY
2. SELECT * from OCCUPANCY
3. SELECT * from SUMMARY
QUERY OCCUPANCY
Use the QUERY OCCUPANCY command to show how much space client file spaces occupy. Use this command when you want to issue a command from the command line. You can specify a storage pool to query for files from a specified file space.
Restriction: For container storage pools, you cannot view statistics for the node and file space by using the QUERY OCCUPANCY command. You must use the following commands to display node and file space statistics for container storage pools:
- GENERATE DEDUPSTATS
- QUERY DEDUPSTATS
- DELETE DEDUPSTATS
Example
tsm: SERVER1>q occupancy dedup*
Node Name Type Filespace FSID Storage Number of Physical Logical
Name Pool Name Files Space Space
Occupied Occupied
(MB) (MB)
------------------- ------- ------------- ------- --------------- ----------------- ------------ ---------------
DEDUP_N Bkup \\abcde\c$ 17 FILEPOOL 63 10.00 8.00
DEDUP_Y Bkup \\abcde\d$ 18 CONTAINERPOOL 63 - 8.00
The occupancy table shows how much physical space is occupied by a file space after the removal of the deduplicated data. These savings are gained by removing duplicated data from the file space.
SELECT * from OCCUPANCY
Use the SELECT * from OCCUPANCY command as part of report generation and automation.
Tip: In the following examples, the REPORTING_MB field value represents the total amount of data that is backed up to the container storage pool. The REPORTING_MB field value is equivalent to the Logical Space Occupied (MB) field on the QUERY OCCUPANCY command.
Example 1
select * from occupancy where node_name='node1'
NODE_NAME: NODE1
TYPE: Bkup
FILESPACE_NAME: \\filespace1\c$
STGPOOL_NAME: DPOOL
NUM_FILES: 199
PHYSICAL_MB:
LOGICAL_MB:
REPORTING_MB: 241.00
FILESPACE_ID: 66
Example 2
select * from occupancy
NODE_NAME:
TYPE:
FILESPACE_NAME:
STGPOOL_NAME: DPOOL
NUM_FILES: 703
PHYSICAL_MB:
LOGICAL_MB:
REPORTING_MB: 518.04
FILESPACE_ID:
When no value is displayed for both the NODE_NAME and FILESPACE_NAME fields, the storage pool that is queried is a container storage pool.
SELECT * from SUMMARY
Use the SELECT * from SUMMARY command to display summary record information from sessions and processes. The command has 4 new fields that only display for container storage pools in V7.1.3:
| Field | Description |
| BYTES_PROTECTED |
This is the number of bytes of protected data. It is the sum of BYTES_WRITTEN, DEDUP_SAVINGS, and COMP_SAVINGS fields. |
| BYTES_WRITTEN | This is the number of bytes that are written to media. |
| DEDUP_SAVINGS | The number of bytes that was saved by using data deduplication. |
| COMP_SAVINGS | The number of bytes that was saved by using compression after data deduplication savings are applied. |
Example
select * from summary where entity='spectrum'
START_TIME: 2015-08-04 14:25:11.000000
END_TIME: 2015-08-04 14:25:48.000000
ACTIVITY: BACKUP
NUMBER: 3
ENTITY: SPECTRUM
COMMMETH: Tcp/Ip
ADDRESS: spectrum.ibm.com
SCHEDULE_NAME:
EXAMINED: 198
AFFECTED: 198
FAILED: 0
BYTES: 129855163
BYTES_PROTECTED: 252689980
BYTES_WRITTEN: 129934931
DEDUP_SAVINGS: 101248920
COMP_SAVINGS: 21506129
IDLE: 2
MEDIAW: 0
PROCESSES: 3
SUCCESSFUL: YES
VOLUME_NAME:
DRIVE_NAME:
LIBRARY_NAME:
LAST_USE:
COMM_WAIT: 11
NUM_OFFSITE_VOLS:
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
18 March 2020
UID
ibm13121257