Version 8.1.1
 —  Examples Documentation  —

Supplied Evaluation Profiles

This section summarizes the Evaluation Profiles which are supplied by Software AG as part of the ASF product. Note that if your ASF Profile file was originally loaded with ASF version 7 or before, you may not have all profiles listed below. The profiles delivered with earlier version do not reflect new ASF fields (e.g. AC2 fields). Additionally they do not make use of dynamic database lists, i.e. they specify the sample databases explicitly so that they must be modified before they can used for other environments.

Some Critical Reports reflect Adabas version 7 limits as the maximum of five extents. For Adabas version 8 this limit can be increased or the FREE EXTENTS field can be used for the limit definition.

This document covers the following topics:


AC2-IN-USE

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows all files which use the secondary address converter, i.e. spanned records.

Top of page

ADABAS-VERSION

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows all databases with an Adabas Version lesser than 8.

Top of page

BUFF.EFFICIENCY

Alias: none

Type: 4 (General Evaluation)

Purpose:

This evaluation shows the development of a single database-related ASF data field (for example buffer efficiency, DATA and ASSO reads/writes) in several databases over a period of time.

Top of page

CLUSTER

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows all databases with run in a cluster environment, i.e. with NUCID > 0.

Top of page

FILE-OVERVIEW-A

Alias: none

Type: 5 (General Evaluation)

Purpose:

This evaluation shows the historical development of disk-related ASF fields (including AC2 values) of a file.

Top of page

FILE-OVERVIEW-B

Alias: none

Type: 7 (General Evaluation)

Purpose:

This evaluation shows the status of disk-related ASF data fields of several files at a point in time.

Top of page

FREE-EXTENTS

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows all files with 10 or less free file extents.

Top of page

HEAD-PROFILE-nn

Alias: none

Type: 1-8 (General Evaluation)

Purpose:

Special Evaluation Profiles called Head Profiles are a standard component of ASF. There are 8 such profiles, one per General Evaluation Type, and they contain data which determines the format of the headings which appear in the corresponding Evaluation Reports. The Head Profiles cannot be modified or deleted. The Head Profiles are called HEAD-PROFILE-nn, where nn is a two digit value in the range 01 to 08.

Top of page

IO-ALL-DB

Alias: none

Type: 3 (General Evaluation)

Purpose:

This evaluation shows the I/O usage (for example ASSO reads, DATA reads, logical reads) of several databases at a point in time.

Top of page

IO-ONE-DB

Alias: none

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the I/O usage (for example ASSO reads, DATA reads, logical reads) of a database over a period of time.

Top of page

ISNSIZE3

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows all files which should be upgraded to ISNSIZE 4. It lists the files which uses an ISNSIZE 3 and have a TOPISN close to the highest 3-byte value (TOPISN ≥ 16.000.000).

Top of page

MINISN-SET

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows all files which have a MINISN greater than 1.

Top of page

NEW-AMOUNT-IO

Alias: none

Type: 3 (General Evaluation)

Purpose:

This evaluation shows for condensed records the I/O usage of several databases at a point in time.

Top of page

NEW-AVER-CRIT

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows all databases and files with critical space values (ASSO/DATA Used, File Extents) or some other critical values (Buffer Efficiency, S2 commands, High Index).

Top of page

NEW-DB-IO-1

Alias: none

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of the I/O usage for a single database over a period of time.

Top of page

NEW-DB-PARA

Alias: none

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of the ADARUN parameters over a period of time.

Top of page

NEW-DB-SPACE-1

Alias: none

Type: 1 (General Evaluation)

Purpose:

This evaluation shows for condensed records the development of the database space usage (ASSO/DATA DEFINED/USED) over a period of time.

Top of page

NEW-FILE-FIELDS

Alias: none

Type: 8 (General Evaluation)

Purpose:

This evaluation shows the development of a single file-related ASF data field (mainly new introduced fields) in several files over a period of time.

Top of page

NEW-FILE-FLDS

Alias: none

Type: 8 (General Evaluation)

Purpose:

This evaluation gives an overview of some file fields over a period of time (number of records loaded, updates and commands).

Top of page

NEW-LIST-FILES

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report lists all files for which statistical data is stored.

Top of page

NEW-LIST-FILES-D

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report lists all files of a single database (sample database 26) for which statistical data is stored.

Top of page

NEW-SPACE-DB

Alias: none

Type: 2 (General Evaluation)

Purpose:

This evaluation shows the maximum and minimum values for various disk-related ASF data fields in several databases within a time frame.

Top of page

NEW-SPACE-FILE

Alias: none

Type: 6 (General Evaluation)

Purpose:

This evaluation shows the maximum and minimum values for various file-related ASF data fields in several files within a time frame.

Top of page

PROD-LIMIT-BLUE

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report lists all databases and files where resources are being wasted, such as: ASSO usage under 50%, pool usage under 20%, Normal Index unused blocks greater than 10000 blocks.

Top of page

PROD-LIMIT-RED

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows the databases and files which have reached levels which require immediate attention by the DBA, such as: ASSO or DATA usage over 95%, or files with 4 or more extents.

Top of page

PROD-LIMIT-TREND

Alias: none

Type: 10 (Critical Trend)

Purpose:

This Critical Trend Report shows predicted disk space problems.

