Can I use TPPT / two-phase commit Tool from home ?

For both of tool, YES,  you can run the experiment from home. But you will need some modifications or some limitation as describe below.

 

         TPPT tool

            SYBASE

All the existing Sybase experiments, you can run from home by checking "Connect from home" box. Notice that the statistics might not be accurate under this situation, because we should also consider the overhead through the proxy server, so it is recommended that you should run the final report under the  CS network.

 DB2

For DB2 experiments you can also run from home, however, it involved more processes.

  1. You have to obtain executable jar version of tool. (Web-Start version can not be modified)
  2. Unzip the server.xml file from the jar.
  3. Follow the instructions in the Translab website set up tunneling for DB2. (check Connecting from outside the department)
  4. If you tunnel the DB2 connection to the local port: 6789, then you have to change the JDBCURL elements to below:

    <JDBCURL type="Multi">jdbc:db2://127.0.0.1:6789/</JDBCURL>

  5. Save the change and add updated server.xml file to the jar file.
  6. You are done.

         Two-Phase Commit Tool

For two-phase commit experiment, you need to modify the server.xml as describe above for DB2.

Also in your Application Program, when you set up the JDBC parameter to the DBSetting object, you have to change accordingly.

           

Back to Help Contents