Table display panels

Table display panels contain ISPF tables that show information about Db2 objects. From these panels, you can run various Db2 Admin Tool functions.

Important: In some cases, fields on Db2 Admin Tool panels might be hidden or output-only, as follows:

Data entry fields, both the description preceding the entry field and the input field, can be entirely hidden,
Data entry fields can be output-only, which means that you can see a field (because the description is visible), but you cannot provide a value.
A column on a table display can be converted to output-only or hidden.

For example, if the version of Db2 that is used has a restriction related to a field, that field might be hidden or output-only. Hidden fields can cause blank lines or spaces; disregard them.

The panel in the following figure shows the areas on a typical table display panel.

This image shows a typical Db2 Admin Tool panel, the Databases panel. It has pointers that match the lettered (A-G) explanations below. Letter A points to the "Command line ==>" area. Letter B points to the "Valid line commands" area. Letter C points to the column headers area, such as the "Select" header. Letter D points to the asterisks under the column headers, which indicate search arguments can be entered. Letter E points to the area in which you can enter line commands. Letter F points to the area in which table and object data is displayed. Finally, letter G points to the end of data marker at the bottom of the data. — Figure 1. Table Display panel layout

First row of the panel: Contains the Db2 Admin Tool panel name and a count of data rows. The row count reflects an initial search done by your Db2 subsystem.
A Command line: On this line you can enter any Db2 command, ISPF command, or Db2 Admin Tool primary command.
B Line command description area: Indicates the Db2 Admin Tool line commands that you can issue from a particular table display panel. You issue a line command in the Select field (area E). When the panel does not have not enough space to list all valid line commands, only the most frequently used line commands are shown. To display all other valid line commands, specify a question mark (?) in the Select field, and press Enter.
C Column headers: Contains the names of the columns that have data.
D Search arguments: Use this area to specify search criteria for the data that is displayed in the panel. ISPF generic search argument rules apply. For columns that contain alphabetic characters, the asterisk (*) under the column name marks the beginning (left-justified) of the area in which you can enter search criteria to limit the information that Db2 Admin Tool returns. For columns that contain numeric characters, the asterisk (*) marks the end (right-justified) of the area. For example, you can enter D050 in the Name column to display only those databases whose names begin with D050.
Specify a blank to reset the filter for the column. For advanced column filtering, use the SEARCH (or SARG) command.
E Select column: Use the Select column to issue Db2 Admin Tool line commands (shown in area B) against Db2 objects that are listed in the table display panel.
If you specify a line command or update a row in the table display and also issue a scroll request by pressing PF7 or PF8, the line command or row update is processed, and the scroll request is ignored.
F Rows returned: Shows the rows that Db2 returns based on the options that you selected, the commands that you issued, or the search criteria that you entered. For example, to display the panel shown in the previous figure, on the System Catalog (ADB21) panel, request that all databases owned by ISTJE2 be displayed.
G End of data marker: Indicates the end of the data returned from Db2.