DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE with CA OUTPUT Management Web Viewer 12.1

Document ID : KB000045471
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms: 

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.

Environment:  

DB2 V10 CM

Cause: 

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. 

Resolution:

Complete the migration from Conversion Mode to DB2 10 NFM

Workaround:

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.

Additional Information:

Please refer to Migration modes for DB2 8 to DB2 10 in the IBM Knowledge Center.