DB2 Version 9.7 for Linux, UNIX, and Windows

Creating a database for the DB2 tools catalog

Use the Create New Tools Catalog window to create the DB2® tools catalog on a cataloged system that currently has no metadata storage. The tools catalog is a set of tables in a database that is used by the Task Center to store task definitions, schedules, and task history information.

About this task

You can choose to use an existing database or create a new one. Creating this database also enables Task Center, which provides support for a more complex scheduling scheme for managing different tasks and scripts.
  • Open the Create New Tools Catalog window: Click Create New from the Enabling Scheduling Function group box of your current window, wizard, or notebook. For instance, click Create New from the Schedule page of the Tools Settings notebook.
  • Select the instance where the tools catalog is to be created, and type the tools catalog schema name.
  • Specify whether to create a new database or use an existing one.
  • Select whether to force all applications for instance restart and whether to activate the tools catalog when it is created.

Troubleshooting tips

If you receive a -567 return code when trying to create a new tools catalog, try running the db2admin setid command and stop and start the DAS. This error indicates that an invalid user ID or password has been submitted.