msc mobile emerging technologies blog

How to shrink the growing SAP Mobile Platform 2.3 Database

Posted by Klaus Rollinger on Mar 13, 2016, 1:11:04 PM

The SQL Anywhere middleware database of SMP 2.3 tends to gow over time. This is using up a lot of discspace and can cause issues. This blog shows step by step how to shrink the database size.


To reduce the size of the SAP Mobile Platform database you have to follow these steps (explained for the Windows platform here):

  1. Stop the SAP Mobile Platform. This can be done either via the shortcut on the desktop or within the services tool of Windows.
  2. Go to the installation directory of SMP and then UnwiredPlatform -> Servers -> UnwiredServer -> data. 
  3. Here you should find the database and transaction log files. This includes your applications database, as well as the following:
    1. Clusterdb.db
    2. clusterdb.log
    3. Default.db
    4. default.log
    5. Domainlogdb.db
    6. domainlogdb.log
  4. Backup these files!
  5. Open Sybase Central. It can be found at the SQLAnywhere16 directory and is called scjview.exe
  6. Open a connection to each of the databases by chosing "Connect to SQL Anywhere 16 DB"
    Open a connection to the SMP database
  7. When the connection is open, go to tools -> Unload DB
    Unload SMP database

    Reduze the file size of the SMP database
  8. Save the new database file:
    Save the new SMP database file
  9. In the next steps, keep the default values:
    How to unload a SQL Anywhere database

    Reduze the file size of a SQL Anywhere 16 database

    Shrink SAP Mobile Platform database

    How to unload the SMP database
  10. Now copy the new database files and transaction logs back to the SMP folder from step 2.
  11. Start the SMP service


Now the database of your SMP 2.3 installation should be a lot smaller than before. Depending on your scenario we recommend doing this more or less frequently. 



 

Topics: SQL Anywhere, SMP, SAP