IMS Tools

Expand all | Collapse all

TECH TIP: CA IMS Tools DBA Database Space Monitor

  • 1.  TECH TIP: CA IMS Tools DBA Database Space Monitor

    Posted 07-23-2015 07:39 AM

    Do you know How to control the return code for Database Space Monitor?

     

     

    With DBA Database Space Analyzer (DSA) an exception event ends with RC=8 by default.

    IDI7601I FUNCTION RETURN CODE = 0008 (MODULE DSAACTL, SUFFIX(0), OFFSET 072C).
    IDI7602I CUMULATIVE RETURN CODE = 0008.

    This message is informational only. No action is required.

    Also the Message Log for Database Space Analyzer reports with message

     

    DSA0400E      *** DATASETS HAD THRESHOLD EXCEPTIONS.

     

    the number of datasets which had values for the exceeded thresholds specified for that DBD.

    As these are informational messages can we lower the return code?

     

    By default an "exception" is treated as analogous to a "pointer error", which also gives a return code of 8, so this makes it consistent with Database Analyzer. Additionally, environmental problems, such as "unable to allocate storage" give a return code of 12.

    There are three return-code controlling keywords which can be used to lower the return code for Database Space Analyzer:
    RCDSNEXCP, RCVOLEXCP, and RCNOINFO. Use these control statements to override the default value of the return code when thresholds are exceeded.

    The exceptions are reported in the exception reports (DSARPTS).

    For further details please refer to the CA Database Analyzer for IMS Reference Guide.

     

     

     



  • 2.  Re: TECH TIP: CA IMS Tools DBA Database Space Monitor

    Posted 07-23-2015 11:03 AM

    Addional NOTE: the current CA Database Management for IMS r18 Guides can be found at documentation platform wiki.ca.com/ims