DB2 9 Express C功能 [英] DB2 9 Express C Functionality
问题描述
如果我有ESE 8.2.5,我认为v9将能够安装和升级这样的没有问题吗? [当可用时
课程]
我正在调查我们是否也可以使用Express C作为开发/
测试环境相同,但我现在正在阅读我的想法
Express C中不支持DB2的关键元素,例如:
MQT(摘要表)
MDC表
其他内部功能将会丢失,我可以
找不到这样的限制。
Express C是否支持以下功能?
性能专家
自动FCM调整
自动存储
自动预取器/ Pagecleaners
自动自调整内存
开发人员工作台
DGTTs
表压缩
请参阅:
http://www-128.ibm.com/developerwork...m=805#13854931
有没有人有这个特定信息的链接?我可以
看到很多其他的通用比较信息,但没有任何内容
特别声明支持内部函数,如MDC / MQT
限制。
非常感谢,
Tim.D
p175写道:
如果我有ESE 8.2.5,我认为v9将能够获得这样的
安装和升级同样没问题? [可用的时候
套餐]
这就是这个想法。迁移时,DB2 V8
数据库当然有一些步骤。
我正在调查我们是否也可以使用Express C作为开发/
DB2的关键元素,例如:
MQT(汇总表)
MDC表
我不知道,但是这是有道理的,因为MQT和MDC
都是仓储中常用的相当高级的功能,而不是DB2 Express C部署的典型目标。
如果没有我的MQT,我将无法生存。如果确实如此,那么什么
其他内部功能将会丢失,我可以
找不到这样的限制。
Express C是否支持以下内容?
性能专家
性能专家是一种工具。你单独付钱。据我所知,它并不关心它连接的DB2版本。
自动FCM调优
FCM与DPF功能有关。就像担心没有潜望镜
在车上:-)
自动存储
绝对支持。对于
小型安装(典型的Express C)而不是大型安装,整个自动化的想法更为重要。
自动预取器/ Pagecleaners
支持(与上面相同)
自动自调整内存
支持(与上面相同)
开发人员工作台
DWB甚至支持Derby :-)
DGTTs
绝对支持。
表压缩
我强烈怀疑不是支持。
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
IOD会议
http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau schrieb:
p175写道:
>如果我有ESE 8.2.5,我认为v9将能够进行这样的安装和升级同样没有问题吗? [当然可用当然]
这就是主意。迁移时,DB2 V8
数据库当然有一些步骤。
>我正在调查我们是否也可以使用Express C作为开发/测试环境,但我现在正在阅读我认为的快捷C不支持DB2的关键元素,例如:
MQT(汇总表)
MDC表
我不知道,但它有道理,因为MQT和MDC都是>
是仓储中通常使用的相当高级的功能,它不是DB2 Express C部署的典型目标。
>没有我的MQT,我就无法生存。如果确实如此,那么对于内部功能将会遗漏什么呢?我可以找不到这些限制的内容。
Express中是否支持以下内容C?
性能专家
性能专家是一种工具。你单独付钱。最好的
我的知识并不关心它连接到哪个版本的DB2。
>自动FCM调优
FCM与DPF功能有关。就像担心没有潜望镜
in a car :-)
>自动存储
绝对支持。对于
小型安装(典型的Express C)而不是大型安装,整个自动化的想法更为重要。
>自动预取器/ Pagecleaners
支持(与上面相同)
>自动自调整内存
支持(与上面相同)
> Developer Workbench
DWB甚至支持Derby :-)
> DGTT
明确支持。
>表压缩
我强烈怀疑不支持。
参见
http://www-128.ibm.com/developerwork...m=805#13854931
问候,
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?
我正在调查我们是否也可以使用Express C作为开发/
测试环境相同,但现在正在阅读我认为的内容。快速C不支持
DB2的关键元素,例如:
MQT(汇总表)
MDC表
我不知道,但是这是有道理的,因为MQT和MDC
都是仓储中常用的相当高级的功能,而不是DB2 Express C部署的典型目标。
如果没有我的MQT,我将无法生存。如果确实如此,那么什么
else将会丢失内部功能,因为我可以
找不到这样的限制。
据我所知,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
解决方案p175 wrote: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]That''s the idea. There are steps to be taken of course for DB2 V8
databases when migrating.
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 tablesI 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.
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 ExpertPerformance 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.
Automatic FCM tuningFCM is about the DPF feature. Like worrying about not having a periscope
in a car :-)Automatic StorageDefinitely supported. The whole idea of automation is more important for
small installs (liek a typical Express C) than big ones.Automatic Prefetchers / PagecleanersSupported (same as above)
Automatic self-tuning memorySupported (same as above)
Developer WorkbenchDWB even supports Derby :-)
DGTTsDefinitly supported.
Table CompressionI 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/
Serge Rielau schrieb:p175 wrote:>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]That''s the idea. There are steps to be taken of course for DB2 V8
databases when migrating.
>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 tablesI 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.
>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 ExpertPerformance 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.
>Automatic FCM tuningFCM is about the DPF feature. Like worrying about not having a periscope
in a car :-)>Automatic StorageDefinitely supported. The whole idea of automation is more important for
small installs (liek a typical Express C) than big ones.>Automatic Prefetchers / PagecleanersSupported (same as above)
>Automatic self-tuning memorySupported (same as above)
>Developer WorkbenchDWB even supports Derby :-)
>DGTTsDefinitly supported.
>Table CompressionI 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''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 tablesI 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.
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.
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功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!