ACTIVE THREADS STATUS

book

Article ID: 17646

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

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.

Environment

Release: BINDAN00200-14-Bind Analyzer-for DB2 for z/OS
Component: