Troubleshooting SQL code -20212

You might receive SQL code -20212 after running the CREATE FUNCTION SYSFUN.SYSTS_ENCRYPT statement.

Procedure

To resolve this problem:

  1. Check whether the Java™ class name ‘com.ibm.es.nuvo.util.CryptionUtil.encrypt' displays in the message in mixed case letters.
  2. 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.
  3. 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.