Sample reports
A sample report is shown here:
File View Navigate Help
+--------------------------------------------------------------------------------+
|DB2 EXPLAIN (0167/CICS23A) Row 00001 of 00010 |
|Command ===> __________________________________________________Scroll ===> CSR |
| |
| Blk Plan Mix Join Acc Match Index Sort New Sort Comp Table |
| Num. Num. Op Mthd Type Cols Only U J O G U J O G Name |
| |
| 0001 1 0 0 R 0 N N N N N N N N N MAIN |
| 0001 2 0 3 0 N N N N N Y N N N |
| 0002 1 0 0 R 0 N N N N N N N N N DEP1 |
| 0003 1 0 0 R 0 N N N N N N N N N MAIN |
| 0004 1 0 0 R 0 N N N N N N N N N DEP2 |
| 0005 1 0 0 R 0 N N N N N N N N N MAIN |
| 0005 2 0 3 0 N N N N N Y N N N |
| 0006 1 0 0 R 0 N N N N N N N N N DEP1 |
| 0007 1 0 0 R 0 N N N N N N N N N MAIN |
| 0008 1 0 0 R 0 N N N N N N N N N DEP2 |