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=:
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