We use XDB Migrate to migrate a table from Mainframe to a XDB  location.
The SQL code that is generated is not complete.
The CREATE for the auxiliary table misses the name of the table:

CREATE AUX TABLE STPS. IN STPS#00 . STORES STPS.MESAG_BROKR_LOG_0 COLUMN PAYLD_X;
CREATE INDEX STPS. ON STPS. ;

The create table is working.
The "CREATE AUX TABLE" does not.
It does not give us the table name for the AUX table.

In the error log of XDB Migrate, the following message is displayed
***************************************
X464 'STPS.MESAG_BROKR_LOG_2' is not available until Aux Tables and Indexes have been created
**************************************

This means that during the migrate the auxiliary table and the index are not discovered and the migrate fails.
Please ensure that the auxiliary table and the index exist in the DB2 on the Mainframe before trying to migrate them.
And also check the user that is used to make the migrate, has sufficient rights on these objects on the Mainframe.