[Version 5.0.2 and later]Configuring Cloudscape Version 5.1

Why and when to perform this task

Note: Datasources defined under the DB2 for z/OS Local JDBC Provider (RRS), must not be accessed from within the same JVM as datasources defined under any of the JDBC providers using the DB2 (version 8) Universal JDBC Driver. This means that the datasources must not be used from within the same server, and that similar considerations must be taken for client datasource usage.

In particular, datasources defined under the Cloudscape (5.1) Network Server Using Universal JDBC Driver Provider must not be used from the same server as datasources defined under the DB2 for z/OS Local JDBC Provider (RRS).

The reason for this restriction is that the DB2 Universal JDBC Driver uses the same package and class names (com.ibm.db2.jcc.DB2ConnectionPoolDataSource) as the DB2 for z/OS Local JDBC Provider (RRS). To understand this design, consider that the DB2 Universal JDBC Driver is the DB2 V8-level replacement for the DB2 V7-level JDBC driver used by the DB2 for z/OS Local JDBC Provider (RRS).

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 9:56:50 PM CDT    WebSphere Application Server for z/OS, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.zseries.doc/info/zseries/ae/tdat_cloudscape_setup.html

Library | Support | Terms of Use | Feedback