828 Supporting On Demand Business Applications with the IBM Problem Determination Tools
27.8.3 Objects
To display and process the DB2 object list we select 3 from the Utility Functions panel, as
shown in Figure 27-57.
Figure 27-57 Select object list
The Object List Utility panel is now displayed, as shown in Figure 27-58.
Figure 27-58 Object List Utility panel
Chapter 27. File Manager/DB2 829
Here we enter:
򐂰 The name of the object that we will list or print. Wildcards are allowed to get a list of
objects.
򐂰 The type of the object. The default is object type 3 (table/view/alis). By entering a question
mark (?) we get a list with the different object types, as shown in Figure 27-59. This list is
scrollable with F8 to see all types.
Figure 27-59 Object types
830 Supporting On Demand Business Applications with the IBM Problem Determination Tools
We now list all tables (object type 3) starting with EMP* for owner SE65273, as shown in
Figure 27-60.
Figure 27-60 List all tables starting with EMP* for owner SE65273
As shown in Figure 27-61, there are three tables found for the criteria. We have the ability to
scroll to the right to see more information about the objects.
Figure 27-61 Three tables found for the criteria
Chapter 27. File Manager/DB2 831
If there are a lot of objects displayed we can use a wildcard to make a new selection, as
shown in Figure 27-62. Under the header TABLE NAME we entered EMPN*.
Figure 27-62 Using wildcard
After entering the wildcard pattern the panel displays, as shown in Figure 27-63.
Figure 27-63 After using the wildcard
832 Supporting On Demand Business Applications with the IBM Problem Determination Tools
As we can see in Figure 27-64, there is a line command area were we can enter the object list
line commands. By entering a question mark (?) in the line command area we get a list of the
object list utility object types, as shown in Figure 27-65 and Figure 27-66 on page 833.
Figure 27-64 Line command area were we can enter the object list line commands
Figure 27-65 List of the object list utility object types

Get Supporting On Demand Business Applications with the IBM Problem Determination Tools (APA, DT, DT with Advanced Facilities, FA, File Export, FM, WS) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.