Managing WebLogic Platform Database Resources

Configuring Databases

This section presents guidelines and caveats about the following:

Configuring DB2
Configuring MS SQL Server
Configuring Sybase
For information on Configuring WebLogic Platform with Oracle RAC in 8.1 SP5, go to: Configuring WebLogic Platform to Use Oracle9i or 10g RAC.

Note: Descriptions of how to configure a WebLogic Platform 8.1 SP4 domain with Oracle 9i RAC, and WebLogic Server 8.1 SP4 with Oracle9i and 10g RAC are provided in Important Usage Notes for Previous Releases of WebLogic Platform 8.1. This document can be found at:
http://download.oracle.com/docs/cd/E13196_01/platform/docs81/sp_notes/sp_notes.html.

Configuring DB2

If your configuration includes DB2:

Sample scripts for creating DB2 buffer pools and tablespaces are located in the following directory: WL_HOME/portal/db/db2/8/admin.
Before you start creating database objects for DB2, make sure an 8K-buffer pool and 8K-tablespaces are available to the DB2 database user. For example, to create tablespaces in a DB2 database and grant them to a user, you can use the following SQL statements:

CONNECT to <database_name> user <DB2admin> using <DB2admin_password>
;
CREATE BUFFERPOOL BP8K
    ALL NODES
    SIZE 500
    PAGESIZE 8K
    NOT EXTENDED STORAGE
;
CREATE REGULAR TABLESPACE WEBLOGIC_DATA_4K
    PAGESIZE 4K
    MANAGED BY SYSTEM
    USING('<data_container>')
    BUFFERPOOL IBMDEFAULTBP
;
CREATE REGULAR TABLESPACE WEBLOGIC_DATA_8K
    PAGESIZE 8K
    MANAGED BY SYSTEM
    USING('<data_container>')
    BUFFERPOOL BP8K
;
CREATE TEMPORARY TABLESPACE TEMPSPACE_8K
    IN NODEGROUP IBMTEMPGROUP
    PAGESIZE 8K
    MANAGED BY SYSTEM
    USING('<data_container>')
    BUFFERPOOL BP8K
;
GRANT USE OF TABLESPACE WEBLOGIC_DATA_4K TO USER <user_name>
;
GRANT USE OF TABLESPACE WEBLOGIC_DATA_8K TO USER <user_name>
;

Note that the DB2 database needs to be stopped and restarted after the buffer pool is created. This procedure enables the tablespaces to use the newly created buffer pool.

To make sure that Portal applications can be run successfully on UDB 8.1 in WebLogic Portal domains, configure your DB2 database, with the following parameters as guidelines for minimums:

Dynamic Sections: 20,000
pplheapsz: 24,000
ckcachesz: 2500

If the values shown here are not set as the minimum values, heavy Portal activity may exceed database capacity.

For WebLogic Platform 8.1 SP4, BEA provides a patch for the IBM DB2 database. BEA recommends that you apply this patch to your system if you are using DB2 with WebLogic Platform 8.1 SP4. The patch is available at the following URL:

http://dev2dev.bea.com/products/wlplatform81/patch/wlplat81sp4_db2_patch.jsp

Additional recommendations about using DB2 with WebLogic Platform are available in the README file provided with the patch.

Configuring MS SQL Server

If your configuration includes MS SQL Server:

To use JDBC distributed transactions through JTA, your system administrator should install Microsoft SQL Server JDBC XA procedures using the procedure described at the following URL:

http://download.oracle.com/docs/cd/E13222_01/wls/docs81/jdbc_drivers/mssqlserver.html#install_jta

Check to see whether you have MS SQL Server version 8.00.818. To check the version number, enter the following commands:

OSQL -Usa -P -S 1>select @@version 2>go
If MS SQL Server is already at version 8.00.818, proceed to step 3. If SQL Server version is at 8.00.810 or below, obtain the hot fix from the following link. This hot fix upgrades MS SQL Server to 8.00.818. http://www.microsoft.com/downloads/results.aspx?productID=&freetext=ms03-031&DisplayLang=en

Apply one of the patches identified in this section to fix a problem in Windows that will enable MS SQL Server to run properly. These patches are available from Microsoft TechNet and published with the Microsoft Security Bulletin MS04-012 at the following URL:

http://www.microsoft.com/technet/security/bulletin/MS04-012.mspx

To install this patch on Windows 2000 systems with Service Pack 2, 3, or 4, complete the following steps:

Download Microsoft Security Bulletin MS04-012 from the following URL:

http://www.microsoft.com/downloads/details.aspx?FamilyId=FBD38C36-D1D3-47A2-A5D5-6C8F27FDCC40

Click Download under Security Update for Windows 2000 (KB828741) to download the file Windows2000-KB828741-x86-ENU.EXE.

Shut down all applications, the MS SQL Server, and the DTC services.

Run the extracted executable file Windows2000-KB828741-x86-ENU.EXE.

Reboot the system.

Start the MS SQL Server and DTC services, if they are not started automatically.

To install this patch on a Windows XP or Windows XP Service Pack 1 system, complete the following steps:

Download Microsoft Security Bulletin MS04-012 from the following URL:

http://www.microsoft.com/downloads/details.aspx?FamilyId=D488BBBB-DA77-448D-8FF0-0A649A0D8FC3

Click Download under Security Update for Windows XP (KB828741) to download the file WindowsXP-KB828741-x86-ENU.EXE.

Shut down all applications, the MS SQL Server, and the DTC services.

Run the extracted executable file WindowsXP-KB828741-x86-ENU.EXE.

Reboot the system.

Start the MS SQL Server and DTC services, if they are not started automatically.

Configuring Sybase

If your configuration includes Sybase:

When you are creating the domain using the Configuration Wizard, and specifying values in the Configure JDBC Connection Pools page in the Configuration Wizard, enter SelectMethod=cursor in the Additional Properties field. (This step is not required for the portalPool connection pool.)
Enable DDL in transactions for the Sybase database. Log in to isql as the Sybase `sa' user, and execute the following commands. (In these commands, WEBLOGIC is used as an example of the Sybase database name.)

exec master.dbo.sp_dboption WEBLOGIC, 'ddl in tran' ,true
go
use WEBLOGIC
go
checkpoint
go

If you are configuring your domain for XA, complete the following steps:

Install the license for Distributed Transaction Management (DTM), and configure the Sybase server as follows:

sp_configure "enable DTM",1
go

sp_configure "enable xact coordination",1
go

Copy the sample xa_config file from the SYBASE_INSTALL\OCS-12_0\sample\xa-dtm subdirectory up three levels to the SYBASE_INSTALL directory, where SYBASE_INSTALL is the directory of your Sybase server installation. For example:

$ SYBASE_INSTALL\xa_config

Edit the xa_config file. In the first [xa] section, modify the sample server name to indicate the correct server name.

For more information about creating XA domains, see "Creating XA Domains Using Configuration Templates" in Creating WebLogic Configurations Using the Configuration Wizard, at the following URL:

http://download.oracle.com/docs/cd/E13196_01/platform/docs81/confgwiz/examples.html