SAP Knowledge Base Article - Preview

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

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


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


ls sqlanywhere*



SAP Data Services all versions


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.