How can I merge two CA TPX ADMIN files into one?

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

CA TPX has five VSAM files: ADMIN1, ADMIN2, MAIL, NOTES, VIEW.

  • ADMIN1 and ADMIN2 are always required.
  • If not using the MAIL, NOTES, and/or VIEW features, you can omit these files and specify DD DUMMY in the TPX PROC for each. 
Question:

How can I merge two CA TPX ADMIN files into one?

Environment:
TPX 5.4
Answer:

There are no supplied TPX utilities to merge the ADMIN VSAM files. This must be accomplished via VSAM utilities, but it is a tricky process and must be done carefully.

You may be able to use IDCAMS REPRO process to populate a file then use the REPRO with NO REPLACE to continue the population of the file. A sort is not necessary as long as it is the cluster name (e.g. ADMIN2) and not the data name (e.g. ADMIN2.DATA) in use for the REPRO.

IMPORTANT:

  • Make sufficient copies of your files before attempting any merging of the files.
  • Don't forget to RESET INTEGRITY when finished.

To determine the storage for a new consolidated TPX, add up all of the individual storage amounts from the previous TPXs. Ideally, use D STORXA displays in each original TPX to see what the high water marks are and add those up.

 

Additional Information:

You cannot merge ADMIN1 and ADMIN2 into one file.  They each contain their own types of records.  You would be merging multiple ADMIN1 files together, multiple ADMIN2 together, multiple MAIL together, etc.

TPX 5.4 Record Type Information