View - SARDBI23 Message Received Indicating Database Filling Up

Products

• Deliver
• View

Issue/Introduction

Receiving SARDBI23 messages, indicating that the View database data space usage had reached a threshold.

Resolution

Before finding if any data space needed to be added, first see what kind of drop there could be in the data space usage, run a View standard backup (/F sarstc,DUMP).

As a result, the customer data space usage dropped from 87% to 36%, out of critical range.

Reviewed the following SARINIT parameters:

. . DAYS - Changed from DAYS=NNNNNNY to DAYS=NNYNNNY, so that there will be an additional standard backup run on Wednesday, to go with the one standard backup run on Sunday.

. . EROOPT=YES and use of SARSTC //SARPATAB DD ... -The client's ERO table was based on DRETPD and RETPD for retention of all reports.

. . NGENI=... Recommended to set NGENI=3.

. . PRETAIN=TABLE - ERO table is first and only point of retention.

With the change in the DAYS and NGENI parameters, recycle the related SARSTC task.