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