Updating the Affinity database objects

CICS® IA provides the CIUAFFLD batch job to update the database from the VSAM files.

If your affinity data files are shared by multiple CICS regions, you can use a single run of the CIUAFFLD job to store the affinity information for all the regions into the set of Affinity database objects.

If, on the other hand, you have separate affinity data files for each region, you can run the job once for each region you're interested in and feed the affinity information for each region into the same set of Affinity database objects. For example, you must run multiple jobs if you run the Collector on multiple regions, do not use shared affinity files, and want to keep the affinity data for all the regions in the same set of Affinity database objects.

Run the Collector with your normal weekly workload to collect the base data and also run it at month ends, quarter ends, and year ends to collect data from infrequently run programs. When you have recorded all your applications, you might need to update the database objects only for new applications and changed programs.

Start of changeThe CIUSPAFF program is a DB2® UDB stored procedure that is an affinity data update and query interface program. The CIUAFFL1 program, which is run by the CIUAFFLD JCL sample, issues one SQL CALL to the CIUSPAFF program that updates affinity DB2 objects.End of change

Start of changeBefore running CIUAFFLD, which is put into the hlq.SCIUSMP1 library by the CICS IA installation procedure, edit it to meet the requirements of your system.End of change