New Gen HE install CEJOB05 "ERROR CODE '11 - INPUT CHAR FIELD IS TOO LONG'"

Products

• Gen - Host Encyclopedia
• Gen

Issue/Introduction

During the installation of new Gen 8.6 Host Encyclopedia (HE) and execution of JOB CEJOB05, there is an error being displayed which is causing the Load Utility to abend:

DSNU050I    182 09:38:02.58 DSNUGUTC -  LOAD DATA INDDN SPRP9A2                 
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -  INTO TABLE GEN86.SPRP                
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -   (PT_PROP_CODE POSITION(1) SMALLINT, 
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_MNEMONIC POSITION(3) CHAR(8),   
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_PROP_NAME POSITION(11) CHAR(32),
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_OBJ_TYPE_CODE POSITION(43) SMALL
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_FORMAT POSITION(45) CHAR(1),    
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_PCTYPE POSITION(46) CHAR(8),    
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_LENGTH POSITION(54) SMALLINT,   
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_OPT POSITION(56) CHAR(1),       
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_DEF_INT POSITION(57) INTEGER,   
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_DEF_CHAR POSITION(61) CHAR(32), 
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_OBJ_DIV POSITION(93) CHAR(8),   
DSNU650I  -DBCG 182 09:38:02.58 DSNURWI -    PT_RELEASE POSITION(101) CHAR(8)) R
DSNU334I  -DBCG 182 09:38:03.26 DSNURCON - INPUT FIELD 'PT_PROP_NAME',          
                      INVALID FOR 'GEN86.SPRP',                                 
                      ERROR CODE '11 - INPUT CHAR FIELD IS TOO LONG'            

Resolution

This error is likely related to the DB2 database encoding.
To find the encoding scheme for the database run SQL on SYSIBM.SYSDATABASE look at the value of the column ENCODING_SCHEME for the relevant database name: Db2 for z/OS 13 > SYSDATABASE catalog table

It was confirmed that the encoding scheme on the 3 DB2 databases is set to 'U' for UNICODE.
The enhancement PTFs (SO14007, SO14008, and SO14009) for using a DB2 subsystem defined as UNICODE were not installed.
These PTFs explicitly specify EBCDIC when creating DB2 database objects and binding DB2 plans/packages.

See Gen Maintenance Grid page for Gen 8.6 and "PTFs Available" = "Since GA":

For the Host Encyclopedia (HE) the PTF is SO14007.