DB2® does not fully support stored procedures and UDFs that contain distinct types (user-defined types) as parameters.
Deploying Java™ stored procedures using the Universal Driver and targeting DB2 for Linux®, UNIX®, and Windows® Version 8.1 is not supported.
After importing a Java stored procedure from the file system, and successfully deploying it to the target database, running the stored procedure might fail. The method name might conflict with a method name that already exists in the environment where the stored procedure is running.
You must ensure that the stored procedure implementation class is uniquely identified by including it in a package. Insert a package statement in the Java source, and import the stored procedure to the development project. Also, make sure that the stored procedure implementation method has a unique name. You can do this by modifying the method name in the Java source before importing it to the development project.
java.sql.SQLException: invalid options string at com.ibm.db2.jcc.sqlj.Binder.a(Binder.java:1018) at com.ibm.db2.jcc.sqlj.Binder.a(Binder.java:775) at com.ibm.db2.jcc.sqlj.Binder.a(Binder.java:432) at com.ibm.db2.jcc.sqlj.Binder.bindMain(Binder.java:338) at com.ibm.db2.jcc.sqlj.Customizer.customizeMain(Customizer.java:810) at com.ibm.db2.jcc.sqlj.Customizer.main(Customizer.java:272)
This problem is fixed in DB2 UDB for Linux, UNIX, and Windows Version 8 Fixpak 6. To work around this error, specify all other bind options after the ACTION(REPLACE) option. For example, use ACTION(REPLACE) BLOCKING(ALL) instead of BLOCKING(ALL) ACTION(REPLACE).
To avoid this error if you are using only the ACTION(REPLACE) option, the default validation level for binding a package to a remote server will be automatically added as follows: ACTION(REPLACE) VALIDATE(BIND).