I moved my DB2 installation to a new server from a full back-up. After performing all the necessary steps:
1. Recreate the necessary users: db2inst1, db2fenc1, db2das1
2. Give ownership to their home directories
ISSUE:
I tried to start the instance. I logged in to the db2inst1 user and started the database.
This was the result:
[db2inst1@localhost ~]$ db2start SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.
INVESTIGATION:
Looking at the reported issue with db2diag, the last entry looked like:
2017-11-21-11.59.09.811613+120 I313787813E494 LEVEL: Error PID : 14537 TID : 140148394157824 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 HOSTNAME: localhost.localdomain EDUID : 1 EDUNAME: db2sysc FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, probe:5 MESSAGE : DIA3201E The service name "db2c_db2inst1" specified in the database manager configuration file cannot be found in the TCP/IP services file.
FIX:
The fix is to add an entry in /etc/services for the db2 TCP service
db2c_db2inst1 50000/tcp # DB2 connection service
Then just db2stop and try again:
[db2inst1@localhost ~]$ db2start SQL1063N DB2START processing was successful.
Contribute to this site maintenance !
This is a self hosted site, on own hardware and Internet connection. The old, down to earth way 🙂. If you think that you found something useful here please contribute. Choose the form below (default 1 EUR) or donate using Bitcoin (default 0.0001 BTC) using the QR code. Thank you !
€1.00