Upgrade Guide

Database Changes for SP4

This appendix includes details about WebLogic Portal Version 8.1 database schema changes for SP4.

Note: No database schema changes are required for Service Pack 5; however, you must update the default markup in the database, using the provided script, to be SP5 compliant. For instructions, see Upgrading to Service Pack 5.

Entitlement Policy Reference

These new tables support the persistence of Portal entitlement and Delegated Administration security policy reference data. Policy storage remains within LDAP; however, now the policy reference data is stored in the RDBMS. When you access the Administration Portal for the first time in an upgraded domain, an automatic migration of this policy reference data is performed.

The following tables are new in SP4:

P13N_DELEGATED_HIERARCHY
P13N_ENTITLEMENT_APPLICATION
P13N_ENTITLEMENT_POLICY
P13N_ENTITLEMENT_RESOURCE
P13N_ENTITLEMENT_ROLE

Refer to the .sql files prefixed "er_" in the directory WL_HOME/portal/db for your DBMS to review the DDL for the Entitlement Policy Reference tables.

See the Data Dictionary for details about these new tables:

http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/4Schemas.html

Portal Framework

The following changes were made for each DBMS that WebLogic Portal supports.

The PF_DESKTOP_DEFINITION has a new column named IS_TREE_OPTIMIZED. This column is a flag indicating whether tree optimization is on or off for a desktop. Acceptable values are 0 and 1, where 0=tree optimization is off (the default), and 1= tree optimization is on.

Refer to the file named 81sp4_alter_tables.sql under WL_HOME/portal/db for your DBMS to review the Database Definition Language (DDL) for this change.

Several new indexes were created to improve performance; others indexes were dropped because they became redundant.

Refer to the files named 81sp4_create_objects.sql and 81sp4_drop_objects.sql under WL_HOME/portal/db for your DBMS to review the DDL for this change.

Sybase Database Changes

The following Sybase-specific database changes occurred in SP4:

ON WEBLOGIC_INDEX was added so that non-clustered indexes are placed onto their own segment and device; this change was made for administrative and data allocation/placement purposes, and performance is improved.

See the 81sp4_drop_objects.sql and 81sp4_create_objects.sql files in WL_HOME/portal/db/sybase/125 to review the DDL for this change.

Sample scripts for "Configuring a Sybase Database" were modified to include the WEBLOGIC_INDEX device and segment definition.

For details, see WL_HOME\portal\db\sybase\125\admin.

Clustering indexes were reworked to improve performance.

See the 81sp4_drop_objects.sql and 81sp4_create_objects.sql files in WL_HOME/portal/db/sybase/125 to review the DDL for this change.

LOCK clauses were added for each table to set either DATAPAGES or DATAROWS locking for each table. This excludes the tables for the Collaboration Portlets provided by Compoze.

See the files named 81sp4_lock_adj.sql under WL_HOME/portal/db/Sybase/125 for the DDL for the locking changes. Triggers are dropped and recreated as a result of these locking changes.

SQL Server Database Changes

The following SQL Server-specific database changes occurred in SP4.

ON WEBLOGIC_INDEX was added so that non-clustered indexes are placed onto their own file group; this change was made for administrative and data allocation/placement purposes, and performance is improved.

See the 81sp4_drop_objects.sql and 81sp4_create_objects.sql files in WL_HOME/portal/db/sql_server/2000 to review the DDL for this change.

Sample scripts for "Configuring a Microsoft SQL Server Database" were modified to include the WEBLOGIC_INDEX file group definition.

For details, see WL_HOME\portal\db\sql_server\2000\admin.

Clustering indexes were reworked to improve performance.

See the 81sp4_drop_objects.sql and 81sp4_create_objects.sql files in WL_HOME/portal/db/sql_server/2000 to review the DDL for this change.

DB2 Database Changes

The following SQL Server-specific database change occurred in SP4:

Clustering indexes were reworked to improve performance.

See the 81sp4_drop_objects.sql and 81sp4_create_objects.sql files in WL_HOME/portal/db/db2/8 to review the DDL for this change