CA Web Viewer 12.1 DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION

Products

• Output Management Web Viewer

Issue/Introduction

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

Release: CA Output Management Web Viewer 12.1

Component: WBVLUW

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.