问题描述:
db2 catalog tcpip node报错SQL1038C An I/O error occurred while accessing the node directory.
db2inst1@node01:~> db2 catalog tcpip node qingsong REMOTE 192.168.75.134 server 60000
SQL1038C An I/O error occurred while accessing the node directory.
SQLSTATE=58031
并且db2 list node directory没有输出:
db2inst1@node01:~> db2 list node directory
SQL1027N The node directory cannot be found.
原因:
node directory的信息存放在~/sqllib/sqlnodir目录下,有两个文件 sqlnobak和sqlnodir,如果这两个文件不存在,或者已经损坏(未损坏情况下可以直接查看内容),那么就会出现上面的问题。