This section gives a short description of each of the Predefined Evaluations supplied as part of the ASF product. These sample Predefined Evaluations access test ASF data records, so you can activate any of them immediately after installing ASF in order to view some sample ASF reports. You can use them as draft when you create Predefined Evaluations of your own.
This document covers the following topics:
This is a Critical Report, showing ASF data fields 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.
This evaluation uses the Evaluation Profile PROD-LIMIT-RED, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is a Critical Report, showing disk-related ASF data fields which 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.
This evaluation uses the Evaluation Profile PROD-LIMIT-YELL, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is a Critical Report, showing performance-related ASF data fields which 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.
This evaluation uses the Evaluation Profile PROD-LIMIT-YELL1, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is a Critical Report, showing where resources are being wasted, such as: ASSO usage under 50%, pool usage under 20%, Normal Index unused blocks greater than 10000 blocks.
This evaluation uses the Evaluation Profile PROD-LIMIT-BLUE, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is a Critical Trend Report, showing predicted disk space problems.
This evaluation uses the Evaluation Profile PROD-LIMIT-TREND, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 1, showing the historical development of disk-related ASF fields (for example ASSO usage, DATA usage) of a database.
This evaluation uses the Evaluation Profile SPACE-ONE-DB, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 3, showing the status of disk-related ASF data fields (for example ASSO usage, DATA usage) of several databases simultaneously.
This evaluation uses the Evaluation Profile SPACE-ALL-DB, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 5, showing the historical development of disk-related ASF fields of a file.
This evaluation uses the Evaluation Profile FILE-OVERVIEW-A, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 7, showing the status of disk-related ASF data fields of several files simultaneously.
This evaluation uses the Evaluation Profile FILE-OVERVIEW-B, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 1, showing the historical development of I/O-related ASF fields (for example ASSO reads, DATA reads, logical reads) of a database.
This evaluation uses the Evaluation Profile IO-ONE-DB, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 3, showing the status of I/O-related ASF data fields (for example ASSO reads, DATA reads, logical reads) of several databases simultaneously.
This evaluation uses the Evaluation Profile IO-ALL-DB, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 1, showing the historical development of resource-related ASF fields (for example thread usage, command usage) of a database.
This evaluation uses the Evaluation Profile RESOURCES-ONE-DB, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 3, showing the status of resource-related ASF data fields (for example thread usage, command usage) of several databases simultaneously.
This evaluation uses the Evaluation Profile RESOURCES-ALL-DB, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type WE.
This is an evaluation of type 4, showing the development of a single database-related ASF data field (for example buffer efficiency, DATA and ASSO reads/writes) in several databases simultaneously.
This evaluation uses the Evaluation Profile BUFF. EFFICIENCY, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type DA.
This is an evaluation of type 8, showing the development of a single file-related ASF data field (for example, NUM. RECS LOADED) in several files simultaneously.
This evaluation uses the Evaluation Profile NEW-FILE-FIELDS, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type DA.
This is an evaluation of type 2, showing the maximum and minimum values recorded during 1 month for various disk-related ASF data fields in several databases simultaneously.
This evaluation uses the Evaluation Profile NEW-SPACE-DB, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type DA.
This is an evaluation of type 6, showing the maximum and minimum values recorded during 1 month for various file-related ASF data fields in several databases simultaneously.
This evaluation uses the Evaluation Profile NEW-SPACE-FILE, and accesses ASF records which were stored using the Store Profile TEST-DB-ALL and Store Type DA.
This shows all databases and files for which data is stored. The list is generated by using a Critical Report in an unusual way, namely by specifying the search criteria as "every database and file whose ID is greater than 0". Since this is true for all databases and files, the Critical Report will display them all.
This evaluation uses the Evaluation Profile NEW-LIST-FILES, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type DA.
This shows all files of single database for which data is stored. The list is generated by generating a Critical Report using the same technique as for Predefined Evaluation 18.
This evaluation uses the Evaluation Profile NEW-LIST-FILES-D, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type DA.
The slots for the predefined evaluations 20-24 are empty. You can use them for your own predefined evaluations.
This is an evaluation of type 1, showing values for I/O related ASF data fields for a single database on a daily basis over a period of 3 months.
This evaluation uses the Evaluation Profile NEW-DB-IO-1, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type DA.
This is an evaluation of type 1, showing I/O related ASF data fields from weekly modified average records over a period of 3 months for a database.
This evaluation uses the Evaluation Profile NEW-DB-IO-1, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "+W" (weekly modified average records).
This is an evaluation of type 1, showing the same information as for Predefined Evaluation 26, but based on monthly modified average records instead of weekly modified average records.
This evaluation uses the Evaluation Profile NEW-DB-IO-1, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "+M" (monthly modified average records).
This is an evaluation of type 1, showing the weekly changes which occurred (differences only) for certain nucleus parameters over a period of about 10 weeks for a database.
This evaluation uses the Evaluation Profile NEW-DB-PARA, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "&W" (weekly difference records).
This is an evaluation of type 1, showing the values of nucleus parameters on a daily basis over a period of about 5 weeks for a database.
This evaluation uses the Evaluation Profile NEW-DB-PARA, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type DA.
This is an evaluation of type 1, showing similar values as Predefined Evaluation 28, but showing monthly differences over a period of 4 months.
This evaluation uses the Evaluation Profile NEW-DB-PARA, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "&M" (monthly difference records).
This is an evaluation of type 1, showing the development of disk-related ASF data fields expressed as a weekly difference over a period of several months.
This evaluation uses the Evaluation Profile NEW-DB-SPACE-1, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "&W" (weekly difference records).
This is an evaluation of type 3, showing a comparison of monthly loads in several databases simultaneously.
This evaluation uses the Evaluation Profile NEW-AMOUNT-IO, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "&M" (monthly difference records).
This is an evaluation of type 4, showing a comparison of weekly averages (for non-cumulative ASF data fields such as BUFF. EFFICIENCY) and weekly differences (for cumulative fields such as READ ASSO) in several databases simultaneously over a period of several months.
This evaluation uses the Evaluation Profile BUFF.EFFICIENCY, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "+W" (weekly modified average records).
This is a Critical Report, showing critical ASF data fields in a given monthly modified average record.
This evaluation uses the Evaluation Profile NEW-AVER-CRIT, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "+M" (monthly modified average records).
This is an evaluation of type 8, showing the development of disk-related information for files in the given databases. The values show weekly differences in several files simultaneously over a period of several months.
This evaluation uses the Evaluation Profile NEW-FILE-FLDS, and accesses ASF records which were stored using the Store Profile NEW-TEST-DB-ALL and Store Type "&W" (weekly difference records).