ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA VIEW - Database Peak Utilization

book

Article ID: 198943

calendar_today

Updated On:

Products

Deliver View

Issue/Introduction

The client wants to know if there is a way to determine peak View database/index utilization during the life of a View SARSTC task.

Environment

Release : 14.0

Component : CA View

Resolution

As there is no current View utility that shows peak database utilization, the only suggestion would be to run periodic SARDBASE STATUS FULL jobs:

//XXXXXXXX JOB ...
//SARDBASE EXEC PGM=SARDBASE,PARM='VIEW_HLQ' <=== MODIFY DB NAME
//STEPLIB DD DISP=SHR,DSN=VIEW.CVDELOAD <=== MODIFY, IF USED
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
STATUS FULL
/*
//

Then, with those STATUS FULL outputs, compare the index and data utilizations.

Note: Database utilization will change (mostly, will decrease) after a run of a View backup (SARINIT DAYS=xxxxxxx / TIME=hhmm).