# ASF Tip: E-Mail Alert 'Critical Value Reached' **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Adabas-Add-on-Products, Adabas-Administration-and-Monitoring\ **Created:** [June 17, 2005, 4:20pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744 "2005-06-17T16:20:04Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Lukas\_Hundemer](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/lukas_hundemer/32/113_2.png) [@Lukas\_Hundemer](https://techcommunity.softwareag.com/u/Lukas_Hundemer)\ **Post date:** [June 17, 2005, 4:20pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744/1 "2005-06-17T16:20:04Z")
Technical hint for the Adabas Statistics Facility (ASF) There are various possibilities that a database reaches critical values: - short on storage (e.g. file DS used \> 80 %) - running out of extents - 3-byte ISN used for a file and Top ISN is close to possible maximum - high water marks (pool usage) close to maximum - a.m.m. How can a DBA handle this? - Wait until the users tell him ‘Houston, we have got a problem!’ ☹ - Check regularly the current status of the databases and files which can be very time consuming. 😑 - Use the ASF Critical Report and check the output. 🙂 - Let ASF send him a mail when a critical value is reached. 😃 What do I have to do to get that mail alert? - First you need the Adabas Statistics Facility (ASF). - In ASF a Critical Report must be defined which specifies the ‘critical’ values. - Mark the output medium ‘PC-File’ with ‘E’ and save the Critical Report as predefined evaluation. - Specify the mail recipient in the e-Mail profile. - Critical Reports usually run as batch jobs initiated by a system scheduler. - Add a SMTP step to that job, use the workfile 1 of the critical report as input to the SMTP. - Check your in-basket 😃 :idea: Adabas Statistics Facility, the long-term Adabas monitor for production environments with NO impact on the overall database performance! ![ASF-Concept.jpg](https://global.discourse-cdn.com/techcommunity/original/2X/2/235fbb599d2b5cdc2e4b3510786cb413f1ca7b3d.jpeg) ---
**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\ **Post date:** [June 20, 2005, 1:59pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744/2 "2005-06-20T13:59:24Z")
> [@](#): > > First you need the Adabas Statistics Facility (ASF). Is this ASF a Freeware-Tool? However, we’ve implemented a similar solution in our Linux-Environment… ---
**Author:** ![Lukas\_Hundemer](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/lukas_hundemer/32/113_2.png) [@Lukas\_Hundemer](https://techcommunity.softwareag.com/u/Lukas_Hundemer)\ **Post date:** [June 20, 2005, 2:28pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744/3 "2005-06-20T14:28:32Z")
> [@Matthias](#): > > Is this ASF a Freeware-Tool? > … ASF is an Adabas subproduct written in Natural. It runs on MF (z/OS, VSE, BS2). It is not free. ---
**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\ **Post date:** [June 21, 2005, 12:51pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744/4 "2005-06-21T12:51:28Z")
> [@lhu](#): > > It runs on MF (z/OS, VSE, BS2). OK. Then it isn’t interesting anyway. But thanks for answering. ---
**Author:** ![nachiketa](https://avatars.discourse-cdn.com/v4/letter/n/dc4da7/32.png) [@nachiketa](https://techcommunity.softwareag.com/u/nachiketa)\ **Post date:** [September 15, 2006, 1:42pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744/5 "2006-09-15T13:42:06Z")
dear mathais, can you give me some hints on how did you implement monitoring of adabas in linux? i am specifically interested in monitoring if adabas is running and if down restart it. thank you in advance. ---
**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\ **Post date:** [September 25, 2006, 8:35pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744/6 "2006-09-25T20:35:57Z")
> [@nachiketa](#): > > i am specifically interested in monitoring if adabas is running and if down restart it. You can do this with Shell-scripting. To see a good example, please have a look at the script $ADADIR/$ADAVERS/tools/adastart. This script comes with the installation of ADABAS. Here’s a snippet to check, if the database is up: ```auto adaopr DBID=${ADADBID} >/dev/null if [$? -eq 0] then echo "%ADASTA-E-ALRACTI, Database ${ADADBID} already active" exit 0 fi ``` ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 2:38pm UTC](https://techcommunity.softwareag.com/t/asf-tip-e-mail-alert-critical-value-reached/57744/7 "2021-04-02T14:38:50Z")