本文介绍了DB2 9 Express C功能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

限时删除!!

如果我有ESE 8.2.5,我认为v9将能够安装和升级这样的没有问题吗? [当可用时
课程]


我正在调查我们是否也可以使用Express C作为开发/

测试环境相同,但我现在正在阅读我的想法

Express C中不支持DB2的关键元素,例如:


MQT(摘要表)

MDC表


其他内部功能将会丢失,我可以

找不到这样的限制。


Express C是否支持以下功能?


性能专家

自动FCM调整

自动存储

自动预取器/ Pagecleaners

自动自调整内存

开发人员工作台

DGTTs

表压缩


请参阅:



有没有人有这个特定信息的链接?我可以

看到很多其他的通用比较信息,但没有任何内容

特别声明支持内部函数,如MDC / MQT

限制。


非常感谢,


Tim.D

解决方案



这就是这个想法。迁移时,DB2 V8

数据库当然有一些步骤。



我不知道,但是这是有道理的,因为MQT和MDC

都是仓储中常用的相当高级的功能,而不是DB2 Express C部署的典型目标。



性能专家是一种工具。你单独付钱。据我所知,它并不关心它连接的DB2版本。



FCM与DPF功能有关。就像担心没有潜望镜

在车上:-)



绝对支持。对于

小型安装(典型的Express C)而不是大型安装,整个自动化的想法更为重要。



支持(与上面相同)



支持(与上面相同)



DWB甚至支持Derby :-)



我强烈怀疑不是支持。


干杯

Serge


-

Serge Rielau

DB2解决方案开发

IBM多伦多实验室


IOD会议




这就是主意。迁移时,DB2 V8

数据库当然有一些步骤。



我不知道,但它有道理,因为MQT和MDC都是>
是仓储中通常使用的相当高级的功能,它不是DB2 Express C部署的典型目标。



性能专家是一种工具。你单独付钱。最好的

我的知识并不关心它连接到哪个版本的DB2。



FCM与DPF功能有关。就像担心没有潜望镜

in a car :-)



绝对支持。对于

小型安装(典型的Express C)而不是大型安装,整个自动化的想法更为重要。



支持(与上面相同)



支持(与上面相同)



DWB甚至支持Derby :-)



明确支持。



我强烈怀疑不支持。



参见



问候,

Burkhard

-

A:Weil es die Lesbarkeit des Textes verschlechtert。

F:Warum ist TOFU so schlimm?

A:TOFU

F:ist das gr ?? te? rgernis im Usenet?




我不知道,但是这是有道理的,因为MQT和MDC

都是仓储中常用的相当高级的功能,而不是DB2 Express C部署的典型目标。



据我所知,Express-C支持MDC和MQT。我在64位Linux上的DB2 Express-C测试中使用了这两个功能。


希望这会有所帮助,


Fred


If I have ESE 8.2.5, I assume v9 will be able to take such an
installation and upgrade same without problems ? [when available of
course]

I''m investigating whether we can also use Express C as a development /
test environment for same but am now reading that what I thought were
key elements of DB2 are not supported in Express C, for example:

MQT (Summary Tables)
MDC tables

I can''t survive without my MQTs. If this indeed the case, then what
else is going to be missing inregard to internal features for I can
find no menton of such restrictions.

Are the following supported in Express C ?

Performance Expert
Automatic FCM tuning
Automatic Storage
Automatic Prefetchers / Pagecleaners
Automatic self-tuning memory
Developer Workbench
DGTTs
Table Compression

See:
http://www-128.ibm.com/developerwork...m=805#13854931

Does anyone have any links to this specific information as yet ? I can
see a lot of other generic comparison info but nothing that
SPECIFICALLY states support of internal functions such as MDC / MQT
restrictions.

Many thanks,

Tim.D

解决方案

That''s the idea. There are steps to be taken of course for DB2 V8
databases when migrating.

I didn''t know that, but it makes kind of sense, since both MQT and MDC
are fairly advanced features typically used in warehousing which is not
the typical target of an DB2 Express C deployment.

Performance expert is a tool. You pay for it separately. To the best of
my knowledge it doesn''t care what edition of DB2 it connects to.

FCM is about the DPF feature. Like worrying about not having a periscope
in a car :-)

Definitely supported. The whole idea of automation is more important for
small installs (liek a typical Express C) than big ones.

Supported (same as above)

Supported (same as above)

DWB even supports Derby :-)

Definitly supported.

I strongly suspect NOT supported.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/


That''s the idea. There are steps to be taken of course for DB2 V8
databases when migrating.

I didn''t know that, but it makes kind of sense, since both MQT and MDC
are fairly advanced features typically used in warehousing which is not
the typical target of an DB2 Express C deployment.

Performance expert is a tool. You pay for it separately. To the best of
my knowledge it doesn''t care what edition of DB2 it connects to.

FCM is about the DPF feature. Like worrying about not having a periscope
in a car :-)

Definitely supported. The whole idea of automation is more important for
small installs (liek a typical Express C) than big ones.

Supported (same as above)

Supported (same as above)

DWB even supports Derby :-)

Definitly supported.

I strongly suspect NOT supported.

See
http://www-128.ibm.com/developerwork...m=805#13854931

Regards,
Burkhard
--
A: Weil es die Lesbarkeit des Textes verschlechtert.
F: Warum ist TOFU so schlimm?
A: TOFU
F: Was ist das gr??te ?rgernis im Usenet?


I didn''t know that, but it makes kind of sense, since both MQT and MDC
are fairly advanced features typically used in warehousing which is not
the typical target of an DB2 Express C deployment.

As far as I can tell, MDC and MQTs are supported in Express-C. I have
been using both features in my tests of DB2 Express-C on 64-bit Linux.

Hope this helps,

Fred


这篇关于DB2 9 Express C功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

1403页,肝出来的..

09-06 09:27