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

book

Article ID: 49343

calendar_today

Updated On:

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

Attachments

1558535077966TEC581210.zip get_app