|
|
|
Federation DB2 - MSSQL
|
|||
|---|---|---|---|
|
#18+
Добрый день. Стоит задача передать часть данных с db2 11.5 в Microsoft SQL Server 2019 Ent. Федерацию настроили, в db2 можем читать таблицы с MSSQL. А вот с two-phase commit, проблема : SQL1811N The statement failed because some aspect of the Federated data source is not supported with Federated two-phase commit transactions. Reason code: "1". Требуется ли на стороне MSSQL сервера дополнительное ПО ? Не совсем понял эти пункты Restrictions: For Microsoft SQL Server data sources, federated two-phase commit is only supported by Federation component installed on Windows. The Db2® isolation level is not propagated to the Microsoft SQL server. Спс. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 16.09.2021, 10:41:19 |
|
||
|
Federation DB2 - MSSQL
|
|||
|---|---|---|---|
|
#18+
Larry E., Добрый день. Код: plaintext Код: plaintext ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 17.09.2021, 17:27:40 |
|
||
|
|
start [/forum/search_topic.php?author=foxZ&author_mode=last_topics&do_search=1]: |
0ms |
get settings: |
8ms |
get forum list: |
15ms |
get settings: |
10ms |
get forum list: |
16ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
87ms |
get topic data: |
13ms |
get first new msg: |
7ms |
get forum data: |
3ms |
get page messages: |
44ms |
get tp. blocked users: |
2ms |
| others: | 1225ms |
| total: | 1438ms |
| 0 / 0 |
