IBM FileNet P8, Version 5.2.1            

Query execution plan acquisition (DB2 for Linux, UNIX, and Windows only)

For DB2®, the technique for obtaining a query execution plan depends on which DB2 version you are running.

On DB2 for versions other than 9.7, use the Explain plan methods for the exact query as executed by the Content Platform Engine (including bind markers).

On DB2 9.7, gather a section explain immediately after a search is run from the IBM® FileNet® P8 application through the Content Platform Engine. For example, after you create the explain tables, login as the schema owner and run these commands:
Table 1. Example SQL commands
Command Comment
DB2 "SELECT SECTION_TYPE, EXECUTABLE_ID, 
VARCHAR(STMT_TEXT, 50) AS TEXT FROM 
TABLE(MON_GET_PKG_CACHE_STMT ( 'D', NULL, 
NULL, -2)) as T WHERE STMT_TYPE_ID LIKE 
'DML%' AND lower(STMT_TEXT) LIKE 
lower('%query portion%')" 
Use a portion of the query that is obtained from a P8 server trace after the query is run.
CALL EXPLAIN_FROM_SECTION (x'015057652000', 
'M', NULL, 0, NULL, ?, ?, ?, ?, ? )
Use the entire executable_id returned in the first query for the first argument.
db2exfmt -d databaseName -e schemaName -w 2011-06-28-18.53.10.973000 -n SYSSH200 -s NULLID -t -# 0 Use the -w explain_time, -n source_name, -s source_schema from last call.


Last updated: March 2016
p8ppt279.htm

© Copyright IBM Corporation 2016.