Return
-
Title
SQL1460N The environment variable "SOCKS_NS" required for SOCKS server name resolution is not defined or not valid -
Description
User tried to connect to DB2 ZOS and got error: SQL1460NThe environment variable"SOCKS_NS" required forSOCKS server name resolution isnot defined or not valid.
-
Resolution
Ensure that you use the following for TSOconnections:
lDB2 user ID for the DB2 subsystem
lPort number that DB2 listens on, for remoteconnections, via the DB2 DDF address
space
lIP address for the z/OS subsystem
PLEASE NOTE: If you are entirely sure of the info entered, then verify the Security Type in the Catalog Entry, if it's using "SOCKS" then try changing that to "NONE".