It would be best for you to confirm the expected DDL changes for CMOD V10 with IBM.
We found ARSDB performed the following Alters during our CMOD V9.5 to CMOD V10.1 upgrade:
ALTER TABLE ARSSERVR.ARSHOLDMAP
ADD COLUMN DOC_UUID AFTER RES_ID
(CHAR(36) FOR SBCS DATA
NOT NULL WITH DEFAULT)
ALTER TABLE ARSSERVR.ARSRES
ADD COLUMN CRYPT_STATUS AFTER EXP_DT
(SMALLINT)
ADD COLUMN HASH_VAL AFTER EXP_DT
(CHAR(32) FOR BIT DATA)
ALTER TABLE ARSSERVR.ARSSYS
ADD COLUMN KEYSTORE_TYPE AFTER <LAST>
(VARCHAR(16) FOR SBCS DATA)
ADD COLUMN KEYSTORE_LOCATION AFTER <LAST>
(VARCHAR(254) FOR SBCS DATA)
ADD COLUMN KEYSTORE_MKL AFTER <LAST>
(VARCHAR(128) FOR SBCS DATA)
ADD COLUMN KEYSTORE_MKL_DT AFTER <LAST>
(TIMESTAMP)
ADD COLUMN DATA_EKEY AFTER <LAST>
(VARCHAR(254) FOR BIT DATA)
ALTER INDEX ARSSERVR.ARSHOLDMAP_IDX
KEYCOLUMNS (HID ASC, AGID ASC, AID ASC, "NAME" ASC,
DOC_OFF ASC, DOC_LEN ASC, COMP_OFF ASC, COMP_LEN ASC, DOC_UUID ASC)