Configuring Cloudscape V5.1.60.x

V5.1.60.x (plus any subsequent fix packs for this version) is the minimum level of Cloudscape that is required for WebSphere Application Server V6.0 - V6.0.2.

About this task

Cloudscape supports the following two frameworks:

Embedded: This framework is the same as the one for Cloudscape Version 5.0. To use this framework, define a Cloudscape JDBC provider. See the Cloudscape section in the minimum required settings article for more information.

You must use the embedded framework if you are running XA. Network Server does not support XA.

Network Server: This framework was a new feature in Cloudscape Version 5.1, and removes these limitations that existed in earlier versions of Cloudscape:

inability to access a remote Cloudscape instance
only one JVM can boot up the same database instance

The following steps describe how to configure and run the Network Server framework.

Procedure

Start the Network Server on the machine that hosts the database instance.

To start the Network Server, run the startNetworkServer.bat file, which is located in the WAS_HOME/cloudscape/bin/networkserver directory. On UNIX platforms, the file is startNetworkServer.sh.

If necessary, update the db2j.properties file, which is located in the WAS_HOME/cloudscape directory. By default Network Server only listens on the local host. If your application environment requires remote hosts to access Network Server, consider updating the db2j.properties file according to these recommendations:

Uncomment the db2j.drda.host property. This alteration enables connections from other hosts, and effectively sets the Cloudscape Network Server host address to 0.0.0.0. This value is interpreted by Network Server as meaning all IP address that belong to the host machine.
In the case that your Cloudscape host has multiple IP addresses but you want only one of those addresses to accept connections, replace 0.0.0.0 with that IP address.
To avoid a security exposure: While running a Network Server instance that accepts connections from remote hosts, run the Network Server under a security manager, such as a Java security manager. For information on setting up such a policy, see the article "Cloudscape Network Server with WebSphere Application Server" at http://www-128.ibm.com/developerworks/websphere/library/techarticles/0406_gerboth/0406_gerboth.html. The last step that is listed in the "Configuring Network Server" section provides a code example.
Finally, remember that Network Server administrative commands, such as sysinfo and stopNetworkServer, can only be executed on the host where the server was started, regardless of the db2j.drda.host property setting.

By editing other entries in the db2j.properties file, you can enable other important capabilities, such as trace. We can also change the port number on which Network Server listens; the default port number is 1527. For more information on the db2j.properties file, see the Cloudscape 5.1 documentation at www.ibm.com/software/data/cloudscape/pubs/collateral.html. A good starting point is the Tuning Guide, chapter one: "Working with Cloudscape Properties."

Leave one property unchanged, however: The db2j.drda.loadSYSIBM property in the db2j.properties file controls whether a SYSIBM schema is created on the first connection to the database. Leave this property at the default value, which is true.

If you change this value and disable the creation of a SYSIBM schema for your Cloudscape Network Server database, we cannot see the data types when you create tables using the cview graphical user interface.

Stop the Network Server by invoking the stopNetworkServer.bat file.

We can find this file in the WAS_HOME/cloudscape/bin/networkserver directory. On UNIX platforms, the file is stopNetworkServer.sh.

Define a Cloudscape Network Server JDBC provider using the Universal JDBC Driver to connect with WebSphere Application Server.

Restart Network Server.

What to do next

WAS_HOME/cloudscape/bin/networkserver

sysinfo

cview

ij

dropSYSIBM Use this tool to drop the SYSIBM schema and its contents.

Note: When you run ij, surround the dbname by double quotation marks (" ") if it includes the full path name; for example: ij> connect '"c:temp;create=true"'

This is ' " " ' without spaces.