IBM Support

SQL22223N received in Control Center when performing administrative action

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

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DBAdmin - Control Center","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21214146