Why PDTBATCC can get RC=12 without any messages?

Products

• RC Compare for DB2 for z/OS
• 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
• 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

Description:

Running 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.

XMANAGER log doesn't show any message.

Datastore is accessible through the Detector menus and it's possible to view all kind of data except for dynamic SQL in some intervals.

Solution:

• The PDTDLOAD and PDTBATCH JCL shipped in highlvl.SRCLIB do not have a REGION specification on the step EXEC card.
  
  The suggestion is to add REGION=0M in the EXEC card.
  
  
• The job didn't 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))

Environment

Release:
Component: PDT