Administration Guide

Usage Notes for db2expln

The following are common messages displayed by db2expln:

• No packages found for database <database>, package pattern: <creator>.<package>.

  This message will appear in the output if no packages were found in the database that matched the specified pattern.

• Bind messages can be found in db2expln.msg

  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.

• Section number overridden to 0 for potential multiple packages.

  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.

• No static sections qualify for database <database>, package <creator>.<package>, section <section>.

  This message will appear in the output if the specified package only contains dynamic SQL statements which means that there are no static sections.

• Database <database>, package <creator>.<package> is not valid. Rebind and then rerun db2expln.

  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.

• Section not processed: Produced by unsupported release.

  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:

• BEGIN/END DECLARE SECTION
• BEGIN/END COMPOUND
• INCLUDE
• WHENEVER
• COMMIT and ROLLBACK
• CONNECT
• OPEN cursor
• FETCH
• CLOSE cursor
• PREPARE
• EXECUTE
• EXECUTE IMMEDIATE
• DESCRIBE
• Dynamic DECLARE CURSOR

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 ]