Purpose of the Batch Processor THREADS parameter in BATPROC member

Products

• Batch Processor
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

How is the Batch Processor for Db2 for z/OS (RBP) THREADS parameter used and what is the recommended setting.

Resolution

The Batch Processor 'THREADS' parameter is found in the hlq.CDBAPARM(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.