Default Profiles

 

Default Profiles are provided for your use with Tivoli Storage Resource Manager. Each default Profile represents a specific statistic that you can gather (which is included in the name of the Profile for convenient identification).

 

When creating Scan jobs, Profile(s) are selected to be used during that job. The Profiles you include in the job determine what statistics are gathered and how they are correlated. This then determines what reports are available for the computers, databases, or tablespaces that you are scanning. If you want all reports to be available, select all of the default Profiles.

 

You can learn to create new Profiles and model the statistics to your requirements as you grow more comfortable with using Tivoli Storage Resource Manager. Creating custom profiles will enable you to find out specific information on certain files or file types throughout your enterprise.

 

Tivoli is the creator of the default Profiles, so you will see their names prefixed by Tivoli within the system. The following table shows the default Profile names and describes their function:

 

Default Profile Name

Description

DB User Space

Gathers statistics about the user space usage within a database or tablespace.

Largest Tables

Gathers statistics on the n largest tables. (20 is the default amount)

Segment Most Extents

Gathers statistics on the n segments with the most extents. (20 is the default amount)

Segment Most Unused Space

Gathers statistics on the n segments with the most empty used space. (20 is the default amount). Empty used space represents the space allocated to a segment that is currently empty/not being used. Gathering this information can help you discover space that can be reclaimed and allocated to other objects. Specifically, use this Profile to:

 

  • find objects that are over-allocated (not using all their associated free space)

 

  • find the free space that exists above a table's "high-water" mark (the "high water mark" is the highest block that was written for a table)

 

  • find segments that have the largest amount of blocks that are not filled

Summary

Summarizes space usage by database or tablespace, such as how many segments are in a tablespace (Oracle only), how many of those segments are tables (Oracle only), indexes, etc.