CA VIEW - Database Peak Utilization
Article ID: 198943
Updated On:
Products
OM Deliver
OM 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).
//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).
Feedback
Yes
No
Powered by
