RACF database unload tables

You can load RACF data into in-memory SQLite tables for query processing and data retrieval. You can use SQL queries to perform complex data analysis and generate custom reports. 

To unload the RACF database, use the SPMParms RACFDBUnload parameter. For more information, see the "Security Policy Manager parameters" section in Configuring-parameters.

Related topics

Commands

Command-and-syntax-reference

Important

For performance and security reasons, the tables are in-memory SQLite tables and are not externalized to the existing SQLite database on DASD. Likewise, the RACF database unload file is temporary and the file is deleted as soon as the SQLite tables are built.

The table names closely match the sample Db2 table names found in SYS1.SAMPLIB(RACDBUTB). However, all the table names have the RACF_ prefix. The column names are the same as those in the RACDBUTB SAMPLIB member.

The following table lists the unloaded RACF database record types and their correlating SQLite tables:

Record type

Record name

SQLite table name

0100

Group Basic Data                    

RACF_GROUP_BD           

0101

Group Subgroups                     

RACF_GROUP_SUBGROUPS    

0102

Group Members                       

RACF_GROUP_MEMBERS      

0103

Group Installation Data             

RACF_GROUP_INSTALL_DATA 

0110

Group DFP Data                      

RACF_GROUP_DFP_DATA     

0120

Group OMVS Data                     

RACF_GROUP_OMVS_DATA    

0130

Group OVM Data                      

RACF_GROUP_OVM_DATA     

0141

Group TME Role                      

RACF_GROUP_TME_ROLE     

0151

Group CSDATA Custom fields          

RACF_GROUP_CSDATA_CUST  

0200

User Basic Data                     

RACF_USER_BD            

0201

User Categories                     

RACF_USER_CATEGORIES    

0202

User Classes                        

RACF_USER_CLASSES       

0203

User Group Connections              

RACF_USER_GROUPS        

0204

User Installation Data              

RACF_USER_INSTALL_DATA  

0205

User Connect Data                   

RACF_USER_CONNECT_DATA  

0206

User RRSF Data                      

RACF_USER_RRSF_DATA     

0207

User Certificate Data               

RACF_USER_CERT_DATA     

0208

User Associated Mappings            

RACF_USER_NMAP_DATA     

0209

User Associated Distributed Mappings

RACF_USER_DISTR_MAPPING 

0210

User DFP Data                       

RACF_USER_DFP_DATA      

0220

User TSO Data                       

RACF_USER_TSO_DATA      

0230

User CICS® Data                     

RACF_USER_CICS_DATA     

0231

User CICS Operation Classes         

RACF_USER_CICS_OPCLASS  

0232

User CICS RSL Keys                  

RACF_USER_CICS_RSLKEY   

0233

User CICS TSL Keys                  

RACF_USER_CICS_TSLKEY   

0240

User LANGUAGE Data                  

RACF_USER_LANGUAGE_DATA 

0250

User OPERPARM Data                  

RACF_USER_OPERPARM_DATA 

0251

User OPERPARM Scope                 

RACF_USER_OPERPARM_SCOP 

0260

User WORKATTR Data                  

RACF_USER_WORKATTR_DATA 

0270

User OMVS Data                      

RACF_USER_OMVS_DATA     

0280

User NETVIEW Data                   

RACF_USER_NETV_DATA     

0281

User NETVIEW Operation Classes      

RACF_USER_NETV_OPCLASS  

0282

User NETVIEW Domains                

RACF_USER_NETV_DOMAINS  

0290

User DCE Data                       

RACF_USER_DCE_DATA      

02A0

User OVM Data                       

RACF_USER_OVM_DATA      

02B0

User LNOTES Data                    

RACF_USER_LNOTES_DATA   

02C0

User NDS Data                       

RACF_USER_NDS_DATA      

02D0

User KERB Data                      

RACF_USER_KERB_DATA     

02E0

User PROXY Data                                   

RACF_USER_PROXY_DATA   

02F0

User EIM Data                                     

RACF_USER_EIM_DATA     

02G1

User CSDATA Custom fields                         

RACF_USER_CSDATA_CUST  

0400

Data Set Basic Data                               

RACF_DS_BD             

0401

Data Set Categories                               

RACF_DS_CATEGORIES     

0402

Data Set Conditional Access                       

RACF_DS_COND_ACCESS    

0403

Data Set Volumes                                  

RACF_DS_VOLUMES        

0404

Data Set Access                                   

RACF_DS_ACCESS         

0405

Data Set Installation Data                        

RACF_DS_INSTALL_DATA   

0410

Data Set DFP Data                                 

RACF_DS_DFP_DATA       

0421

Data Set TME Role                                 

RACF_DS_TME_ROLE       

0500

General Resource Basic Data                       

RACF_GENR_BD           

0501

General Resource Tape Volumes                     

RACF_GENR_TAPE_VOLUMES 

0502

General Resource Categories                       

RACF_GENR_CATEGORIES   

0503

General Resource Members                          

RACF_GENR_MEMBERS      

0504

General Resource Volumes                          

RACF_GENR_VOLUMES      

0505

General Resource Access                           

RACF_GENR_ACCESS       

0506

General Resource Installation Data                

RACF_GENR_INSTALL_DATA 

0507

General Resource Conditional Access               

RACF_GENR_COND_ACCESS  

0508

General Resource Filter Data                      

RACF_GENR_FILTER_DATA  

0509

General Resource Distributed Identity Mapping Data

RACF_GENR_DISTR_MAPPING

0510

General Resource Session Data                     

RACF_GENR_SESSION_DATA 

0511

General Resource Session Entities                 

RACF_GENR_SESSION_ENT  

0520

General Resource DLF Data                         

RACF_GENR_DLF_DATA     

0521

General Resource DLF Job Names                    

RACF_GENR_DLF_JOBNAMES 

0540

General Resource STDATA Data                      

RACF_GENR_STDATA_DATA  

0550

General Resource SVFMR Data                       

RACF_GENR_SVFMR_DATA   

0560

General Resource Certificate Data                 

RACF_GENR_GRCERT_DATA  

0561

General Resource Certificate References Data      

RACF_GENR_CERTR_DATA   

0562

General Resource Key Ring Data                    

RACF_GENR_KEYR_DATA    

0570

General Resource TME Data                         

RACF_GENR_TME_DATA     

0571

General Resource TME Children                     

RACF_GENR_TME_CHILDREN 

0572

General Resource TME Resource                     

RACF_GENR_TME_RESOURCE 

0573

General Resource TME Group                        

RACF_GENR_TME_GROUP    

0574

General Resource TME Role                         

RACF_GENR_TME_ROLE     

0580

General Resource KERB Data                        

RACF_GENR_KERB_DATA    

0590

General Resource PROXY Data                       

RACF_GENR_PROXY_DATA   

05A0

General Resource EIM Data                         

RACF_GENR_EIM_DATA     

05B0

General Resource ALIAS Data                 

RACF_GENR_ALIAS_DATA    

05C0

General Resource CDTINFO Data               

RACF_GENR_CDTINFO_DATA  

05D0

General Resource ICTX Data                  

RACF_GENR_GRICTX_DATA   

05E0

General Resource CFDEF Data                 

RACF_GENR_CFDEF_DATA    

05F0

General Resource SIGVER Data                

RACF_GENR_GRSIG_DATA    

05G0

General Resource ICSF Data                  

RACF_GENR_ICSF_DATA     

05G1

General Resource ICSF Key Label             

RACF_GENR_ICSF_KEY_DATA 

05G2

General Resource ICSF Certificate Identifier

RACF_GENR_ICSF_CERT_DATA

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*