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.
The node from which this command is issued becomes the catalog node for the new database.
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.
>>-CREATE TOOLS CATALOG--catalog-name---------------------------> >--+-CREATE NEW DATABASE--database-name-----------------------------------------+--> '-USE EXISTING--+---------------------------------+--DATABASE--database-name-' '-TABLESPACE--tablespace-name--IN-' >--+-------+--+---------------+-------------------------------->< '-FORCE-' '-KEEP INACTIVE-'
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
db2 create tools catalog catalog1 use existing tablespace user32Ksp
in database toolsdb