ASF Tip: E-Mail Alert 'Critical Value Reached'

, , ,
1

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!’ :frowning:
  • Check regularly the current status of the databases and files which can be very time consuming. :expressionless:
  • Use the ASF Critical Report and check the output. :slight_smile:
  • Let ASF send him a mail when a critical value is reached. :smiley:

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 :smiley:

:idea: Adabas Statistics Facility, the long-term Adabas monitor for production environments with NO impact on the overall database performance!
ASF-Concept.jpg

2

Is this ASF a Freeware-Tool?

However, we’ve implemented a similar solution in our Linux-Environment…

3

ASF is an Adabas subproduct written in Natural. It runs on MF (z/OS, VSE, BS2).
It is not free.

4

OK. Then it isn’t interesting anyway. But thanks for answering.

5

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.

6

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:

adaopr DBID=${ADADBID} >/dev/null
if [ $? -eq 0 ]
then
echo "%ADASTA-E-ALRACTI, Database ${ADADBID} already active"
    exit 0
fi