DB2 Version 9.7 for Linux, UNIX, and Windows

FP5: Load serviceability has been improved

In Version 9.7 Fix Pack 5 and later fix packs, load operations are easier to troubleshoot because additional diagnostic information is available through the db2pd command. You can obtain the diagnostic information by using the enhanced -utilities parameter and the new-load parameter.

The enhanced db2pd -utilities output includes the load ID and the application ID in the Description column. You can use the load ID to identify the corresponding log entries for a load operation in the db2diag log files.

The new -load parameter displays engine dispatchable unit (EDU) information such as the EDU name, EDU ID, application handle, application ID, load ID, load start time, and load phase for all load operations. You can use the EDU information obtained to perform further troubleshooting steps on problematic load operations, such as running the db2trc command. The -load parameter has three options:

The loadID option returns all EDU information for a specific load operation.
The file option redirects the output to a specified file.
The stacks option dumps the stack traces for the load EDUs that are stored in the diagpath directory.