Top of page

PROD-LIMIT-YELL

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows the databases and files where the disk-related ASF data fields have reached levels which will require attention by the DBA in the near future, such as: ASSO or DATA usage over 85%, or files with 3 or more extents.

Top of page

PROD-LIMIT-YELL1

Alias: none

Type: 9 (Critical Report)

Purpose:

This Critical Report shows the databases and files where performance-related ASF data fields have reached levels which will require attention by the DBA in the near future. Examples of the fields are: high water marks, S2 commands, format overwrites and throwbacks.

Top of page

RESOURCES-ALL-DB

Alias: none

Type: 3 (General Evaluation)

Purpose:

This evaluation shows the status of resource-related ASF data fields (for example thread usage, command usage) of several databases at a point in time.

Top of page

RESOURCES-ONE-DB

Alias: none

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the historical development of resource-related ASF fields (for example thread usage, command usage) of a database.

Top of page

SAG-ALL-1

Alias: SA1

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of most database-related ASF fields of a database over a period of time.

Top of page

SAG-ALL-3

Alias: SA3

Type: 3 (General Evaluation)

Purpose:

This evaluation shows the most database-related ASF fields of several databases at a point in time.

Top of page

SAG-CMDS-1

Alias: SC1

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of the Adabas commands which have been issued over a period of time.

Top of page

SAG-CMDS-3

Alias: SC3

Type: 3 (General Evaluation)

Purpose:

This evaluation shows the development of the Adabas commands which have been issued at a point in time.

Top of page

SAG-CRIT-10

Alias: S10

Type: 10 (Critical Trend)

Purpose:

This Critical Trend can be used to predict the time when the database or file space usage will become critical.

Top of page

SAG-CRIT-9

Alias: S9

Type: 9 (Critical Report)

Purpose:

This Critical Report monitors databases and files with critical disk space usage. The creation and contents of this profile are described in detail in the section SAG-CRIT-9.

Top of page

SAG-DATABASE-1

Alias: SD1

Type: 1 (General Evaluation)

Purpose:

This evaluation summarizes the development of the disk space usage of a database over a period of time.

Top of page

SAG-DATABASE-2

Alias: SD2

Type: 2 (General Evaluation)

Purpose:

This evaluation gives an accumulated overview of the disk space usage of several databases over a period of time.

Top of page

SAG-DATABASE-3

Alias: SD3

Type: 3 (General Evaluation)

Purpose:

This evaluation gives an overview of the disk space usage of several databases at a point in time.

Top of page

SAG-FILE-5

Alias: SF5

Type: 5 (General Evaluation)

Purpose:

This evaluation summarizes the development of the disk space usage of a file over a period of time.

Top of page

SAG-FILE-6

Alias: SF6

Type: 6 (General Evaluation)

Purpose:

This evaluation gives an accumulated overview of the disk space usage of several files over a period of time.

Top of page

SAG-FILE-7

Alias: SF7

Type: 7 (General Evaluation)

Purpose:

This evaluation gives an overview of the disk space usage of several files at a point in time.

Top of page

SAG-FREE-09

Alias: SF9

Type: 9 (Critical Report)

Purpose:

This Critical Report monitors the disk space usage (free space), whereby all critical limits are expressed as a percentage (60%) of the maximum possible value.

Top of page

SAG-HWM-1

Alias: SH1

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of the maximum database load (High Water Marks) of a database over a period of time.

Top of page

SAG-HWM-3

Alias: SH3

Type: 3 (General Evaluation)

Purpose:

This evaluation gives an overview of the maximum database load (High Water Marks) of several databases at a point in time.

Top of page

SAG-IO-1

Alias: SI1

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of the I/O load of a database over a period of time.

Top of page

SAG-IO-2

Alias: SI2

Type: 2 (General Evaluation)

Purpose:

This evaluation gives an accumulated overview of the I/O load of several databases over a period of time. The creation of the profile SAG-IO-2 is described step by step in the section SAG-IO-2.

Top of page

SAG-IO-3

Alias: SI3

Type: 3 (General Evaluation)

Purpose:

This evaluation gives an overview of the I/O load of several databases at a point in time.

Top of page

SAG-RESSOURCE-1

Alias: SR1

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of memory requirements of a database over a period of time. This indicates the usage of memory and thereby determines areas where too many or too few memory resources have been allocated.

Top of page

SAG-RESSOURCE-3

Alias: SR3

Type: 3 (General Evaluation)

Purpose:

This evaluation gives an overview of the of memory requirements of several databases at a point in time.

Top of page

SAG-SESSION-1

Alias: SS1

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the development of the Adabas session parameters of a database over a period of time.

Top of page

SAG-SESSION-3

Alias: SS3

Type: 3 (General Evaluation)

Purpose:

This evaluation gives an overview of the of the Adabas session parameters of several databases at a point in time.

Top of page

SPACE-ALL-DB

Alias: none

Type: 3 (General Evaluation)

Purpose:

This evaluation shows the status of disk-related ASF data fields (for example ASSO usage, DATA usage) of several databases simultaneously.

Top of page

SPACE-ONE-DB

Alias: none

Type: 1 (General Evaluation)

Purpose:

This evaluation shows the historical development of disk-related ASF fields (for example ASSO usage, DATA usage) of a database..

Top of page