search cancel

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

book

Article ID: 49343

calendar_today

Updated On:

Products

Compress Data Compression for MVS Compress Data Compression for Fujitsu Datacom DATACOM - AD Disk Backup and Restore - MVS DISK BACKUP AND RESTORE- ADD-ON OPTIO DISK BACKUP AND RESTORE Ideal CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

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