Mapping non-unique secondary indexes is slightly different to mapping unique secondary indexes. To ensure that CICS® VT retrieves the records in exactly the same sequence as VSAM, you must add a column to the DB2 table.
The column name must be VID_PATH_DUPKEY and the data type must be TIMESTAMP. The column can be in any position in the table after the primary key column or columns and must not be nullable. The VID_PATH_DUPKEY column should be the last column in the DB2®index.
The data value in this column is managed by CICS VT. The column must be included in the table prior to generating the drivers and performing data migration.