Processing an external file with CARLa

This CARLa program processes an external file. An example of where this feature might prove useful is for the reconciliation of internal security databases and the RACF database. After an investigation, you might discover applications that do not use RACF for authorization checks. Instead, these applications have an internal security database within the application to check for the appropriate authority of a user. Periodically, you might need to reconcile these databases. Please note that this example functions only correctly if both the RACF and the internal security database use the same naming convention standards for user IDs.

CARLa program example:

This screen capture shows what the external file looks like when it is browsed directly:

Sample output as shown in SDSF for DDname REPORT:

Exercise:

The objective of this exercise is to process an external file. You first create an external file that contains email addresses and process this external file with a CARLa program similar to the program shown.

• Allocate a new sequential dataset named: “youruserid.zsecure.external.emailadr”. Suggested allocation attributes for your data set: Primary quantity=10; secondary quantity=10; Directory blocks=0; Record format=FB; Record length=80.
   
• Copy the content of the attached file to the data set that you defined in the previous step. Edit the first field (the part in front of the semicolon) to match some of the user IDs on your system.
   
• Using the CARLa job shown above as template, change the various statements to process your external file. In this exercise, select all user profiles that start with “ZPU0”. You must pay attention to the specifications for: USERLIST, MASK=, #APPL #ACCESS, and ‘APPL B ACCESS’. These specifications must be changed!
   
• When you are finished with customizing your CARLa program, submit it using the appropriate JCL.
   
• Unless you changed the REPORT DD name in your JCL, the output from your CARLa batch job is written to SDSF. The output must look like this screen capture:

 

 

View Suggested samples and answers

 

Continue with Reporting inactive IDs

 

© Copyright IBM Corp. 2012, 2020

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.