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.

Symptoms

If 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][2043][11550][4.22.36]
Exception java.net.ConnectException: Error opening socket to server <server_name>.com/9.30.110.32 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.

Causes

The 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/7.1.0.0/bigsql-cli/config/ucconfig.ini file is incorrect.

Resolving the problem

Specify the correct Db2 Big SQL port number in the ucconfig.ini file.
  1. In Cloudera Manager, stop the Db2 Big SQL console service.
  2. Open the ucconfig.ini file in a text editor and update the value for the uc.bigsql.port entry.
  3. Rerun the /usr/ibmpacks/IBM-Big_SQL/7.1.0.0/bigsql-cli/uc-install utility.