메시지 플로우가 Oracle 데이터베이스와 상호작용하고 메시지 플로우의 다른 조치와 데이터베이스에 작성된 갱신을 통합하려면 브로커가 이러한 갱신을 관리하도록 구성하십시오.
시작하기 전에
이 작업을 완료하려면 먼저 다음 작업을 완료해야 합니다.
다음 지시사항은 XA 통합을 위한 Oracle 데이터 소스 구성 방법에 대해 설명합니다. WebSphere MQ을 사용하여 XA 통합용으로 Oracle을 구성하는 데 대한 자세한 정보는 WebSphere MQ시스템 관리의 "Oracle 구성" 절을 참조하십시오.
트랜잭션 통합자로 WebSphere MQ 버전 5.0를 사용하여 XA 통합용으로 Oracle 데이터 소스를 구성하려면 다음을 수행하십시오.
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID+ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=install_dir/merant/lib/UKoradtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
필드 | 값 |
---|---|
SwitchFile | C:\Program Files\IBM\MQSI\6.0\bin\UKor8dtc20.dll |
XAOpenString | ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ |
ThreadOfControl | THREAD |
트랜잭션 통합자로 WebSphere MQ 버전 6.0을 사용하여 XA 통합용으로 Oracle 데이터 소스를 구성하려면 다음을 수행하십시오.
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.sl XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKor8dtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=OracleXA SwitchFile=UKoradtc20.so XAOpenString=ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ XACloseString= ThreadOfControl=THREAD
필드 | 값 |
---|---|
SwitchFile | UKor8dtc20.dll |
XAOpenString | ORACLE_XA+SQLNET=MyServerName+HostName=MyHostName+PortNumber=MyPortNumber+Sid=MySID +ACC=P/MyUserId/MyPassword+sestm=100+threads=TRUE+DataSource=MyDataSourceName+DB=MyDataSourceName+K=2+ |
ThreadOfControl | THREAD |