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

Document ID : KB000049343
Last Modified Date : 14/02/2018
Show Technical Document Details

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

File Attachments:
TEC581210.zip