I have some users who are having issues with View Indexes.
The problem is with a duplicate logical view.
Release : 14.0
Component : View
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 *