Installation and Upgrade Guides › Directory Configuration Guide › IBM DB2 › How to Upgrade a 6.x Policy Store › Extend the IBM DB2 Policy Store Schema

Extend the IBM DB2 Policy Store Schema

You can extend an existing 6.x policy store schema to include the objects introduced by r12.0 SP2. There are no changes to the existing 6.x policy store schema.

To extend an existing IBM DB2 policy store schema

1. Log into SQL Server as the user who administers the Policy Server database information.
2. Start the Query Analyzer.
3. Select the policy store database instance from the database list.
4. Navigate to policy_server_home\xps\db, open the file DB2.sql in a text editor, and copy the contents of the entire file.
   • policy_server_home

     Specifies the Policy Server installation path.

5. Paste the file contents into a query, and execute the query.

   The policy store schema is extended to include the objects introduced by r12.0 SP2.