Skip to Content

Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

CATALOG MANAGER for DB2 Browse

CATALOG MANAGER for DB2 in browse-only mode is available as a component of MainView for DB2.

Hyperlinks are enabled if you install this component, or if you have the full CATALOG MANAGER for DB2 product installed.

CATALOG MANAGER for DB2 in browse-only mode lets you browse any DB2 catalog table in local DB2s, and in remote DB2s on other LPARs if DDF connections are defined in DB2 and made known to CATALOG MANAGER for DB2. If your site is licensed for the CATALOG MANAGER for DB2 product, you can also access other product functions.

Hyperlinks are available in MainView for DB2 views to display data from the DB2 catalog tables. You can access:

  • Full catalog lists from easy menus, for example, lists of databases, table spaces, and indexes from the EZDPS Object Menu
  • The CATALOG MANAGER Browse Menu, shown in the following figure, (or the full CATALOG MANAGER Menu) from the EZDB2 and EZDBA easy menus
DEFG-  -------------  Catalog Browser 10.01.00 Primary Menu  -----------------
Command ===>                                                                   
                                                                                                                                                                                                                                       
Enter object type and qualifier for an object list                             
                                                                              
                                                                              
Object type . . .                                                              
                   DB Database   TS Tablespace   PL Plan      ST Strings       
                   SG Stogroup   SU SysPrivUser  AL Alias     LO Locations     
                   TB Table      SY Synonym      US User      CK CheckConst    
                   VW View       PG Package      CO Column    PR Procedures    
                   IX Index      CI Collection   DM DBRM      XT Aux Table     
                                                                              
Qualifier . . . .                                                              
              Initial attach to DEFG                                           
                   Copyrights (c) 1987-2011 BMC Software, Inc.                 
                        as an unpublished licensed work.                       
                             All rights reserved.

Either from the Primary Menu or from direct hyperlinks to an object, you will be presented with an object list view. From here, you can use the S or D line commands to view detail information about that object. You can enter CMD on the COMMAND line to access a list of commands available to you. If you receive a message, enter TSO BMCMSG msgID to access information about the message.

Although the Primary Menu only shows the most frequently used object types, many others are available. Press F1 on the primary menu for a list of all objects.

Warning

Note

Access to CATALOG MANAGER for DB2 occurs in your User Address Space (UAS). There are hyperlinks provided to access DB2s in the same LPAR as your UAS (local), as well as DB2s in other LPARs (remote). The local hyperlinks pass the target DB2 SSID so that CATALOG MANAGER for DB2 can establish an attach to that DB2, so make sure that you are not in SSI mode on the view with the hyperlink.

The remote hyperlinks pass the DB2 location so that CATALOG MANAGER for DB2 can establish an attach to a local DB2 and then connect to the remote DB2 through DDF. (Remote access requires proper setup of DDF connections.)


Related topic

Integrating


 

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

MainView for DB2 6.1