DB2 OLAP Server includes two sample applications and databases that show the features
of Partitioning:
- Samppart, Company
- Sampeast, East
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.
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:
- Open Administration Services Console.
- In the Enterprise View, select the appropriate
Administration Server name under the Administration
Servers node.
- Under that node, select the User node,
right-click, and select Create user.
- In the Create user on Administration Server dialog box, in the User name text box,
enter partitionuser.
- In the Password text box, type password.
- In the Confirm Password text box, type
the password again.
- In the Administrator privileges drop-down
list box, select true.
- Click OK.
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:
- Open Administration Services Console.
- From the Enterprise View, expand the Applications node and select the Samppart application.
- Expand the Databases node and select the Company database.
- Expand the Partitions node and select Source Databases.
- Under the Source Databases node, double-click:
servername:SampEast:East [transparent]
The Repair Partition
dialog box opens.
- In the Data Source group and the Data Target group, from the User drop
down menu, select the user name of your choice.
- Enter the password for the user.
- 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.