Security Considerations for History Records

Operating Environment › Security Considerations for History Records

Security Considerations for History Records

CA XCOM Data Transport checks security by ensuring that the user requesting history records is a member of the xcomadm group and/or the xcomsadm group. CA XCOM Data Transport returns records as follows:

If the user is not a member of either xcomadm or xcomsadm, then the transfers returned are limited to those containing that user's user ID.
If the user is a member of xcomadm, then CA XCOM Data Transport does both of the following:
- Returns transfers in the queue for all users and allows operator functions against those transfers.
- Returns history records for all transfers for the target machine (SYSNAME, SYSID), regardless of the owner.
If the user is also a member of xcomsadm, then CA XCOM Data Transport returns history records for any machine included in the history table.

Instructions to Upgrade Existing R11.5 History Database

A sample SQL file with the commands to upgrade the existing r11.5 History database and tables is provided in the following file:

$XCOM_HOME/config/histupdateDB.sql

Note: This file will need to be updated to match the database management system being used at your site.

To upgrade the XCOM R11.5 History Table

Upgrade the history table using the following code (for MySQL):

USE XCOMHIST;
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN msg_count                   SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN login_connection            SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN access_connection           SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN num_of_new_dir              SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN xcomlib_count               SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN xcomlib_checkpoint_count    SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN encryptionkeybits           SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN starting_state              SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN conversation_type           SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN header_length               SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN ovrlength                   SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN recsize                     SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN version                     SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN silent                      SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN trace                       SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN buffsize                    SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN maxreclen                   SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN checkpoint_count            SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN num_of_retries              SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN retry_time                  SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN state                       SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN next_state                  SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN record                      SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN bytes                       SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN record_count                SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN byte_count                  SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN block_count                 SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN bytes_trans                 SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN exec_priority               SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN sched_priority              SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN vtam_sends                  SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN vtam_recvs                  SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN file_output_count           SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN file_input_count            SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN file_error_count            SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN session_error_count         SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN vtam_error_count            SET DEFAULT 0;                      
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ALTER COLUMN total_error_count           SET DEFAULT 0;      
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN invoking_jobname    char(8)   DEFAULT ' ' AFTER `local_unit`;     
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN create_delete_flag  char(1)   DEFAULT ' ' AFTER `invoking_jobname`;
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN pds_compress_flag   char(1)   DEFAULT ' ' AFTER `create_delete_flag`;
                                                                                 
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN pds_member_number   smallint  DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN cpu_time            bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN tcb_time            bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN srb_time            bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN ziip_time_ziip      bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN ziip_time_cpu       bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN ziip_eligible_time  bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN record_count2       bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN vtam_send_count     bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN vtam_receive_count  bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN file_output_count2  bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN file_input_count2   bigint    DEFAULT 0;                          
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN primary_allocation2          char(8)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN secondary_allocation2        char(8)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN directory_allocation2        char(8)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN allocation_record_units      char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN extended_attributes          char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN local_ciphers                char(40)  DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN negotiated_cipher            char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN transfer_protocol            char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN local_charset                char(60)  DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN remote_charset               char(60)  DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN local_ccsid                  int       DEFAULT 0;                 
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN remote_ccsid                 int       DEFAULT 0;                 
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN source_ccsid                 int       DEFAULT 0;                 
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN target_ccsid                 int       DEFAULT 0;                 
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN local_conversion_technique   char(8)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN remote_conversion_technique  char(8)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN mbcs_input_error_action      char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN mbcs_conversion_error_action char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN local_delim_encoding         char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN remote_delim_encoding        char(1)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN mbcs_input_repl_char         char(8)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN mbcs_conversion_repl_char    char(8)   DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN local_delim_options          char(16)  DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN remote_delim_options         char(16)  DEFAULT ' ';               
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN mbcs_input_repl_count        int       DEFAULT 0;                 
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN mbcs_conversion_repl_count   int       DEFAULT 0;                 
                                                                                
ALTER TABLE  XCOM_HISTORY_TBL                                                   
   ADD COLUMN transmission_format          char(1)   DEFAULT ' ';

Create the Index on newly added fields using the below syntax:

create index XCOM_REQ_IDX on XCOM_HISTORY_TBL (   
reqno,                                            
pds_member_number,                                
StartDate,                                        
StartTime,                                        
sysname,                                          
sysid);                                           
create index XCOM_RECP_IDX on XCOM_HISTORY_TBL (  
luname,                                           
pds_member_number,                                
StartDate,                                        
StartTime,                                        
sysname,                                          
sysid);                                           
create index XCOM_USER_IDX on XCOM_HISTORY_TBL (  
user_name,                                        
pds_member_number,                                
StartDate,                                        
StartTime,                                        
sysname,                                          
sysid);                                           
create index XCOM_IDNT_IDX on XCOM_HISTORY_TBL (  
transfer_id,                                      
pds_member_number,                                
StartDate,                                        
StartTime,                                        
sysname,                                          
sysid);                                           
create index XCOM_SYST_IDX on XCOM_HISTORY_TBL (  
remote_system,                                    
pds_member_number,                                
StartDate,                                        
StartTime,                                        
sysname,                                          
sysid);