Skip navigation.
Downloads | Product Documentation | Support

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://e-docs.bea.com/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:

1. 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://e-docs.bea.com/wls/docs81/jdbc_drivers/mssqlserver.html#install_jta

2. 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

3. 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:

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

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

2. Click Download under Security Update for Windows 2000 (KB828741) to download the file `Windows2000-KB828741-x86-ENU.EXE`.
3. Shut down all applications, the MS SQL Server, and the DTC services.
4. Run the extracted executable file `Windows2000-KB828741-x86-ENU.EXE`.
5. Reboot the system.
6. 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:

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

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

2. Click Download under Security Update for Windows XP (KB828741) to download the file `WindowsXP-KB828741-x86-ENU.EXE`.
3. Shut down all applications, the MS SQL Server, and the DTC services.
4. Run the extracted executable file `WindowsXP-KB828741-x86-ENU.EXE`.
5. Reboot the system.
6. 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:

1. 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

2. 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

3. 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://e-docs.bea.com/platform/docs81/confgwiz/examples.html`