3
0
Tech Tip: Mapping a Routine to the DB2 Fenced Process (db2fmp) that ran it
DB2 LUW provides the db2pd tool with two fmp options that when used in conjunction with each other can provide information which will identify the routine that was running in a particular db2fmp. The following technote documents a method to determine which db2fmp a routine ran in using the db2pd tool. http
If a db2fmp entry is logged in the db2diag.log, the entry should contain the process ID (PID) and thread ID (TID). Below is a sample of a db2diag.log entry which identifies the db2fmp PID and TID. 201
PID : 59900132 TID : 0 PROC : db2fmp Since the db2pd -fmp command described in the above technote returns the PID and TID as well as the routine name and time of the run, it is possible to use the information in the db2diag.log to map a routine to its db2fmp. Below is a sample of the output. PID 59900132 0 2012 So we can see from the above output
that the db2fmp error occurred while running the routine
SYSPROC.ADMIN_CMD
|
Part of the IBM Analytics family, focused on Analytic Platform product support. This blog is administered by Nick Anderson and follows the IBM Social Computing Guidelines.
How to extract time ...
Updated
Likes 0
Comments 0
SAP Note 81737 V905:...
UpdatedLikes 0
Comments 0
IDUG DB2 Tech confer...
UpdatedLikes 0
Comments 0
How to enable DB2 JD...
UpdatedLikes 0
Comments 0
Finding the Row Asso...
UpdatedLikes 1
Comments 0
