Progress Storage Area Test

Storage areas are the largest physical unit of a database. Storage areas consist of one or more extents that are either operating system files, or some other operating system level device that is addressed randomly. A storage area is a distinct address space, and any physical address stored inside the area is generally stored relative to the beginning of the storage area.

Storage areas are identified by their names. The number and type of storage areas used varies from database to database; however, all Progress databases contains a control area, a schema area, and a primary recovery area. Certain storage areas have restrictions on the types of extents they support. The storage areas of the Progress database is briefed below:

Control Area: The control area contains only one variable-length extent: the database structure extent, which is a binary file with a .db extension.

Schema Area: The schema area can contain as many fixed-length extents as needed; however, every schema area should have a variable-length extent as its last extent.

Primary Recovery Area: The primary recovery area can contain as many fixed-length extents as needed, as long as the last extent is of variable length.

Application Data Area: The application data storage area contains all application-related database objects.

Transaction Log Area: The transaction log storage area, used for two-phase commit, uses only fixed-length extents but can use more than one. The other storage areas can use many extents but only one variable-length extent, which must be the last extent.

This test auto-discovers all the storage areas of the Progress database server and tracks the usage of each of these storage areas.

Target of the test : A Progress Database server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every storage area on the target Progress database server that is being monitored

Configurable parameters for the test

Parameter	Description
Test Period	How often should the test be executed
Host	The IP address of the Progress database server.
Port	The port number on which the database server is listening. By default, this is NULL.
Database Name	Specify the name of the Progress database instance that is to be monitored.
Username	In order to monitor a Progress database instance, a special database user account has to be created in every Progress database instance that requires monitoring. This special user needs to be granted a set of privileges. To know how to create the database user and grant the required privileges, refer to Pre-Requisites for monitoring the Progress database. Specify the name of such a user in this text box.
Password	The password of the specified Username.
Confirm Password	Confirm the password by retyping it here.
Detailed Diagnosis	To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option. The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled: The eG manager license should allow the detailed diagnosis capability Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Total size	Indicates the total size of this storage area.	MB	The detailed diagnosis of this measure lists the name of the data files in the storage area, the total size of the data files, the used space of the data files, the free space of the data files and the percentage of space used by the data files. By analyzing the detailed diagnosis, the data file that is utilizing the maximum space can be determined.
Used size	Indicates the amount of storage space that is currently allocated to this storage area.	MB
Free size	Indicates the amount of storage space that is currently available for use in this storage area.	MB
Size usage	Indicates the percentage of storage space that is currently allocated to this storage area.	Percent