CA View - Questions on Report Numbers and Their Retention

book

Article ID: 208957

calendar_today

Updated On:

Products

CA View

Issue/Introduction

Please let me know your responses to the following questions:

1. How can I find out on average, how many reports do CA-VIEW per day (per instance)?

2. How can I 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 can I find out how many reports are currently catalogued by each instance of CA-VIEW?

4. How can I determine how many reports are currently available on tape? (per instance)

5. How can I 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 can I determine if the function of Job Name Translation Tables in use? 

7. How can I determine if the function of SAR System Extensions (SARXTD) in use? 

8. How can I determine if CA-View are using any JES exits.

9. How can I 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 can I found out, on average, how many reports does a View database collect, 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 can I determine how long are reports retained in the View database 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 can I find out how many reports are currently catalogued by each instance of 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 can I 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 can I 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 can I 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 can I 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 can I determine if 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 can I determine if 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.