Skip to Content
Author's profile photo Masaru Onuma

MobiLink with SAP IQ consolidated database 2/2

The MobiLink server supports SAP Sybase IQ consolidated database.

Now I build simple MobiLink environment with a SAP IQ consolidated database.

In this case, there are 2 machines, one is for IQ environment and another is for MobiLink environment.

Product Version:

     SQL Anywhere  – 17.0 SP0 PL8 Build 2053

     SAP IQ – 16.0 SP11

This Blog is 2 of 2.

Previous :  MobiLink with SAP IQ consolidated database – 1/2

5.Generated files

The summary.txt file is generated as follows.

   C:\mliq\mliq_project\sync_mliq_deploy\summary.txt

In this file, there are description about generated files.

     summary.txt

     ——————————————————–

     The following files have been generated:

         C:\mliq\mliq_project\sync_mliq_deploy\remote_setup.sql      (SQL to setup a remote database)

         C:\mliq\mliq_project\sync_mliq_deploy\cons_setup.sql      (SQL to setup a consolidated database)

        C:\mliq\mliq_project\sync_mliq_deploy\remote_setup.bat      (Command file to execute SQL against a remote database.)

        C:\mliq\mliq_project\sync_mliq_deploy\cons_setup.bat      (Command file to execute SQL against a consolidated database.)

        C:\mliq\mliq_project\sync_mliq_deploy\mlsrv.bat      (Command file to start the MobiLink server.)

        C:\mliq\mliq_project\sync_mliq_deploy\sync.bat      (Command file to start the synchronization client.)

    Consolidated database: mliq_consdb

    MobiLink server command line: Default

    MobiLink server options: -c “UID=dba;DSN=IQ16Test” -v -x TCPIP(host=”localhost”;port=”2439″)

    Client network options: TCPIP(host=localhost;port=2439)

    MobiLink user: u1

    MobiLink password: u1

    Synchronization profile name: sync_mliq_u1

    Remote synchronization options: Subscription=sync_mliq_u1;MobiLinkPwd=u1

    SQL will be executed against the consolidated database to prepare it for synchronization.

    A new remote database will be created and the SQL executed to prepare it for synchronization.

        The new database will be written to: C:\mliq\mliq_project\sync_mliq_deploy\sync_mliq_remote.db

     ——————————————————–

6. Start Remote Database

You can start remote database and start Interactive SQL (dbisql) as follows.

/wp-content/uploads/2016/07/12_ml_start_db_993325.png

After log in to database by Interactive SQL, and select mltest1 table.

At this time, mltest1 table has 0 row.

/wp-content/uploads/2016/07/12_ml_select_mltest1_1st_993326.png

7. Start MobiLink Server

You can start MobiLink Server by mlsrv.bat which is generated in project directory./wp-content/uploads/2016/07/13_ml_start_mlsrv_993327.png

And popped up MobiLink console window.

/wp-content/uploads/2016/07/13_ml_mlsrv_console_993332.png

8. Run sync.bat

If you run sync.bat without argument, you can get usage as follows.

   C:\mliq\mliq_project\sync_mliq_deploy>sync.bat

   Usage:   sync.bat CONNECTION

   CONNECTION   REMOTE DBA connection string for synchronizing the remote database

   (eg “DBF=my_db.db;UID=my_sync_user;PWD=my_sync_pass”)
    See also “GRANT REMOTE DBA statement” in documentation.

Run sync.bat as follows.

/wp-content/uploads/2016/07/14_ml_run_sync_bat_993388.png

And popped up console window.
/wp-content/uploads/2016/07/14_ml_console_window_993392.png

9. Select Remote Database Table

And select mltest1 table on remote database.

At this time, mltest1 table is synchronized.

/wp-content/uploads/2016/07/15_ml_select_remote_db_993413.png


10. Add data on the consolidated database

Move to IQ consolidated database environment.

And add data as follows.

     insert into mltest1(col1,col2) values (11,’KKK’);

     commit;

And select the table.
/wp-content/uploads/2016/07/16_ml_select_consdb_993476.png

11. Run sync.bat

Move to MobiLink environment.

If still there is a SQL Anywhere MobiLink Client whindow,

click Shutdown bottun.

/wp-content/uploads/2016/07/17_ml_2nd_sync_console_993486.png

And run sync.bat again.

/wp-content/uploads/2016/07/14_ml_run_sync_bat_993388.png

And popped up window is
/wp-content/uploads/2016/07/17_2nd_sync_993487.png

Synchronization succeeded.

12. Select on Remote Database

On the remote database, select mltest1 again.


/wp-content/uploads/2016/07/18_ml_select_remote_993493.png


Added data is synchronized.






Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Serkan Birkan
      Serkan Birkan

      Hello,

      Has anyone tried this on a production environment? If so, how is the performance and other specifications like size of the data?

      Thanks,

      Serkan.