Class Container Sizes 

In the statistics user menu in the liveCache Assistant, you can find, among other things, displays for the sizes of class containers.

The current table sizes are determined by a report and saved in a database table which forms the history of table sizes and table growth. You can view this data in the Class Container Sizes user menu.

Prerequisites

The user has been assigned a role in accordance with the authorization concept. You are in the user menu of the user with the authorizations that correspond to this role.

Determining Statistical Data

If necessary, you will have to determine the size of the class container.

Procedure

You have the following options:

·        Schedule the action update class container statistics in the DBA planning calendar every week.
To schedule the action Update Class Container Statistics, proceed as described in  Scheduling an Action.

·        You can also update the class container sizes once in the Database Assistant or liveCache Assistant.
Choose the function Update Class Container Statistics in the user menu Statistics → Class Container Sizes to start up a background job which updates the sizes.

Result

The class container sizes are determined. The measurement data is logged in the table SDBCCMS.

Displaying Class Container Sizes

Once the sizes have been determined, you can display them as follows:

Procedure

...

       1.      In the user menu, choose liveCache Assistant(transaction LC10).

       2.      Enter the name of the database connection.

You can select the name from the list of existing names. You can restrict the search for the required name.

       3.      Choose liveCache → Monitoring.

       4.      Choose Statistics → Class Container Sizes.

Result

You can choose from the following displays:

·        Class Containers with Greatest Growth

You can set the comparison time period, comparison interval, and the number of class containers displayed.

·        Largest Class Container

You can set the date and the number of class containers displayed.

You can display everything as graphics.

The following functions are available:

·        Toggle Aggregated/Unaggregated View

·        History of a Class
Select the desired class.

·        Delete Statistics Data
Deletion can be done manually by specifying a time period/date or automatically by specifying a time period (in weeks).

·        Update Class Container Statistics
Note that the class container information is saved only once a day. Older daily statistics, if any, are overwritten.

See also:

Class Container