DB2 Version 9.7 for Linux, UNIX, and Windows

DROP TOOLS CATALOG command

Drops the DB2® tools catalog tables for the specified catalog in the given database. This command is not valid on a IBM® Data Server Client.

Warning: If you drop the active tools catalog, you can no longer schedule tasks and scheduled tasks are not executed. To activate the scheduler, you must activate a previous tools catalog or create a new one.

Scope

This command affects the database.

Authorization

One of the following:

sysadm
sysctrl

The user must also have DASADM authority to update the DB2 administration server (DAS) configuration parameters.

Required connection

A database connection is temporarily established by this command during processing.

Command syntax


>>-DROP TOOLS CATALOG--catalog-name--IN DATABASE--database-name--+-------+-><
                                                                 '-FORCE-'

Command parameters

CATALOG catalog-name: A name to be used to uniquely identify the DB2 tools catalog. The catalog tables are dropped from this schema.
DATABASE database-name: A name to be used to connect to the local database containing the catalog tables.
FORCE: The force option is used to force the DB2 administration server's scheduler to stop. If this is not specified, the tools catalog will not be dropped if the scheduler cannot be stopped.

Examples

db2 drop tools catalog cc in database toolsdb

db2 drop tools catalog in database toolsdb force

Usage notes

The jdk_path configuration parameter must be set in the DB2 administration server (DAS) configuration to the minimum supported level of the SDK for Java™.
This command will disable the scheduler at the local DAS and reset the DAS configuration parameters related to the DB2 tools catalog database configuration.