Trying to create the database tables using the DDL supplied by RO71688 DB2 DDL DOES NOT WORK WITH EXPLICIT TABLESPACES and getting DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE.
DB2 V10 CM
DB2 V10 CM is in Conversion Mode instead of NFM and the required function is not available. Please note that you must be at DB2 Version 9 NFM or higher.
Complete the migration from Conversion Mode to DB2 10 NFM
Use the internal Derby database until the conversion has been completed. Then use RO74120 NEED CONVERSION FROM INTERNAL DATABASE TO DB2 to convert from the internal Derby database to DB2.
Please refer to Migration modes for DB2 8 to DB2 10 in the IBM Knowledge Center.