SARDBI23 Messages Received in Application Job, but View Database Shows to Have Low Usage Percentage

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

If an application job creates many reports that are written directly to CA View by CA Deliver, the View database can temporarily show a high usage percentage and possibly display SARDBI23 messages, in the application job.

 

Environment:
CA View - All ReleasesCA Deliver - All Releases
Cause:

For each STACK report created, there are buffers allocated. 

The allocation is done in terms of blocks, where each block allocation is made according to the size of the corresponding View database's data extent blocksize.

The use of many buffers can make the View database appear to look more heavily used than it actually is. 

Resolution:

In the RMOPARM SARBUFCT parameter description, a recommendation is made to set to SARBUFCT=1 when processing many (thousands of) reports. 

It was suggested to the client that they consider lowering their RMOPARM setting from SARBUFCT=5 to SARBUFCT=3, so that fewer buffers are allocated per report.

Also, it was suggested that the client allocate more data space to their View database.