RTN=008,RCODE=0002,DB2 SUBSYSTEM xxxx IS NOT OPERATIONAL

Products

• 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

Issue/Introduction

Doing an Explain after selecting an SQL statement from Detector Activity from a secondary member of a 2 member datasharing group.  It works on the primary member but not on the secondary member. Both members are defined in SETUP00.What is missing in our setup? This is happening both in R18 and R19.

 

 

 

Environment

Release:
Component: PPADB2

Resolution

The problem was caused by the wrong SSID name in the following control card DATABASE=(AUTO,@CURRDBA,SSID).  The subsystem is dependent on where the auto hversion was selected from. Fixing the SSID resolved the problem.