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

Document ID : KB000006436
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

 

 

 

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.