Purpose of the Batch Processor 'THREADS' parameter.

Products

• RC Compare for DB2 for z/OS
• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS
• Endevor
• Endevor Natural Integration
• Endevor - ECLIPSE Plugin
• Endevor - Enterprise Workbench

Issue/Introduction

Description

How is the 'THREADS' parameter used and what is the recommended setting?

Solution

The Batch Processor 'THREADS' parameter is found in the hlq.PARMLIB(BATPROC) library member. It allows the user to specify whether to use single or multiple threads for SELECT and SQL processing.

The 'THREADS' parameter can be set to either '1' or '2'.

Single-threading can be achieved by setting the parameter to '1' and this can avoid any potential object contention problems, such as -904 SQL errors.

For example:

    DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN 
    UNAVAILABLE RESOURCE. REASON 00E70010, TYPE OF RESOURCE 
    00000801, AND RESOURCE NAME AUTHPLAN_COM.PTADRVAC.17706531010- 
    C5D99 

However as object contention problems for the Batch Processor are exceptional and very rare, it is recommended that the 'THREADS' parameter be set to '2', to obtain the performance improvements when using multiple-threading.

Environment

Release:
Component: ENDBAS