FP1: Fenced routines history information is easier to collect

Starting in DB2® Version 9.7 Fix Pack 1, you can keep track of the execution history of fenced routines (including those that attempted to be loaded) more easily using the output of the db2pd command with the new -fmpexechistory parameter.

You can use the -fmpexechistory parameter to display the execution history of fenced routines (including the routines that attempted to run) in order to diagnose some FMP process related issues.

To help interpret the fenced routines history information provided by the db2pd command, you can use the genquery option to generate a query that you can save and reuse to return the routine schema, module, name, and specific name according to a routine unique ID. You can run this query after the database manager is stopped and started, and as long as no routine is dropped, the query result will reflect the routine execution history collected at the point when the db2pd command was run.