旅途

如果想飞得高,就该把地平线忘掉

must the system catalog tablespace by manage by sms or could it be also managed by dms

'm almost certain that it must be SMS.

It can be DMS. But you have to say so at CREATE DATABASE time:

$ db2 "CREATE DB x CATALOG TABLESPACE MANAGED BY DATABASE USING ( FILE
'sys_ts' 100000 )"
DB20000I The CREATE DATABASE command completed successfully.
$ db2 list tablespaces

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 2
Name = USERSPACE1
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal


--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Reply with quote

posted on 2009-09-25 00:37 旅途 阅读(250) 评论(0)  编辑 收藏 引用 所属分类: DB2


只有注册用户登录后才能发表评论。
网站导航: 博客园   IT新闻   BlogJava   知识库   博问   管理