DB2 Connection failed return code 0106,reason code 00000085
search cancel

DB2 Connection failed return code 0106,reason code 00000085

book

Article ID: 73201

calendar_today

Updated On:

Products

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

Issue/Introduction

PDASTATS job failed with the following messages:
IDCAMS LISTCAT processing has been optimized for increased performance 12:41:25
Collection of X2 - DB2KHCH.XR1KEY - Started 12:41:25 DB2 Connection failed - SYSID DB2D, return code 0106,reason code 00000085
Collection of X2 - DB2KHCH.XR1KEY - Incomplete RC=8

Environment

Release:
Component: PDA

Resolution

Problem was caused by missing definition of the datasharing group member in the SETUPxx. In a given SETUPxx member for Data Sharing you should have the Group Attach Name and any members executing on a LPAR defined individually within the CDBAPARM/PARMLIB.