The DBSYNC utility
DBSYNC is a REXX exec that can be used to compare unloaded (by IRRDBU00) RACF databases and create commands to correct differences between the two databases. This can be used to synchronize the database contents, except for a few discrepancies that cannot be fixed and except for passwords, which aren't unloaded by IRRDBU00.
DBSYNC can also be used with a single input file to create commands to recreate profiles or to delete profiles.
DBSYNC can be useful as a primitive way of generating commands when cloning or renaming users or groups. It can also be useful when doing database merges.
The DBSYNC tool consists of these files:
- documentation for the DBSYNC REXX exec (TXT, 35.1KB)
- source code for the DBSYNC REXX exec (TXT, 431KB)
- source code for the DBSYNC REXX exec (in TSO TRANSMIT format) (BIN, 439KB)
- documentation for the DBSECLV REXX exec (TXT, 5.1KB)
- source code for the DBSECLV REXX exec (TXT, 16.8KB)
- source code for the DBSECLV REXX exec (in TSO TRANSMIT format) (BIN, 17.3KB)
You can download these files either by using your browser or by using anonymous file transfer protocol (ftp). From your browser, select "file" and "save as". For anonymous ftp, use the site public.dhe.ibm.com. The directory /eserver/zseries/zos/racf/dbsync/ contains the DBSYNC files.
All DBSYNC files are in ASCII, except for the TSO TRANSMIT format files, which are in binary and must be saved, uploaded to z/OS in binary, and processed with the TSO RECEIVE command
We welcome your comments and questions on the DBSYNC Utility. Please direct them to the RACF-L mailing list. Subscription information for RACF-L can be found from the RACF-L Discussion List page.
This program contains code made available by IBM Corporation on an "AS-IS" basis. Any one receiving this program is considered to be licensed under IBM copyrights to use the IBM-provided code in any way he or she deems fit, including copying it and redistributing it, except that it may be neither sold nor incorporated within a product that is sold. No license under any IBM patents or patent applications is to be implied from this copyright license.
The software is provided "as-is", and IBM disclaims all warranties, express or implied, including but not limited to implied warranties of merchantability or fitness for a particular purpose.
This page was last updated May, 2009.