Previous Topic: How to Upgrade a 6.x Policy StoreNext Topic: Import the Base Policy Store Objects

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 SP3. There are no changes to the existing 6.x policy store schema.

Follow these steps:

  1. Log in to the Policy Server host system.
  2. Navigate to the following location:

    siteminder_home\xps\db\tier2\db2

    siteminder_home

    Specifies the Policy Server installation path.

  3. Copy the following schema file:

    DB2.sql

  4. Log in to the DB2 host system and save the schema file locally.
  5. Open a command prompt and run the following command: 
    db2 -td@ [-v] -f path\DB2.sql
    path

    Specifies the path to the DB2 schema file.

    The policy store schema is extended.