The System Catalog (ADB21) panel

Use the System Catalog (ADB21) panel to search for Db2 objects or authorizations in the Db2 catalog. To display this panel, select option 1 on the DB2 Administration Menu (ADB2) panel.

Figure 1. System Catalog (ADB21) panel
Start of change
ADB21 min ---------- DD1A System Catalog - Objects ---------------------- 12:11
Option ===>                                                                    
                                                           DB2 System: DD1A    
 AO - Display Authorization options                        DB2 SQL ID: ADM001  
                                                                    
Object options:                                                                
  G - Storage groups                   P - Plans                               
  D - Databases                        L - Collections                         
  S - Table spaces                     K - Packages                            
  T - Tables, views, and aliases                                               
  V - Views                            H - Schemas                             
  A - Aliases for tables and views     E - User defined data types             
  Y - Synonyms                         F - Functions                           
  X - Indexes                          O - Stored procedures                   
  C - Columns                          J - Triggers                            
  N - Constraints                      Q - Sequences and aliases               
 DS - Database structures            DSP - DS with plans and packages          
PDC - DB2 pending definition changes  GV - Global variables                    
XCU - Index cleanup                   RS - REST services                       
Enter standard selection criteria: Settings: '=' operator; Criteria not saved. 
Name  . . . .                            > Grantor . . .           >           
Schema  . . .                            > Grantee . . .           >           
Owner . . . .                            >                                     
In DB/Coll  .                            > Switch Catalog Copy   . . N (N/S/C) 
And/or other selection criteria (option xC shows you columns for option x)     
Column  . . .                            > Oper . .        Value . .
End of change

On the System Catalog (ADB21) panel, enter one of the object codes on the command line (for example, D for databases). You can limit the information that is returned by entering one or more selection criteria at the bottom of the panel. For example, specifying D402 in the Name field limits the search to databases whose names begin with D402. When you press Enter, Db2 Admin Tool creates and executes an SQL statement that searches the Db2 catalog for the object or authorization that you have requested.

Filtering tips

Start of changeOne way to filter your selection is to use the In DB/Coll (database or collection) field. For example, if you want to display table spaces within a specific database, select option S and enter the name of a database in the In DB/Coll field. Or, if you want to display a specific collection in a package, select option K and specify the collection ID in the In DB/Coll field.End of change

Recommendation: Start of change For optimum performance when you specify option T, specify selection criteria. Enter a value for Owner or In DB/Coll.End of change

Exact and fuzzy searches

When you specify selection criteria, you can change from a LIKE search (also known as a "fuzzy" search) to an exact search, which uses an equal sign (=). Use the LIKE ON and LIKE OFF primary commands to toggle between a "fuzzy" search (LIKE ON) and an exact search (LIKE OFF).

They type of search used is shown in the Enter standard selection criteria line on the panel. For example, the following line indicates that a LIKE search ("fuzzy" search) is used:

Enter standard selection criteria: Settings: LIKE operator; Criteria not saved.

Saving search criteria

You can save (or not save) your search criteria between Db2 Admin Tool sessions by using the SAVE ON and SAVE OFF primary commands.

Whether search criteria is saved is shown in the Enter standard selection criteria line on the panel. For example, the following line indicates that the criteria is saved (SAVE ON):

Enter standard selection criteria: Settings: LIKE operator; Criteria saved.

With SAVE ON, the search criteria is restored when you re-enter a Db2 Admin Tool session.

Authorization options

To view the authorization options, choose the AO option on the System Catalog (ADB21) panel. The authorization options are then displayed on the System Catalog (ADB21) panel - Authorization options.

Figure 2. System Catalog (ADB21) panel - Authorization options
Start of change
 ADB21 min ---------- DD1A System Catalog - Authorizations --------------- 12:16
Option ===>                                                                    
                                                            DB2 System: DD1A    
 OO - Display Object options                                DB2 SQL ID: ADM001  
                                                             
Authorization options:                                                         
 GA - Storage group auths             PA - Plan authorizations                 
 DA - Database authorizations         LA - Collection authorizations           
 SA - Table space authorizations      KA - Package authorizations              
 TA - Table authorizations            HA - Schema authorizations               
 VA - View authorizations             EA - User defined data type authorization
 CA - Column authorizations           FA - Function authorizations             
 ZA - System authorizations           OA - Stored procedure authorizations     
 UA - User authorizations             QA - Sequence authorizations             
 RA - Resource authorizations         TR - Trusted contexts                    
 RO - Roles                           PM - Permissions                         
 CM - Column masks                   GVA - Global variable authorizations      
                                                                               
                                                                               
Enter standard selection criteria: Settings: '=' operator; Criteria not saved. 
Name  . . . .                            > Grantor . . .           >           
Schema  . . .                            > Grantee . . .           >           
Owner . . . .                            >                                     
In DB/Coll  .                            > Switch Catalog Copy   . . N (N/S/C) 
And/or other selection criteria (option xC shows you columns for option x)     
Column  . . .                            > Oper . .        Value . .
End of change

For optimum performance, specify selection criteria for all authorization options (xA) and enter a value for Grantor or Grantee.

Db2 Admin Tool reports authorizations based solely on the Db2 catalog. However, the actual authorization is affected by other sources that are external to the Db2 catalog, such as the following sources:
  • Installation authorities that are specified in DSNZPARM.
  • Any external security system, such as the RACF® program.
  • Any security product from another software provider.
  • Security user exits, including the ones that are supplied by IBM®.