Setting up a Transaction Server to Publish a Database

If a PMOD installation has a JDBC database running, it can make the data available for other PMOD installations. To this end a server program - the Transaction Server (TS) - must be started to run in the background and wait for database access requests.

In PMOD multiple TSs can be started automatically. Therefore memory usage for multiple TS is optimized while providing a better management of the TSs.

Transaction Server Configuration

The transaction server requires several configuration items, which are available on the DATABASE panel. Perform the following steps to define the transaction server which is started automatically with PMOD.

1. Switch the radio button from Use JDBC connection to Use Transaction Server.
   

1. Configure the properties of the transaction server. The Secure box is for enabling secure communication. This mode should be used if the communication is not confined within the institution. Otherwise it will slow down the communication speed unnecessarily. The Compressed box allows enabling compressed image transfer which can result in an acceleration across slow connection lines.
2. An important property is the IP Port for the communication. It must be a unique number not used by any other transaction server or other process. In the example above is 5203.
3. Another important property is the IP address. It must contain the address of the host in which the servers are running, so typically the system on which the configuration is performed. For this system the HOST button is enabled and the host system is "localhost". In alternative, the IP address can be obtained by activating the Set Local Host button.
4. Check the box Start automatically such that the transaction server is started simultaneously with PMOD.

Starting a Transaction Server

The PMOD transaction server is a background process. It can be started in one of the following ways:

1. Automatically : If Start automatically has been configured in the DATABASE configuration page, the transaction server is started as soon as PMOD is started and not after user login.
2. By running a command script: A script for starting a Transaction Server is specific for the operating system platform. A start script RunDbSvr with the default configuration is created at installation time in the Start directory. Transaction server scripts with a different configuration can easily be generated on the DATABASE configuration pane as described below. As an example, the RunDcmSvr script for Windows and Derby looks as follows:
   C:
cd "C:\Pmod3.4"
.\java\jre\bin\java -version
.\java\jre\bin\java -Xmx1200M -jar pmtsvr.jar 5203 JAVA_DB org.apache.derby.jdbc.EmbeddedDriver jdbc:derby:./DATABASES/Pmod ./DATABASES/Pmod/data -noLS
   
   A script for mySQL has a different driver specification
   C:
cd "C:\Pmod3.4"
.\java\jre\bin\java -version
.\java\jre\bin\java -Xmx1200M -jar pmtsvr.jar 5203 MY_SQL org.gjt.mm.mysql.Driver jdbc:mysql://localhost/Pmod ./DATABASES/Pmod/data -noLS
   
   This mySQL script requires that the root user has an empty password. If this is not the case, the user and password must be specified as additional command line arguments:
   .\java\jre\bin\java -Xmx1200M -jar pmtsvr.jar 5203 MY_SQL org.gjt.mm.mysql.Driver jdbc:mysql://localhost/Pmod ./DATABASES/Pmod/data -noLS root password

Transaction Server Scripts

The Save Starting Script button is a facility for generating scripts according to the configured transaction server properties. It becomes active when the Start automatically radio button is disabled and Standalone option is enabled. The script is dependent on the operating system. The example below is the result for a Windows system.

The -NOLS text indicates that the TS is not used as license server.

The License Server box can be checked if the server is at the same time managing a network license. In this case the -NOLS flag will disappear. The Yes button saves the operating-system specific script illustrated in the Commands area to the Pmod3.4/Start directory using the specified Name.

The Verbose commands box can be checked to enable verbose output. In this case a -d argument will appear. It is only recommended for debugging purposes, because it will slow communication down.

The Redirect output checkbox can be enabled to redirecte the output to a file. in this case a -o argument will appear.

The database information required in the next section can most easily be completed using the Get from Data Source button. See Creation and Configuration of Databases for details regarding Data Base Connection, Database Path, and File Storage Area Path

Transaction Server Status Information

All automatically started TSs are available for manmagement. The TS management and status information are available activating the button from PMOD ToolBox:

The current status is displayed in the State column. The status of a TS can be easily modified: initially the TS have to be selected in the Server list and then, depending on the status, the Start selected server(s) or Stop selected server(s) button need to be activated.

When the color of the button changes to blue, a transaction server request is being served. The color changes back after all communications have completed.

Pmod Status

The PMOD status is extended to provide more information about PMOD environment. The follwoing status information are available:

1. reports problems with the TSs configured and enabled in datasources.
2. informs if new Pmod build or version is available for download from www.pmod.com. Note that this functionality might not be availble in tightly secured corporate networks.
3. displays memory availability.

In case of problems with the TS status the Pmod status button in the toolbox turn into red bullet.

The status is refreshed in the following situations:

1. on Pmod start.
2. when TS management panel is closed.
3. when Pmod status dialog is closed.

Recommendations

Methods 1 allows publishing a single database. Method 2 is not limited in this sense. A script can be run for each database in parallel. In this case, the transaction servers must be started using unique port numbers (eg. 5200, 5201, 5202, ...).

Note that transaction servers can be started and operated without consuming a PMOD license. This allows moving them to a server machine that is continuously operating and has fast disks. On this server machine perform a standard PMOD installation, plug the USB license protection key in, and use the Config facility for the database configuration and transaction server script generation. Then start each of the scripts in a separate command window. In the case of a standalone license, the USB key can now be moved to the computer, where the actual data processing is performed. In the case of a network license the USB key should remain, as it is used for license serving.

Depending on the network and server performance the speed of the load/save operations via a transaction server may be slower than with local loading/saving. The benefit, however, is the global availability and centralized maintenance of the data.

CAUTION: Note that the proper interaction between the transaction server and clients requires that all systems run the same PMOD version.