Using the Catalog Browse facility
To use the Catalog Browse facility
From EZDB2, hyperlink on CATALOG MANAGER–Local (for a Db2 that is in the same LPAR as your UAS) or CATALOG MANAGER–Remote (for a Db2 that is in a different LPAR).The Catalog Browser Primary Menu is displayed in figure below.
DEFG- ------------- Catalog Browser 11.01.00 Primary Menu -----------------
Command ===>
Enter object type and qualifier for an object list
Object type . . . DB
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 . . . . DSNADMDBThis menu allows you to browse most catalog objects.
- Press F1 to see a complete list of objects.
- Use the Tab key to move to the Object type selections, and type DB to see a list of databases.You now see the object list display of all databases.
- Enter a line command of either S or D next to one database to see the complete catalog row data for that database.
- Press F3 to return to the database list.
- Enter the TS line command to list the table spaces in the selected database.
For help on available actions, type COMMAND.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*