N2K::DB2::Occupancy - bnw4cristie/TSM-Tricks GitHub Wiki

N2K: DB2 Occupancy vs. Auditocc Table

Meaning of different measures in the OCCUPANCY table

  • LOGICAL_MB is the amount of space that is used by a file space after it is reduced by data deduplication.
  • REPORTING_MB is the amount of space that is occupied before the data is deduplicated.
  • PHYSICAL_MB represents the amount of space that is used by physical files, including empty space within aggregates.
    • In an aggregate TSM collects small files from a single node as well for efficient network transfer as for optimized storage usage and later on storage operations such as migrating, moving, backing up.

Meaning of the entries in the AUDITOCC table

Entry Meaning
BACKUP_MB sum of all data backed up in all primary pools
BACKUP_COPY_MB sum of all data backed up in all copy pools including protect local pools
ARCHIVE_MB sum of all data archived in all primary pools
ARCHIVE_COPY_MB sum of all data archived in all copy pools including protect local pools
SPACEMG_MB sum of all tiered data in all primary pools
SPACEMG_COPY_MB sum of all tiered data in all copy pools
TOTAL_MB total sum of all other measured above
BACKUP_ACTIVE_MB sum of all backup data stored in activedatapools

Important Remarks

Depending on the kind of the storagepool some measures are not accessable:

  • for Directory Container Pools, there will be no values for LOGICAL_MB and PHYSICAL_MB
  • for Tape- and #FILE Devclasses the value for PHYSICAL_MB will be larger due to the space within aggregates, this gap can raise up to 50% (observed by the author)

Example Values

for OCCUPANCY table

Protect: TSM>select NODE_NAME, -
         sum(PHYSICAL_MB)  as "PHYSICAL MB", -
         sum(LOGICAL_MB)   as "LOGICAL MB",  -
         sum(REPORTING_MB) as "REPORTING MB" -
         from OCCUPANCY group by NODE_NAME

NODE_NAME                             PHYSICAL MB                 LOGICAL MB               REPORTING MB
----------------------     ----------------------     ----------------------     ----------------------     
2016-TBMR                               108509.24                  108509.24                  108518.20
CENT65-TBMR                               3382.39                    3382.39                    3382.39
GT56                                         0.05                       0.05                   17070.61
GT57                                                                                            7134.08
LB                                           9.96                       9.96                       9.96
TBMR-L                                    5811.37                    5736.41                    5736.41
WTX                                                                                            13142.77

and the same nodes in the AUDITOCC table

Protect: TSM>select NODE_NAME, TOTAL_MB from auditocc          

NODE_NAME                                TOTAL_MB
----------------------     ----------------------
2016-TBMR                                  108518
CENT65-TBMR                                  3382
GT56                                        17071
GT57                                         7134
LB                                             10
TBMR-L                                       5736
WTX                                         13143