How do I merge tracking files with a shared database?

Document ID : KB000017386
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

I have three LPARS that share the same Top Secret security database. When I first set up Cleanup, I had a tracking file setup on each LPAR. I see that CA recommends using one shared tracking file. The use of two tracking files is supported but not common because of the additional overhead. So I want to merge the three tracking files into one and use that one for all three LPARS. How do I merge the tracking files?

Solution:

Create a 'composite' DB file by concatenating the current files in IEBGENER SYSUT1. The resulting composite SYSUT2 file should then be updated via the ***#DBU program. The result should be a new 'merged' DB file that can be used moving forward. Fix RO68924 is required to handle duplicated records.

Here is a sample job:

//jobcard 
//STEP1    EXEC PGM=IEBGENER 
//SYSPRINT DD SYSOUT=* 
//SYSUT1   DD DSN=CLEANUP.LPAR1.TRACKING.FILE,DISP=SHR 
//         DD DSN=CLEANUP.LPAR2.TRACKING.FILE,DISP=SHR 
//         DD DSN=CLEANUP.LPAR3.TRACKING.FILE,DISP=SHR 
//SYSUT2   DD DSN=CLEANUP.ALLLPAR.TRACKING.FILE, 
//          UNIT=SYSDA,DISP=(NEW,CATLG,DELETE), 
//          DCB=(RECFM=VB,LRECL=584,BLKSIZE=27998), 
//          STORCLAS=xxxxxxxx, 
//          SPACE=(CYL,(nn,nn)) 
//SYSIN    DD DUMMY 
//