by Robert Sample » Sun Nov 24, 2013 5:36 pm
The first thing you need to be aware of is that EXPLAIN is part of DB2 and hence an IBM product. STROBE is from Compuware, an independent software vendor. STROBE is used for run-time analysis of application programs (as well as DB2 statements) and hence can be used for COBOL, PL/I, and other languages to identify where the program needs tuning. STROBE can be purchased and used at sites that do not have DB2 installed. EXPLAIN, however, requires that DB2 be installed at the site since it analyzes access paths with DB2.
The first thing you need to be aware of is that EXPLAIN is part of DB2 and hence an IBM product. STROBE is from Compuware, an independent software vendor. STROBE is used for run-time analysis of application programs (as well as DB2 statements) and hence can be used for COBOL, PL/I, and other languages to identify where the program needs tuning. STROBE can be purchased and used at sites that do not have DB2 installed. EXPLAIN, however, requires that DB2 be installed at the site since it analyzes access paths with DB2.