Access control list and agent configuration files - connect_cdc_sqdata - Latest

Connect CDC (SQData) Secure Communications Components

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Secure Communications Components
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T19:55:16.493453

These two files are usually created at the same time. This example uses sample member CRDAEMON, included in the distribution which contains steps for both the Access Control List and the Agent Configurations file.

Access Control List - The acl.cfg will contain something similar to the following, with the user_name (user_id) of the Capture Agent Job either assigned to a group_name or specified in the acls section.
default_acl=query
[groups]
prod=sqduser,user1,user2
[acls]
prod=admin
Connect CDC SQData Agent Configurations - The sqdagents.cfg will contain something similar to the following with an entry for every Agent managed by this particular Controller Daemon.
acl=acl.cfg
message_file=../logs/acl.log

[DB2CDC]                  
type=capture              
cab=/home/sqdata/DB2CDC/DB2CDC.cab
The sample JCL should be edited to conform to the operating environment.
//CRDAEMON JOB 1,MSGLEVEL=(1,1),MSGCLASS=H,NOTIFY=&SYSUID              
//*                                                                    
//*--------------------------------------------------------------------
//*   Create Daemon Registered Agents and ACL Files                    
//*--------------------------------------------------------------------
//*   Note: 1) The sqdagents.cfg and acl.cfg files are required for    
//*            all SQDAEMON Controller daemons                        
//*                                                                    
//*         2) This sample Job contains the following parameters which
//*            should be changed as required for your environment      
//*                                                                    
//*   sqdagents.cfg:                                                  
//*     acl=acl.cfg                      - Leave as is                
//*     message_file=../logs/acl.log     - Leave as is                
//*                                                                    
//*     [DB2CDC]  - Use this block as a template if you are planning  
//*                 to run the DB2 z/OS CDCStore Capture - else, remove
//*                                                                    
//*     [IMSPUB]  - Use this block as a template if you are planning  
//*                 to run the IMS CDCzLog Capture - else, remove      
//*                                                                    
//*     [VSAMPUB] - Use this block as a template if you are planning to
//*                 run the CICS/VSAM CDCzLog Capture - else, remove  
//*--------------------------------------------------------------------
//*                                                                    
//*--------------------------------------------------------------------
//*   Create and populate the sqdagents.cfg file                      
//*--------------------------------------------------------------------
//CRAGENTS EXEC PGM=IEBGENER                                          
//SYSPRINT DD SYSOUT=*                                                
//SYSIN    DD DUMMY                                                    
//SYSUT2   DD PATH='//home/sqdata/daemon/cfg/sqdagents.cfg',          
//         PATHOPTS=(OWRONLY,OCREAT,OTRUNC),                          
//         PATHMODE=SIRWXU,                                            
//         PATHDISP=(KEEP,DELETE),                                    
//         FILEDATA=TEXT                                              
//*                                                                    
//SYSUT1   DD *                                                        
acl=acl.cfg                                                          
message_file=../logs/acl.log                                          
                                                                 
[DB2CDC]                                                              
type=capture                                                          
cab=/home/sqdata/DB2CDC/DB2CDC.cab
                                                                   
[IMSCDC]                                                              
type=publisher                                                        
cab=/home/sqdata/IMSPUB/IMSPUB.cab
                                                                   
[VSAMPUB]                                                            
type=publisher                                                        
cab=/home/sqdata/VSAMPUB/VSAMPUB.cab                                
/*                                                                    
//*--------------------------------------------------------------------
//*   create and populate the acl.cfg file                            
//*--------------------------------------------------------------------
//CRACL    EXEC PGM=IEBGENER                                          
//SYSPRINT DD SYSOUT=*                                                
//SYSIN    DD DUMMY                                                    
//SYSUT2   DD PATH='//home/sqdata/daemon/cfg/acl.cfg',                
//         PATHOPTS=(OWRONLY,OCREAT,OTRUNC),                          
//         PATHMODE=SIRWXU,                                            
//         PATHDISP=(KEEP,DELETE),                                    
//         FILEDATA=TEXT                                              
//*                                                                    
//SYSUT1   DD *                                                        
default_acl=query                                                                                                                         
[groups]                                                              
prod=sqduser,user1,user2                                                                                                                
[acls]                                                                
prod=admin                                                                                                                               
/*                                                                    
//*--------------------------------------------------------------------
//*   Optional: Change permissions of newly created files              
//*--------------------------------------------------------------------
//CHMOD    EXEC PGM=IKJEFT01,REGION=64M,DYNAMNBR=99,COND=(0,LT)        
//SYSEXEC   DD DISP=SHR,DSN=SYS1.SBPXEXEC                              
//SYSTSPRT  DD SYSOUT=*                                                
//OSHOUT1   DD SYSOUT=*                                                
//SYSTSIN   DD *                                                      
 OSHELL chmod 775 +                                                  
  /home/sqdata/daemon/cfg/sqdagents.cfg                            
 OSHELL chmod 775 +                                                  
  /home/sqdata/daemon/cfg/acl.cfg                                  
/*