Setting the environment for the partitioning sample applications

DB2 OLAP Server includes two sample applications and databases that show the features of Partitioning:

These applications and databases include partition definitions stored in .ddb files. The .ddb files define the map between member combinations in the target database, Company, and the source database, East. The Analytic Services Database Administrator's Guide describes Partitioning, member combinations, and the differences between target and source databases.

For the Partitioning applications to work in your environment, you may need to create a user named partitionuser, or you may need to change the embedded user names in the .ddb files.

Note:
Do not go into the .ddb files to change user name information. Instead, complete the steps in the following topics: Creating the partition user describes how to create the required user name, so that users can use the applications. Changing embedded server names in the sample partition definitions describes how to change the embedded server name to your server name.

Creating the partition user

You must create a user named Partitionuser before you work with the Samppart and Sampeast applications. Partitionuser must have access to both applications.

To create the Partitionuser:

  1. Open Administration Services Console.
  2. In the Enterprise View, select the appropriate Administration Server name under the Administration Servers node.
  3. Under that node, select the User node, right-click, and select Create user.
  4. In the Create user on Administration Server dialog box, in the User name text box, enter partitionuser.
  5. In the Password text box, type password.
  6. In the Confirm Password text box, type the password again.
  7. In the Administrator privileges drop-down list box, select true.
  8. Click OK.

Changing embedded server names in the sample partition definitions

If you choose not to create Partitionuser, you can change the embedded user name in the partition definition files (.ddb) to the user name of your choice as long as that user has administrator privileges. The .ddb files shipped with Samppart and Sampeast are based on the server name localhost.

To change the server name in the Samppart Company and Sampeast .ddb file:

  1. Open Administration Services Console.
  2. From the Enterprise View, expand the Applications node and select the Samppart application.
  3. Expand the Databases node and select the Company database.
  4. Expand the Partitions node and select Source Databases.
  5. Under the Source Databases node, double-click:
    servername:SampEast:East [transparent] 

    The Repair Partition dialog box opens.

  6. In the Data Source group and the Data Target group, from the User drop down menu, select the user name of your choice.
  7. Enter the password for the user.
  8. Click Repair to save your changes.
Note:
Note: If, in the Repair Partition dialog box, you changed the user name for both the Data Source Group and the Data Target group, you do not need to repeat this process to change the user name in the Sampeast East .ddb file.