- 最后登录
- 2016-6-27
- 在线时间
- 134 小时
- 威望
- 351
- 金钱
- 2586
- 注册时间
- 2012-3-16
- 阅读权限
- 60
- 帖子
- 188
- 精华
- 6
- 积分
- 351
- UID
- 309
|
1#
发表于 2012-4-19 09:23:04
|
查看: 3110 |
回复: 0
官方文档的透明网关配置中有这么一步“Configure Two-Phase Commit”
The gateway supports the following transaction capabilities:
- COMMIT_CONFIRM
- READ_ONLY
- SINGLE_SITE
The transaction model is set using the HS_TRANSACTION_MODEL initialization parameter. By default, the gateway runs in COMMIT_CONFIRM transaction mode. When the SQL Server database is updated by a transaction, the gateway becomes the commit point site. The Oracle database commits the unit of work in the SQL Server database after verifying that all Oracle databases in the transaction have successfully prepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit transaction as the commit point site.
To enable the COMMIT_CONFIRM transaction mode, perform the following tasks:
Create a Recovery Account and Password
Create the Transaction Log Table
The log table, called HS_TRANSACTION_LOG, is where two-phase commit transactions are recorded.
1.这一步是做什么用的,我现在没有配置也可以做提交和回滚,如果不配置这一步会有什么负面影响吗?
2.“By default, the gateway runs in COMMIT_CONFIRM transaction mode....To enable the COMMIT_CONFIRM transaction mode, perform the following tasks”
都说了默认是COMMIT_CONFIRM了,还需要配置干嘛?
[ 本帖最后由 gdpr-dba 于 2012-4-19 09:26 编辑 ] |
|