Typically, in Db2 Admin Tool, the way to display catalog information about a Db2 object is to use the System Catalog panel (Option 1 on the main Db2 Administration Menu panel). From that panel, you can select the object type and any filtering criteria:
However, did you know that you can also use the ? command to quickly navigate to the catalog information for any object? For example, if I want to view the information for database DSNDB04, I can type the following command at any command line:
Command ===> ?d DSNDB04
When I press Enter, the DSNDB04 information is displayed:
Similarly, if I want to view the information for a table space, I can use a command such as:
Command ===> ?s KAWDCH.ADBSPART
In this case, the following table space information is displayed:
The format of this command is:
?xx qualifier.name
where xx is the object type from the System Catalog panel. For example, s is for table spaces, v is for views, and x is for indexes.
Everything after the question mark(?) is optional. However, if you want to specify a qualifier or name, you must specify the object type.
You can also use a character other than the question mark (?) for this command. You can specify a different character on the Db2 Admin Defaults panel (ADB2P2) in the CAT command character field. ? is the default.
For more information on this command, see Db2 Admin Tool primary commands in IBM Knowledge Center.
#Db2Toolsforz/OS#db2admin#Db2Tools