Setting up the Jopaz for Db2 Configuration File
To configure Jopaz for Db2, you need to specify the following parameters in the jpz.properties file present in /jpz/jpz-compiler/conf directory. These parameters control the properties of the client related configurations of Jopaz for Db2.

Parameter Name | Mandatory | Description
java.home | Yes | Specifies the Java JDK installation directory.
db2.home | Yes | Specifies the Db2 installation directory, which contains licenses, JDBC, and SQLJ drivers.
jpz.maxClients | Yes | Specifies the maximum number of clients that can connect simultaneously to server executing Db2 requests.
jpz.initDb2Connection | Yes | Specifies the number of initial connections to Db2.
jpz.bufferLentgh | Yes | Specifies the length of the client buffer in MB. Possible values are integers from 1 to 5000.
jpz.homePath | Yes | Specifies the path or paths of static profiles. During the static preparation,serialized profiles are generated in the directory mentioned in this parameter. The profiles in the static path are used during the runtime to execute the SQL statements statically.