DB2 10.5 for Linux, UNIX, and Windows

CREATE TOOLS CATALOG command

Creates the DB2® tools catalog tables in a new or existing database. The tools catalog contains information about the administrative tasks that are available to you.

The database must be local.

This command will optionally force all applications and stop and restart the database manager if new table spaces are created for the tools catalog. It will also update the DB2 Administration Server (DAS) configuration and activate the scheduler.

This command is not valid on a IBM® Data Server Client.

Scope

The node from which this command is issued becomes the catalog node for the new database.

Authorization

One of the following authorities:

SYSADM
SYSCTRL

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

Required connection

A database connection is temporarily established by this command during processing. This command will optionally stop and restart the database manager if new table spaces are created.

Command syntax


>>-CREATE TOOLS CATALOG--catalog-name--------------------------->

>--+-CREATE NEW DATABASE--database-name-----------------------------------------+-->
   '-USE EXISTING--+---------------------------------+--DATABASE--database-name-'   
                   '-TABLESPACE--tablespace-name--IN-'                              

>--+-------+--+---------------+--------------------------------><
   '-FORCE-'  '-KEEP INACTIVE-'

Command parameters

CATALOG catalog-name: A name to be used to uniquely identify the DB2 tools catalog. The catalog tables are created under this schema name.
NEW DATABASE database-name: A name to be assigned to the new database. This must be a unique name that differentiates the database from any other database in either the local database directory or the system database directory. The name must conform to naming conventions for databases.
EXISTING DATABASE database-name: The name of an existing database to host the tools catalog. It must be a local database.
EXISTING TABLESPACE tablespace-name: A name to be used to specify the existing 32K page table space used to create the DB2 tools catalog tables. A 32K page size temporary table space must also exist for the tables to be created successfully.
FORCE: When you create a tools catalog in a new table space, the database manager must be restarted, which requires that no applications be connected. Use the FORCE option to ensure that no applications are connected to the database. If applications are connected, the tools catalog creation will fail unless you specify an existing table space.
KEEP INACTIVE: This option will not update the DB2 administration server configuration parameters or enable the scheduler.

Examples

    db2 create tools catalog cc create new database toolsdb 

    db2 create tools catalog catalog1 use existing database toolsdb force

    db2 create tools catalog catalog1 use existing tablespace user32Ksp 
     in database toolsdb

    db2 create tools catalog toolscat use existing database toolsdb keep inactive

Usage notes

The tools catalog tables require two 32K page table spaces (regular and temporary). In addition, unless you specify existing table spaces, a new 32K buffer pool is created for the table spaces. This requires a restart of the database manager. If the database manager must be restarted, all existing applications must be forced off. The new table spaces are created with a single container each in the default database directory path.
If an active catalog with this name exists before you execute this command, it is deactivated and the new catalog becomes the active catalog.
Multiple DB2 tools catalogs can be created in the same database and are uniquely identified by the catalog name.
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™.
Updating the DAS configuration parameters requires DASADM authority on the DB2 administration server.
Unless you specify the KEEP INACTIVE option, this command updates the local DAS configuration parameters related to the DB2 tools catalog database configuration and enables the scheduler at the local DAS server.
The jdk_64_path configuration parameter must be set if you are creating a tools catalog against a 64-bit instance on one of the platforms that supports both 32- and 64-bit instances (AIX®, HP-UX, and Solaris).
In partitioned database environments, the 32 KB REGULAR table space must exist on the catalog partition, otherwise the command (such as the following one) will fail when a table space is specified:
```
db2 create tools catalog catalog1 use existing tablespace user32Ksp 
 in database toolsdb
```