Dropping JAR files from a database

You can use the Data Source Explorer to drop JAR files from a database server. Dropping a JAR file from the database does not remove the JAR file from any data development projects that contain it. If the JAR file information is still in a data development project, you can deploy the JAR file again. This feature is only supported for DB2® for z/OS® Version 9 database servers.
Before you begin
Prerequisite: Before you drop a JAR file from a database, you must identify and resolve any dependencies on the JAR file. If you do not resolve dependencies, you see an error message when you attempt to drop the JAR file. You can follow these steps to resolve the dependencies:
  1. Identify all dependent JAR files by running a query on SYSIBM.SYSJAVAPATHS, where PE_JARSCHEMA and PE_JAR_ID correspond to the JAR file that you want to drop.
  2. Import any dependent JAR files into a data development project and remove any references to the JAR file.
  3. Deploy the dependent JAR files back to the server, with the references removed.
  4. Identify all dependent routines by running a query on SYSIBM.SYSROUTINES, where JARSCHEMA and JAR_ID correspond to the JAR file that you want to drop.
  5. Drop all dependent routines from the database server.
About this task

To drop a JAR file from a database:

  1. Switch to the Data perspective.
  2. In the Data Source Explorer, open a database connection.
  3. Right-click a JAR file under a schema node, and click Drop.
Results
The JAR file is dropped from the database.

Feedback