Detail line hierarchy

An unexpanded F14 report shows a line for each plan that was measured in the stored procedure address space. You can expand each line to reveal additional hierarchical levels of detail (using the “+” line command).

Only the DB2SQL Category hierarchy is shown here. Activity for the Stored Procedure which is not related to SQL processing will be shown in the SYSTEM, APPLCN, or NOSYMB categories. For information about these other categories, see C01 - CPU usage by category. The hierarchy is illustrated here:

Level 1 DB2 Plan
	Level 2 DB2SQL Category
		Level 3 DB2 DBRM
			Level 4 DB2 Load Module