If you are using datalinks and want to access files using a proxy server,
you must specify proxy information in the
db2ext.proxyinformation table.
Table 9. db2ext.proxyinformation view
Attribute | Type | Notes |
---|---|---|
PROXYHOST | VARCHAR(254) | The host name of the proxy server. |
PROXYPORT | VARCHAR(6) | The used port for the proxy server. |
PROXYTYPE | VARCHAR(10) | The type of the proxy server (either PROXY or SOCKS). |
PROXYTIMEOUT | INTEGER | The timeout in seconds. |
You can insert a maximum of one row. If you have a proxy server on port 123, you can insert a row with the following SQL statement:
db2 insert into db2ext.proxyinformation values ('proxy1', '123','PROXY', 10)