CA View - Questions on Report Numbers and Their Retention
Article ID: 208957
Updated On:
Products
Issue/Introduction
Bellow are some common questions related to View management:
1. How to find out on average, how many reports do CA-VIEW per day (per instance)?
2. How to determine how long are reports retained in the CA-VIEW catalog before being migrated to tape?
How can I determine if reports are retained by number of generations or by days.
3. How to find out how many reports are currently cataloged by each instance of CA-VIEW?
4. How to determine how many reports are currently available on tape? (per instance)
5. How to determine if features such as report indexing or cross-report indexing in use?
If so please describe a few examples of how reports are indexed.
What is the maximum number of indices per report?
6. How to determine if the function of Job Name Translation Tables in use?
7. How to determine if the function of SAR System Extensions (SARXTD) in use?
8. How to determine if CA-View are using any JES exits.
9. How to determine if CA-View is using an exit?
Environment
Release : 14.0
Component : CA View
Resolution
Here are the answers to the questions:
1. How to find out on average, how many reports do CA-VIEW per day (per instance)?
. In the SARSTC task log, please note the SARBKT62 message for Phase 1:
SARBKT62 Standard backup cycle ending phase 1. Of mmmm reports on database, nnnn were processed.
. The "nnnn" value indicates how many reports were collected.
. Please note the number of reports processed, add up their values for several days, then divide that by the number of days, to determine an average.
2. How to determine how long are reports retained in the CA-VIEW catalog before being migrated to tape?
How can I determine if reports are retained by number of generations or by days.
. At the next View backup following report collection (SARINIT parameters DAYS=xxxxxxx and TIME=hhmm), reports that have not yet been backed up to tape, get backed up to tape.
. In Phase 2 of the View backup, the retention parameters determine how long something is kept on disk and for how long on tape.
For what retentions are used, please look at the following:
. . SARINIT parameters NGEND and NGENT (retention on disk and tape)
. . If there is a //SARPATAB DD statement in your SARSTC task, it points to the Expanded Retention Option (ERO) table, which indicates retention for individual reports.
3. How to find out how many reports are currently cataloged by each instance of CA-VIEW?
. Run SARBCH /LIST, for a list of all reports (disk and tape) for the database:
//XXXXXXXX JOB ...
//SARBCH EXEC PGM=SARBCH,PARM='VIEW_HLQ' <=== MODIFY DB NAME
//STEPLIB DD DISP=SHR,DSN=VIEW.CVDELOAD <=== MODIFY, IF USED
//SYSPRINT DD SYSOUT=*
//REPORT DD SYSOUT=*
//SYSIN DD *
/LIST ID=* GEN=*
/*
//
4. How to determine how many reports are currently available on tape? (per instance)
. For each View database, run the below SARPAC REPORT JCL, to get cumulative information about the tapes:
//XXXXXXXX JOB ...
//SARPAC EXEC PGM=SARPAC,PARM='VIEW_HLQ,REPORT' <=== MODIFY DB NAME
//STEPLIB DD DISP=SHR,DSN=VIEW.CVDELOAD <=== MODIFY, IF USED
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD DUMMY
//
. In the columns of the report are the following:
. . Total - Total number of reports (active and expired) on the tape.
. . Used Groups - Number of active reports on the tape.
. . Percent - Total number of reports / Number of active reports.
5. How to determine if features such as report indexing or cross-report indexing in use?
If so please describe a few examples of how reports are indexed.
What is the maximum number of indices per report?
. In the View Sysout Selection List, scrolling to the right will show the "D T O I" columns, which indicate if a report resides on the disk layer, on tape, on optical disk, and if it is indexed.
A "Y" in the "I" column indicates that the report is indexed.
. There is no quick method to see if a report takes part in cross-report indexing.
You would have to look at each View logical view (command DEF VIEW), to see if the cross-report indexing field is set to YES.
The maximum number of index levels for a report is 8.
The number of records that can contain an index is up to what is in the report.
6. How to determine if the function of Job Name Translation Tables in use?
. CA Deliver uses the Jobname Translation Table.
In a RMOSTC task, look at //RMOJTAB DD DSN=... to find the name of the member that contains the table.
CA View has no Jobname Translation Table.
7. How to determine if the function of SAR System Extensions (SARXTD) in use?
. As SARXTD is started up, and then goes to the background, my suggestion is to look in your library of procedures, to see if there is a SARXTD task listed there.
Then, look to see what is started up at IPL time, to see if a SARXTD task is mentioned.
8. How to determine if CA-View are using any JES exits.
. There is no way to determine if there are any JES exits in use, that affect View.
9. How to determine if CA-View is using an exit?
. For a View exit, look at the CVDESRC library, to see if there is any exit source that has been altered.
Also, look at the CVDEJCL library, to see if there are JCL streams that were modified to submit an assembly of an exit.
Feedback
