The following are common messages displayed by db2expln:
This message will appear in the output if no packages were found in the database that matched the specified pattern.
This message will appear in the output if the bind of db2expln.bnd was not successful. Further information on the problems encountered will be found in the file db2expln.msg in the current directory.
This message will appear in the output if multiple packages may be encountered by db2expln. This action will be taken if one of the pattern matching characters is used in the package or creator input arguments.
This message will appear in the output if the specified package only contains dynamic SQL statements which means that there are no static sections.
This message will appear in the output if the package specified is currently not valid. As directed, reissue the BIND or REBIND command for the plan to re-create a valid package in the database, and then rerun db2expln.
This message will also appear in the output if the section currently being processed was produced by a release of DB2 other than the one for which this db2expln executable was provided. In this case, use the copy of db2expln from the release of DB2 that produced the section.
SQL Statements Excluded: The following statements will not be explained:
Each sub-statement within a compound SQL statement may have its own section, which can be explained by db2expln.
[ DB2 List of Books | Search the DB2 Books ]