Refreshing connections for HCL Compass Client on Linux and the UNIX system

Use cqreg refresh command to refresh a connection for Linux™ and UNIX™ system clients whenever connection information changes.

Using cqreg refresh is appropriate when user databases are created or modified and when schema repositories and user databases are moved.

Use cqreg refresh for each Linux and UNIX system installation area whose database connection has changed. You do not need to run it on each HCL Compass client.

If cqreg refresh does not re-establish the connection, use the cqreg drop_dbset and cqreg add_dbset commands to drop and re-create the database connection information.

The following example shows the output from using cqreg show -all. It displays information on all the connections for a HCL Compass Client:
axon 20: cqreg show -all
::: [cqreg_main show -all]
--- Default DB path is /opt/company_xxx/compass/CQDB_xxxx/cqdb_registry/
--- Default version is 2003.06.13
axon 11: cqreg show -all 
Database Set Name: WH0axon
  Master Database: MASTR
    Description:    the master
    Vendor:         ORACLE
    Server:         cqxxx1
    ConnectOptions: HOST=cqxxx7;SID=CQ1;LOB_TYPE=CLOB
    Database:       WH0axonORA
  User Database: SAMPL
    Description:    Sample Database
    Vendor:         SQL_SERVER
    Server:         cqxxx2
    ConnectOptions: 
    Database:       WH0axonSS
Database Set Name: UCM
  Master Database: MASTR
    Description:    the master
    Vendor:         SQL_SERVER
    Server:         cqxxx3
    ConnectOptions: 
    Database:       UCMCQ_IHD_MSTR
  User Database: HIRES
    Description:    HR database
    Vendor:         ORACLE
    Server:         cqxxx4
    ConnectOptions: HOST=cqxxx6;SID=SO322;LOB_TYPE=CLOB
    Database:       ABC_HR
User Database: UCMCQ
    Description:    Production database
    Vendor:         SQL_SERVER
    Server:         cqxxx5
    ConnectOptions: 
    Database:       UCMCQ_IHD_USERDB
::: [cqreg has finished]

The following example shows the output from cqreg refresh -dbset.
axon 21: cqreg refresh -dbset UCM
::: [cqreg_main refresh -dbset UCM]
--- Default DB path is /opt/company_xxx/compass/CQDB_xxxx/cqdb_registry/
--- Default version is 2003.06.13
--- Refresh database set UCM
--- Db registry UCMCQ needs to be updated
+++ Db registry UCMCQ was updated successfully
--- Db registry HR needs to be updated
+++ Db registry HR was updated successfully
--- Db registry MASTR needs to be updated
+++ Db registry MASTR was updated successfully
+++ Database set UCM was refreshed successfully
::: [cqreg has finished]

The following example shows the output from cqreg refresh -all. It updates all connections for a client.
axon 22: cqreg refresh -all
::: [cqreg_main refresh -all]--- Default DB path is /opt/company_xxx/compass/CQDB_xxxx/cqdb_registry/
--- Default version is 2003.06.13
--- Refresh database set WH0axonSS
--- Db registry SAMPL needs to be updated
+++ Db registry SAMPL was updated successfully
--- Db registry MASTR needs to be updated
+++ Db registry MASTR was updated successfully
+++ Database set WH0axonSS was refreshed successfully
--- Refresh database set UCM
--- Db registry TEST needs to be updated
+++ Db registry TEST was updated successfully
--- Db registry UCMCQ needs to be updated
+++ Db registry UCMCQ was updated successfully
--- Db registry HR needs to be updated
+++ Db registry HR was updated successfully
--- Db registry MASTR needs to be updated
+++ Db registry MASTR was updated successfully
+++ Database set UCM was refreshed successfully
::: [cqreg has finished]