ibm-cloud-docs / Db2whc

Db2whc
0 stars 7 forks source link

Step 1 of "On a Db2 Warehouse on Cloud machine being used as a federation source" missing SSL parameter #26

Open jakedepstein13 opened 1 year ago

jakedepstein13 commented 1 year ago

Step 1 of the On a Db2 Warehouse on Cloud machine being used as a federation source instructions is missing the SSL parameter . It currently reads:

create server <server_name> type dashdb version 11 wrapper drda authorization "<admin_user_on_target>" password "<admin_password_on_target>" options (host '<target_host_name>', port '50000', dbname 'bludb')

For example:
create server db2server type dashdb version 11 wrapper drda authorization "admin2" password "YYYY" options (host 'targetdotcom', port '50000', dbname 'bludb')

and should read:

create server <server_name> type dashdb version 11 wrapper drda authorization "<admin_user_on_target>" password "<admin_password_on_target>" options (host '<target_host_name>', port '50001', dbname 'bludb', security 'SSL')

For example:
create server db2server type dashdb version 11 wrapper drda authorization "admin2" password "YYYY" options (host 'targetdotcom', port '50001', dbname 'bludb', security 'SSL')

Please adjust the documentation accordingly as the command does not work without this parameter

jakedepstein13 commented 1 year ago

Relevant documentation link: https://cloud.ibm.com/docs/Db2whc?topic=Db2whc-data_virt_fed#fed_src