Search code examples
db2java-stored-procedures

How to drop DB2 Java Stored Procedure?

I have deployed a Java Stored Procedure through IBM Data Studio, and now I want to undeploy it, but I don't know how to do it completely.

I know you have to drop the procedure by calling DROP PROCEDURE <procedure name>.

Delete the record from SYSIBM.SYSJAVAOPTS that has my JAR_ID.

But how do you undeploy what SQLJ.DB2_INSTALL_JAR did?

It must have register my JAR file somewhere on DB2 because the first parameter is a BLOB of the JAR.

Solution

  • This can be done with the call sqlj.remove_jar( jar-id ) statement as described in JAR file administration on the database server.