book
Article ID: 198943
calendar_today
Updated On:
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.
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).