jdbc Connection string for db2e?

[Former Member]

Hi mobile freaks,

has anyone of you tried to connect to MI database, namely db2e variant?

I've tried to connect to db2e on my MI7.0 SP14 client but w.o.success

The reason for that is I would like to view the data with any third party jdbc db viewer.

so... I'm using db2ejdbc.jar driver from MI_HOME/lib folder

and I tried following URLs:

jdbc:db2://127.0.0.1:50000/<DataBaseName>

jdbc:db2e:C:\SAP Mobile Infrastructure_KMB2X\data

jdbc:db2e:db2e

I don't know dbUser and dbPass here. I found some relevant properties in com\sap\ip\me\defaults.properties file, is the db user 'MIFramework' used by MI? Where does db password come from?

Have you had any experiences with this topic yet?

cheers,

Maciej

[chintan_virani · Accepted solution]

Peter,

There should DB2E viewer available in the SDK listed [here|https://www.sdn.sap.com/irj/sdn/downloaditem?rid=/library/uuid/1a29541d-0a01-0010-81bf-fdab6713a9d4]. But when you run this tool make sure that your MI client is closed.

Additionally if you are just trying to see MAM data just type this URL localhost:4444/<your-mam-appl-name>/start_full.jsp, then select the SyncBO and check the data.

Chintan

[Former Member]

Hi,

I am not sure if what you are trying can acutally achieve your objective. If I understood you requirement correctly then you just need to view your data that resides in the DB2e database. For this there is already a standard tool attached to SAP note 1049921 (DB2e CLP tool for analysing DB2e database tables).

Hope this helps.

Best Regards

Sivakumar