3253179 - How to connect to CMS Repository in SQLANYWHERE Database (Linux/Unix)

1. Check if which database is running

> ps -ef | grep dbsrv

dsuser   10654     1  2 Aug19 ?        19:47:51 dbsrv17 -gk all -n BI4_1604471143 -x tcpip(port=2638;DoBroadcast=NO;BroadcastListener=NO) /ESD/BODS/IPS/sqlanywhere/database/BI4_CMS.db /ESD/BODS/IPS/sqlanywhere/database/BI4_Audit.db /ESD/BODS/IPS/sqlanywhere/database/DS_REPO1.db /ESD/BODS/IPS/sqlanywhere/database/DS_REPO.db -hn 5

BI4_CMS, BI4_Audit, DS_REPO1, DS_REPO databases are running.

2. Lists all data source along with their associated connection string:

> dbdsn -l -b

SQL Anywhere Data Source Utility Version 17.0.9.4935

SQL Anywhere User Data Sources:

DS_REPO1_DSN:   UID=dba;DBN=DS_REPO1;ServerName=BI4_1604471143;Host=localhost:2638

DS_REPO_DSN:    UID=dba;DBN=DS_REPO;ServerName=BI4_1604471143;Host=localhost:2638

BI4_CMS_DSN_1604471143: UID=dba;DBN=BI4_CMS;ServerName=BI4_1604471143;Host=localhost:2638

BI4_Audit_DSN_1604471143:       UID=dba;DBN=BI4_Audit;ServerName=BI4_1604471143;Host=localhost:2638

3. odbc.ini has above DSN.

> echo $ODBCINI

/ESD/BODS/IPS/sap_bobj/enterprise_xi40/odbc.ini

4. Connect to the CMS database BI4_CMS and run "select * from CMS_VersionInfo"

>  dbisql -nogui -c "UID=dba;DBN=BI4_CMS;ServerName=BI4_1604471143;Host=localhost:2638"

Password for dba:

(dba)> select * from CMS_VersionInfo

SubsystemNumber BuildVersion

----------------------------

              7 14.0.0

*) script to start/stop sqlanywhere

cd  $BOBJEDIR

ls sqlanywhere*

sqlanywhere_shutdown.sh  sqlanywhere_startup.sh

sqlanywhere  dbisql  "connect to CMS database" , KBA , EIM-DS-DEP , Deployment, Installation, Upgrade , EIM-DS , Data Services , How To