Question & Answer
Question
SQL22223N error: "The instance "instance-name" does not exist on host "hostname", received when attempting to generate a DDL for a remote table via the Control Center.
Cause
When the remote node was cataloged the keyword 'remote_instance' was not used in the catalog statement.
Answer
Uncatalog and recatalog the node specifying the keyword 'remote_instance'.
Syntax:
1) db2 uncatalog node <node name>
2) db2 catalog tcpip node <node name> remote <ipaddress of the server> server <port
number that instance is listening on> remote_instance <instance name> ostype
<ostype>
Example:
1) db2 uncatalog node ccmsnode
2) db2 catalog tcpip node ccmsnode remote 9.25.148.94 server 60000 remote_instance
db2inst1 ostype aix
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21214146