CA View Database Index Space Filling Up or Full.

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

Issue:

Recently, the client has had several CA View databases indicating that their index space was filling.

This has occurred with databases on different systems. 

The client has gone for years without the Indexes filling up on any system.

 

Environment:

CA View

 

Resolution:

The client used SARDBASE ADDDS INDEX, to add index space to the affected databases. 

 

Over time, it is possible for View indexes to experience usage "creep", so that at some point more index space will need to be added. 

This was the case with the client's databases. 

 

Usage "creep" is especially possible with databases that collect JCL as, though they do not contain large reports, they will contain many reports. 

As approximately 2000 bytes of index records are generated for each report in the database, the index could understandably fill up over time. 

 

In a View database's SARDBASE STATUS FULL statistics, a block is consider "used" even if it is only 1% full. 

With that, a percent utilization of a certain value could remain the same over some time.