[Version 5.0.2 and later]Configuring Cloudscape Version 5.1

Why and when to perform this task

Cloudscape Version 5.1 provides the following two separate frameworks for running Cloudscape with WebSphere Application Server:

Steps for this task

  1. 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/cloudscape51/bin/networkserver directory. On UNIX platforms, the file is startNetwokServer.sh.

  2. Update the db2j.properties file, which is located in the WAS_HOME/cloudscape directory, if necessary.

    Cloudscape should work without any modifications to this file.

    Use the entries in the db2j.properties file to turn on trace, change the port number on which Network Server listens, and enable other functions of the Network Server framework. The default port number on which the Network Server listens is port 1527.

    For more information on this file, see the Cloudscape documentation at www.ibm.com/software/data/cloudscape/pubs/collateral.html .

  3. Define a Cloudscape Network Server using Universal JDBC driver to connect Cloudscape Version 5.1 with WebSphere Application Server using the Network Server framework.
  4. Stop the Network Server by invoking the stopNetworkServer.bat file.

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

  5. Review additional tools available in the Network Server framework.

    Find these tools in the WAS_HOME/cloudscape/bin/networkserver directory. These tools are:

    • sysinfo
    • cview
    • ij
    • dropSYSIBM Use this tool to drop the SYSIBM schema and its contents.

  6. Create a SYSIBM schema.

    If you do not create the SYSIBM schema, you cannot see the datatypes when you create tables using the cview graphical user interface. The db2j.drda.loadSYSIBM property in the db2j.properties file controls whether the schema is created on the first connection to the database. The db2j.drda.loadSYSIBM property default value is true.

    Note: You cannot run a new version and an older version of Cloudscape in the same WebSphere Application Server environment. For datasources created under the old version of Cloudscape, you must change the classpath in these datasources to point to the new version of Cloudscape; otherwise, the jar files from both versions of Cloudscape are loaded in the same environment. This might result in undesirable consequences or exception situations.

    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.


Related concepts
JDBC providers
Data sources
Connection pooling
Related tasks
Verifying a connection
Related reference
Vendor-specific data sources minimum required settings



Searchable topic ID:   cloudscape_setup
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/ae/tdat_cloudscape_setup.html

Library | Support | Terms of Use | Feedback