Troubleshooting scripts

You may have internal tools or scripts that are based on the processes running in the database engine. These tools or scripts may no longer work because all agents, prefetchers, and page cleaners are now considered threads in a single, multi-threaded process.

Your internal tools and scripts will have to be modified to account for a threaded process. For example, you may have scripts that start the ps command to list the process names; and then perform tasks against certain agent processes. Your scripts must be rewritten.

The problem determination database command db2pd will have a new option -edu (short for engine dispatchable unit) to list all agent names along with their thread IDs. The db2pd -stack command continues to work with the threaded engine to dump individual EDU stacks or to dump all EDU stacks for the current node.