Copy Detector datastore from a previous release to a recently installed release PDT0316

Products

• Detector for DB2 for z/OS

Issue/Introduction

A recent Detector for Db2 for z/OS (PDT) release has been installed and you define a new Detector datastore in the new release. Would like to copy the
previous Detector datastore to the new Detector datastore defined in the new release with JCL in hlq.CDBAJCL(PDTDSCPY) member but the
PDT0316 message is displayed and job finished with RC=08.
 
PDT0316 DATASTORE xxx IS UNAVAILABLE, DSN=hlq.DTR0002.ssid

Resolution

Problem was the Detector datastore defined in the recently installed release did not have same structure as the Detector datastore defined
in the previous release.  The DTR0002 data set for Exceptions was defined in the Detector datastore for the recently installed release
but it was not defined in the Detector datastore for previous release .
 
This Copy process is not supported, you have to copy the Detector datastore from a previous release to recently installed release exactly with
same structure. Internally the structure of the Detector datastore is stored in the Xmanager Control file, so although you manually deleted or define the DTR0002
data set for Exceptions, the data set name is still in the Xmanager Control file.
 
There is no way of modifying an existing Detector datastore. After the DTR0002 (Exception) and DTR0003 (SQL Error) data sets have been defined
for a Detector datastore they cannot be dynamically removed, the opposite is the same, to add the Exception or SQL Error data sets to the
Detector datastore, you have to create a new Detector datastore and add those additional data sets during the creation.