View - Larger output in PTMP status in View

Products

• View

Issue/Introduction

We have some larger output in PTMP status in View.

Can I migrate large reports to tape, as we are getting short on disk space?

Also, can you please provide a sample job to list the database utilization.

 

Environment

Release : 14.0

Resolution

If a report is in PTMP status, it is on both disk and tape, and:

 . The amount of time it will be on disk is determined by SARINIT HOLDTEMP=nnn. 
    
   The parameter defaults to HOLDTEMP=000, which means that the report on disk will be expired at the next View backup. 

For reports in PTMP status:

 . To get space back, you can issue line command "DD" (Delete Disk). 

    ** DO NOT just use the "D" command, or the report (disk and tape) will be fully deleted. ** 
 
If large reports are in DISK status (not yet backed up to tape):

 . For the task, please issue "/F sarstc,DUMP", to run a standard backup and reports will be backed up to tape. 

 . Reports should, after that, show a location of "PERM". 

 . With a location of PERM, you can then use the "DD" command (as above) to remove the report from the disk layer only. 

Here is SARDBASE JCL to run, to show database utilization:

//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                                                       
/*                                                                
//