WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Configuring Cloudscape Version 5.1.60x

Version 5.1.6 (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. This article provides detailed instructions for configuring both Cloudscape Network Server Version 5.1.60x and Derby Network Server.

Why and when to perform this task

The following two separate frameworks support use of Cloudscape or Derby 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/cloudscape/bin/networkserver directory. (Substitute derby for the database name in this path if appropriate.) On UNIX platforms, the file is startNetworkServer.sh.

  2. Update the db2j.properties file, which is located in the WAS_HOME/cloudscape directory, if necessary. (Substitute derby for the database name in this path if appropriate.)

    Network Server 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 or Derby Network Server using Universal JDBC driver Provider to connect 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. (Substitute derby for the database name in this path if appropriate.) On UNIX platforms, the file is stopNetworkServer.sh.

  5. For Cloudscape Network Server: Review additional tools available in the Network Server framework. Find these tools in the WAS_HOME/cloudscape/bin/networkserver directory.

    (Most of these tools or their equivalents are packaged with Derby. See http://incubator.apache.org/derby/index.html#Database+Utilities for more information.)

    The tools for Cloudscape Network Server are:
    • sysinfo
    • cview
    • ij
    • dropSYSIBM Use this tool to drop the SYSIBM schema and its contents.
  6. Create a SYSIBM schema (for Cloudscape Network Server).

    If you do not create the SYSIBM schema for your Cloudscape Network Server database, 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: 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.




Sub-topics
Cloudscape Version 5.1.60x post installation instructions

Related concepts
JDBC providers
Data sources
Connection pooling

Related tasks
Verifying a connection

Related reference
Vendor-specific data sources minimum required settings

Task topic    

Terms of Use | Feedback

Last updated: Mar 17, 2005 4:28:29 AM CST
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tdat_cloudscape_setup.html

© Copyright IBM Corporation 2003, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)