CA Datacom DBUTLTY LOAD is failing with DB13018E - OPEN ERROR, RETURN CODE 63 (63).

Products

• CA Compress Data Compression for MVS
• CA Compress Data Compression for Fujitsu
• CA Datacom - DB
• CA Datacom
• CA Datacom - AD
• CA Datacom - Server
• CA Disk Backup and Restore - MVS
• CA DISK BACKUP AND RESTORE- ADD-ON OPTIO
• CA DISK BACKUP AND RESTORE
• CA Ideal
• CA CIS
• CA Common Services for z/OS
• CA 90s Services
• CA Database Management Solutions for DB2 for z/OS
• CA Common Product Services Component
• CA Common Services
• CA ecoMeter Server Component FOC
• CA Easytrieve Report Generator for Common Services
• CA Infocai Maintenance
• CA IPC
• Unicenter CA-JCLCheck Common Component
• CA Mainframe VM Product Manager
• CA Chorus Software Manager
• CA On Demand Portal
• CA Service Desk Manager - Unified Self Service
• CA PAM Client for Linux for zSeries
• CA Mainframe Connector for Linux on System z
• CA Graphical Management Interface
• CA Web Administrator for Top Secret
• CA CA- Xpertware
• CA Datacom/AD

Issue/Introduction

Description:

DBUTLTY LOAD with the following statement...

LOAD DBID=123,DDNAME=ABC123,FORMAT=format,OPTIMIZE=YES,
SORT=1000000,TABLE=ABC,AREA=ABC

... is failing with ...

DB13018E - OPEN ERROR, RETURN CODE 63 (63)

DB00501E - OPEN ERROR - RETURN CODE 63 (063) CXX=cxx (ABC123 )
DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)

Solution:

The RC 63(63) occurs because the DDNAME (ABC123) matches the area (ABC) and DBID (123) names so Datacom was trying to access it as the actual database area rather than as the input to the LOAD.

From the CA Datacom/DB DBUTLTY Reference Guide for z/OS Version 14.0:

LOAD (Build a Data Area)

,DDNAME= Specifies the JCL DDname for the input data set.
This parameter is not allowed if you specify FORMAT=NONE. This parameter is required when you specify any value other than NONE for FORMAT=.
A DDNAME is not acceptable for sequential input or output files if it is a name reserved for a CA Datacom area. Names with the following patterns are therefore not acceptable for DDNAME=:

• 3-byte names that end with XX, meaning they are reserved as either current or future CA Datacom control areas.
• 6-byte names that end with what could be a database ID from 001 through 999.
• 7-byte names that end with what could be a database ID from 1000 through 9999.

To correct it and rerun the DBUTLTY LOAD, change the DDname to something other than an area and DBID combination:

//ABC123 DD DISP=SHR,DSN=input.load.dataset

... to ...

//loadimp DD DISP=SHR,DSN=input.load.dataset

And, change the LOAD DDNAME= to match:

LOAD DBID=123,DDNAME=ABC123,FORMAT=format,OPTIMIZE=YES,
SORT=1000000,TABLE=ABC,AREA=ABC

… to …

LOAD DBID=123,DDNAME=loadimp,FORMAT=format,OPTIMIZE=YES,
SORT=1000000,TABLE=ABC,AREA=ABC

Environment

Release:
Component: CA90S