Why does Detector PDTBATCC execution return RC=12 without any messages.

Products

• Detector for DB2 for z/OS

Issue/Introduction

Executing Detector for Db2 for z/OS (PDT) PDTBATCC to unload datastores into a sequential flat file, the job gets RC=12 without explanation of what has happened.
Adding MSGLEVEL=(1,1), doesn't shows any more info. The Xmanager log does not show any message. The PDT 
Datastore is accessible through the Detector menus and it is possible to view all kind of data except for dynamic SQL in some intervals.

Resolution

• The PDTDLOAD and PDTBATCH JCL shipped in highlvl.CDBAJCL do not have a REGION specification on the step EXEC card.
  The suggestion is to add REGION=0M in the EXEC card.
  
  
• The job did not specify DD cards for sort work datasets.
  In this situation, the sort installation defaults are used which controls dynamic allocation of the sort work datasets.
  It appears that in certain intervals that a large amount of Exception data is collected that is exceeding available sort work space based on the sort installation defaults.
  
  The suggestion is to specify sort work datasets in the JCL, for example:
  
  //SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(100,300))
  //SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(100,300))
  //SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(100,300))
  //SORTWK04 DD UNIT=SYSDA,SPACE=(CYL,(100,300))