Troubleshooting SQL code -20212
You might receive SQL code -20212 after running the CREATE FUNCTION SYSFUN.SYSTS_ENCRYPT statement.
Procedure
To resolve this problem:
- Check whether the Java™ class
name
‘com.ibm.es.nuvo.util.CryptionUtil.encrypt'displays in the message in mixed case letters. - If this class name is displayed in uppercase letters, run
the CREATE FUNCTION SYSFUN.SYSTS_ENCRYPT statement again with the Java class name in mixed case letters. You can find this statement in Db2® installation job DSNTIJNX.
- If the class name displays correctly in the message, verify
that you have provided the correct DB2_BASE environment variable in
the JAVAENV data set. A DB2_BASE statement is required only if the Db2 HFS files are installed in a directory other than /usr/lpp/db2b10/jdbc.