Problems with connecting to the Db2 Big SQL console or with viewing charts
In Cloudera Manager, you are unable to connect to the Db2® Big SQL console, or there are problems with viewing charts.
SymptomsIf you can't connect to the Db2 Big SQL console, the following error appears in the /var/log/uc/logs/repoUtil.0 log file.
repoUtil (1) <timestamp> ERROR error happen with detail: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][4.22.36] Exception java.net.ConnectException: Error opening socket to server <server_name>.com/220.127.116.11 on port 32,052 with message: Connection refused (Connection refused). ERRORCODE=-4499, SQLSTATE=08001
If you can connect to the console, but you can't view any charts, an error appears in the /var/log/uc/logs/monitor.0 log file.
CausesThe initialization of the Db2 Big SQL console repository failed because the Db2 Big SQL port number that is specified in the /usr/ibmpacks/IBM-Big_SQL/18.104.22.168/bigsql-cli/config/ucconfig.ini file is incorrect.
Resolving the problemSpecify the correct Db2 Big SQL port number in the ucconfig.ini file.
- In Cloudera Manager, stop the Db2 Big SQL console service.
- Open the ucconfig.ini file in a text editor and update the value for the
- Rerun the /usr/ibmpacks/IBM-Big_SQL/22.214.171.124/bigsql-cli/uc-install utility.