Supporting On Demand Business Applications with the IBM Problem Determination Tools (APA, DT, DT with Advanced Facilities, FA, File Export, FM, WS)

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