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:
Alias: none
Type: 9 (Critical Report)
Purpose:
This Critical Report shows all files which use the secondary address converter, i.e. spanned records.
Alias: none
Type: 9 (Critical Report)
Purpose:
This Critical Report shows all databases with an Adabas Version lesser than 8.
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.
Alias: none
Type: 9 (Critical Report)
Purpose:
This Critical Report shows all databases with run in a cluster environment, i.e. with NUCID > 0.
Alias: none
Type: 5 (General Evaluation)
Purpose:
This evaluation shows the historical development of disk-related ASF fields (including AC2 values) of a file.
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.
Alias: none
Type: 9 (Critical Report)
Purpose:
This Critical Report shows all files with 10 or less free file extents.
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.
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.
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.
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).
Alias: none
Type: 9 (Critical Report)
Purpose:
This Critical Report shows all files which have a MINISN greater than 1.
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.
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).
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.
Alias: none
Type: 1 (General Evaluation)
Purpose:
This evaluation shows the development of the ADARUN parameters over a period of time.
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.
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.
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).
Alias: none
Type: 9 (Critical Report)
Purpose:
This Critical Report lists all files for which statistical data is stored.
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.
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.
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.
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.
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.
Alias: none
Type: 10 (Critical Trend)
Purpose:
This Critical Trend Report shows predicted disk space problems.
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.
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.
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.
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.
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.
Alias: SA3
Type: 3 (General Evaluation)
Purpose:
This evaluation shows the most database-related ASF fields of several databases at a point in time.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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..
