Database Configuration Guide

Contents

About This Book

1   Configuring Cloudscape Databases

Setting up SilverMaster databases
Step 1: Install the Cloudscape software
Step 2: Create a Cloudscape SilverMaster database
Setting up deployment databases
Step 1: Create a Cloudscape deployment database
Step 2: Add the Cloudscape database or connection pool to the application server
Locating Cloudscape databases
Cloudscape users, schema, and the application server
Managing access to Cloudscape databases

2   Configuring DB2 Databases

Connecting to DB2 databases
Step 1: gather information about your DB2 environment
Step 2: prepare DB2 for connection from Universal Database Client
Step 3: install the database client
Step 4: configure the DB2 client connection
Step 5: modify the DB2CLI.INI file
Step 6: set environment variables
Step 7: use the database with the application server
Troubleshooting

3   Configuring Informix Databases

Connecting to Informix databases
Step 1: install the JDBC driver
Step 2: create the Informix database and dbspaces
Step 3: create the Informix user account
Step 4: add the driver path to AGCLASSPATH
Step 5: use the database with the application server
Troubleshooting

4   Configuring Microsoft SQL Server Databases

Basic setup for Microsoft SQL Server databases
Create the database and configure SQL Server
Create the database login
Setting up JDBC access
Install the JDBC driver
Add the driver path to AGCLASSPATH
Setting up ODBC access
Install the Microsoft SQL Server client
Create the ODBC System DSN entry
Using the database with the application server

5   Configuring MySQL Databases

About MySQL support
Preparing to access MySQL
When MySQL is installed for you
When you install MySQL yourself
Creating MySQL databases
Setting up a SilverMaster database
When SilverMaster is set up for you
When you set up SilverMaster yourself
Setting up a deployment database

6   Configuring Oracle Databases

Basic setup for Oracle databases
Create an Oracle tablespace for use with SilverMaster
Create an Oracle user for the application server
Setting up an Oracle driver
Using the Oracle Thin JDBC Driver
Using the Oracle OCI Driver
Using the Novell exteNd Oracle driver
Using the database with the application server
Creating a deployment database on Oracle
Using synonyms
Specifying the driver
Types of synonyms
Enabling and disabling synonym support
Troubleshooting

7   Configuring Sybase Adaptive Server Anywhere Databases

Preparing to use Sybase ASA
Installing Sybase ASA
Preparing to use jConnect
Setting up SilverMaster and deployment databases
Step 1: Create a database
Step 2: Create user accounts
Step 3: Run Sybase ASA as a service
Step 4: Make the database available to the application server

8   Configuring Sybase Adaptive Server Enterprise Databases

Setting up Sybase Adaptive Server Enterprise databases
Step 1: install Sybase jConnect
Step 2: configure the Sybase server
Step 3: create the SilverMaster database in Sybase
Step 4: create the Sybase login for the application server
Step 5: use the database with the application server
Troubleshooting
Adaptive Server Enterprise troubleshooting
jConnect troubleshooting


Copyright © 2004 Novell, Inc. All rights reserved. Copyright © 1997, 1998, 1999, 2000, 2001, 2002, 2003 SilverStream Software, LLC. All rights reserved.  more ...