DROP TOOLS CATALOG command

The DROP TOOLS CATALOG command drops the Db2® tools catalog tables for the specified catalog in the given database.

Important: The DROP TOOLS CATALOG command has been deprecated for Db2 version 11.5.5, and will be discontinued in a future release or modification pack. The tools catalog is used to manage tasks within the Database Administration Server (DAS) which was deprecated in version 9.7.

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 authorities:
  • 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

Read syntax diagramSkip visual syntax diagramDROP TOOLS CATALOGcatalog-nameIN DATABASEdatabase-nameFORCE

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.