How to control the return code for Database Space Monitor?

Document ID : KB000047953
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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      xxx 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?

Solution:

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 Reference Guide.