db2ext.proxyinformation table

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 10. 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)