linux db2任务中心,db2中任务中心不能使用,你可能需要创建"工具目录"

CREATE TOOLS CATALOG Command

Creates the DB2 tools catalog tables in a new or existing

database. The database must be local.

The tools catalog contains information about the administrative

tasks that you configure with such tools as the Task Center and

Control Center.

Note:

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 DB2 client.

Scope

The node from which this command is issued becomes the catalog

node for the new database.

Authorization

One of the following:

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

a4c26d1e5885305701be709a3d33442f.pnga4c26d1e5885305701be709a3d33442f.png>>-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 use existing database toolsdb force

db2 create tools catalog foobar 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.

3 The jdk_path configuration parameter must be set in the

DB2 administration 3 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.

1 The jdk_64_path configuration parameter 1 must be set if you are 1 creating a tools catalog against a 64-bit

instance on one of the platforms that 1

supports both 32- and 64-bit instances (AIX, HP-UX, and the Solaris

Operating Environment).

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值