DB2 TOOLS CATALOG – Is it required?

26 September,2013 by Jack Vamvas

Question: Is the  DB2 TOOLS catalog required? How do I know if a DB2 instance has the TOOLS catalog installed and what are options for managing?

Answer: One of the purposes of the DB2  TOOLS catalog is  to use the task scheduling facility. You can verify  if DB2 TOOLS catalog  exists by executing the list db directory command. It is listed along with other user databases.

The TOOLS catalog is a repository of tables for the Task Center schedules, definitions and history.The decision on whether the catalog is required depends on how the DB2 server is managed by the DBA. The DB2 server functions without the TOOLS catalog.

You can verify DAS access by using the GET ADMIN CFG command. The command displays the TOOLS CATALOG configuration settings

If the TOOLS CATALOG exists – an installation process created the catalog.  It is useful to identify which process created the catalog and make any adjustments to the install scripts .

Creating the catalog requires the CREATE TOOLS CATALOG command

To delete the DB2 TOOLS catalog table use the DROP TOOOLS CATALOG command

Note: Use  force option  force the DB2 administration server's scheduler to stop, otherwise the catalog can’t be dropped


db2 drop tools catalog mydb in database toolsdb
db2 drop tools catalog in database toolsdb force

Read More

 Changing DB2 database pagesize - DBA DB2

Trace sql statements in DB2 database - DBA DB2

How to monitor a deadlock in DB2 - DBA DB2

Author: Jack Vamvas(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on DB2 TOOLS CATALOG – Is it required?

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright