Update database directives to point to DB2Open your agent.xml file in a text editing application. Then, locate the <task> directive(s) within your <subscribe> directive, and update the following database-related directives: | Directive | Value to enter |
|---|
| <database_type> | db2 | | <database_server> | URL/IP address for your DB2 database. If your database is installed on your local machine, set this value to localhost. | | <database_port> | Port number for your DB2 database | | <database_user> | Username used to access your DB2 database | | <database_password> | Password used to access your DB2 database | | <database_parms> | characterEncoding=UTF-8 |
Your agent.xml file should look similar to the example shown below: | Code Block |
|---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share>
</share>
<subscribe>
<task>
<task_name>test_db2_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" user="exampleuser">amqps://example.perspectium.net</message_connection>
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" user="example.user">https://myinstance.service-now.com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>db2</database_type>
<database_server>localhost</database_server>
<database_port>50000</database_port>
<database_user>exampleuser</database_user>
<database_password>examplepassword</database_password>
<database_params>characterEncodingparms>characterEncoding=UTF-8</database_params>parms>
<database>SAMPLE</database>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>30</polling_interval>
</agent>
</config>
|
| 
First, you will need to install a DataSync Agent.