Procedure documentationClass Container Sizes Locate this document in the navigation structure

 

In the Statistics user menu of 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.

Procedure

Determining Statistical Data

If necessary, you will have to determine the size of the class container. You have the following options to do this:

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

  • You can update the class container sizes as a one-off. To do this, in the user menu of the liveCache Assistant, choose   Statistics   Class Container Sizes   (in the user menu of the DBA Cockpit:   Space   Class Container Sizes  ) and choose the function Update Class Container Statistics, to start a background job that updates the sizes.

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:

  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  .

or

Open the DBA Cockpit (transaction DBACOCKPIT) and choose   Space   Class Container Sizes  .

You can choose the following displays, and can also display the information graphically:

  • Class Containers with Greatest Growth: You can set the comparison time period, comparison interval, and the number of class containers displayed.

  • Largest Class Containers: You can set the date and the number of class containers displayed.

The following functions are available:

  • Toggle Aggregated/Unaggregated View

  • History of a Class: Select the desired class.

  • Delete Statistics Data: You can delete statistics data 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. Any older daily statistics are overwritten.

More Information

liveCache Assistant, Class Containers

DBA Cockpit: SAP MaxDB, Class Container Sizes, Class Containers