Hi,
Are STROBE and EXPLAIN serve the same purpose in DB2? If yes, why to have two products?
Are STROBE and EXPLAIN serve the same purpose?
- Robert Sample
- Global Moderator
- Posts: 1896
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Are STROBE and EXPLAIN serve the same purpose?
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.
-
- Former Team Member
- Posts: 62
- Joined: Wed Aug 07, 2013 6:43 pm
Re: Are STROBE and EXPLAIN serve the same purpose?
Other than they both allow one to look at certain performance issues, they have little in common.
Knowing how to use one of them has little to do with usiong the other.
What have you learned about these?
Knowing how to use one of them has little to do with usiong the other.
What have you learned about these?
Hope this helps,
d
d
Re: Are STROBE and EXPLAIN serve the same purpose?
As has been said - STROBE is performance monitoring tool and not used for only DB2. This page give you more information on it: http://www.compuware.com/en_us/mainfram ... oring.html
EXPALIN, actually is not a "Tool" - it's a "DB2 statement" - and the EXPLAIN statement obtains information about access path selection for an explainable statement. As the manuals says, a statement is explainable if it is a SELECT, MERGE, or INSERT statement, or the searched form of an UPDATE or DELETE statement. The information that is obtained is placed in a set of supplied user tables that are called EXPLAIN tables.
EXPALIN, actually is not a "Tool" - it's a "DB2 statement" - and the EXPLAIN statement obtains information about access path selection for an explainable statement. As the manuals says, a statement is explainable if it is a SELECT, MERGE, or INSERT statement, or the searched form of an UPDATE or DELETE statement. The information that is obtained is placed in a set of supplied user tables that are called EXPLAIN tables.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute