ACTIVE THREADS STATUS

Document ID : KB000017646
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

What does the status of PARENT-D and CHSUM-D mean? Is this an enhancement of the old DDF status? Some of the get pages keep increasing, but not all of them. Any reason why these statuses are in RED?

Does the status change when the thread is actually in DB2?

Solution:

Here are the explanations for all the statuses:

CHILD-D CHILD thread executing SQL code.
PARENT-D PARENT thread executing SQL code.
PARENT-A PARENT thread executing application code.
CHSUM-D CHILD summary thread executing SQL code.
CHILDSUM CHILD summary thread not executing in DB2 code.

To understand these fields, you should read about parallel tasks in the DB2 Administration Guide. Briefly, when the facility is enabled and DB2

determines via its own rules & algorithms that it can process multiple I/O operations for the same request independently, DB2 will create a separate thread to process each I/O. These additional processes are CHILD processes. The original thread is the PARENT.

The SUMMARY record is a record which contains the totals of the parent and all children in a subsystem that

  1. supports parallel processing, and

  2. the appserver threads stay connected because of the Keepdynamic (yes) parameter in the bind plan.

The thread status will change instantaneously to "not-active" or "waiting-for-request" if the appserver threads, both parents and children, are not serving any request.