search cancel

Can I delete a duplicate logical view on a View database?

book

Article ID: 239561

calendar_today

Updated On:

Products

View

Issue/Introduction

I have some users who are having issues with View Indexes.

The problem is with a duplicate logical view.

 

Environment

Release : 14.0

Component : View

Resolution

Summary: Client is looking for the steps to delete duplicate logical views in a View database. 

The below steps will change the indexing for the selected reports:

1. On the command line of the View Primary Selection panel, type "DEF VIEW" to present the list of the logical views.

2. Thoroughly review the full content of the logical views in question, to confirm that they are exact duplicates:

 . . H - Define primary heading criteria

 . . C - Define column specifications  

 . . L - Define color specifications

 . . P - Define page separation 

3. If the logical views are considered exact duplicates, in the logical view list, use the "D" line command to delete the duplicate logical View.

4. Run the following SARGRW Job,

//XXXXXXXX JOB ....
//SARGRW01  EXEC PGM=SARGRW                                         
//STEPLIB  DD   DISP=SHR,DSN=VIEW.CVDELOAD     <=== MODIFY, IF USED                
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(5),,CONTIG)                   
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(5),,CONTIG)                   
//SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(5),,CONTIG)                   
//SYSUDUMP DD SYSOUT=*                                             
//SYSOUT   DD SYSOUT=*                                             
//SYSPRINT DD SYSOUT=*                                             
//OUTFILE  DD SYSOUT=*                                             
//PRTFILE  DD DSN=<Dataset Name>, 
//            DISP=(NEW,CATLG,DELETE),
//            DCB=(RECFM=FB,LRECL=80,BLKSIZE=8000),
//            UNIT=3390,VOL=SER=VVVVVV                                         
//SYSIN    DD *                                                  
/CONTROL SEQ=RID DATABASE='VIEW_HLQ'  <=== MODIFY DB NAME                       
/IF SUBSTR(RID,1,9) = 'REPORT1-1'                                     
/ OUTPUT '/LOAD  ID='      COL(1)                                
/ OUTPUT RID               COL(11)                               
/ OUTPUT 'GEN='            COL(44)                               
/ OUTPUT EDIT(GEN,'99999') COL(48)                               
/ OUTPUT 'SEQ='            COL(54)                               
/ OUTPUT EDIT(SEQ,'99999') COL(58)                               
/END                                                             
/*                                                               
//   

5. Copy the output file to another file

6. Edit the second file replacing '/LOAD ' with '/INDEX'

7. Run the first file (/LOAD) through the below SARBCH Job:

//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   DISP=SHR,DSN=<Dataset Name>                                               
//                  

8. Run the second file (/INDEX) through the above SARBCH Job


* See case unified history for additional Q and A with customer *