DBXCATA CAF 1001 Error

Products

• Repository

Issue/Introduction

Receiving a CAF 1001 Error when trying to execute program DBXCATA to extract from DB2 10/11.  When running the DBXCAT9 extract program the process completes successfully.  

*** CALL ATTACH ERROR ***

DB2 SSID:                 : DST        

Return Code               : 12

Repository Error Code : CAF 1001

Environment

CA Repository for z/OS 7.2 Exchange for COBOL

Cause

This occurs when the SSID specified in 3 characters in length.  The program DBXCATA expects a 4 character DB2 SSID.  

When a 3 character DB2 SSID is specified a space is appended into the 4th position.  This causes the DBXCATA program to not find the 3 character SSID. 

 

Resolution

In the DBXCATA parm string, place the 3 character DB2 SSID in double quotes and add an extra space after the last character before the closing parentheses

For example

PARM=('ERRCOUNT(0)/"DST " N N Y'),