Skip to Content
author's profile photo Former Member
Former Member

SMP 2.3 How to open SMP database

Hi all.

In some cases it might be extremely useful to be able to open and edit SMP DB directly.

For example, not all settings or features are presented in SCC. And existing user data or connection data in SMP DB may stop your development process.

Anyway, I found this article in scn wiki which is useful:

Checklist for troubleshooting an unresponsive SUP and SMP 2.X servers - SAP Mobility - SCN Wiki

and I tried to access SMP DB and succeded.

Here are the steps:

1) Access your SMP server computer.

2) Open folder C:\SAP\MobilePlatform\Servers\SQLAnywhere12\BIN32

3) Run scjview.exe

4) In opened Sybase Central database explorer window you will see 3 items:

-SQL Anywhere 12

-Mobilink 12

-Ultralite 12

5) Select item you want and double click.

6) Default login/password is dba / sql

6) I opened SQL Anywhere 12. Inside there is your server called [YourServername_primary]. Inside there are databases clusterdb, default, monitordb, domainlogdb.

7) Inside you will find all tables. Search for what info you need. Also you can edit data.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 04, 2014 at 01:46 PM

    Hi Mikhail,

    Thank you very much for the information. Although, some more specific guide adn maybe some more screenshots i think they will be useful to everyone.

    Are you trying from yor Application Server of from the DB?

    Under which specific path are the :defaulsdb, monitordb e.t.c. files?

    Whe you double click the SQL anywhere icon on Sybase Central it gives a settings window to fill. What is the setting you chose to connect to the DB?

    I didnt manage to make the connection myself.

    Thanks

    George Lazaridis

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.