You can create a project results database that is internal
to the appliance and based on IBM DB2 by
using a default DB2 pattern
and a script package named Configure DB2 Results Database
for RIT.
Before you begin
To clone a pattern on the appliance, you must be assigned
the Create new catalog content role or the Workload resources administration
role with full permissions. For more information about user roles,
see Managing system users.
Important:
The Default DB2 OLTP
Pattern for Linux is available
on the appliance. The license must be accepted and the pattern must
be enabled before you can deploy this default database pattern.
About this task
To use a
DB2 project
results database that is internal to the appliance, clone the Default DB2 OLTP Pattern for Linux, add a script package
Configure
DB2 Results Database for RIT and configure it.
Procedure
- From the workload console, click . The
available virtual system patterns are displayed.
- Click Default DB2 OLTP Pattern for Linux.
- To create a copy of the selected virtual system pattern,
click the Clone icon on the toolbar.
- In the Name field, type a unique
name and optional version for the cloned virtual system pattern. Be
sure to use only alphanumeric characters in the name. Do not use any
special characters. This name is used as the identifier for the cloned
virtual system pattern that you are adding to the catalog.
Restriction: The name can have no more than 64 characters.
- Click OK. The cloned virtual system
pattern is created and initially populated with the same configuration
values as the original virtual system pattern. The name of the cloned
pattern is displayed in the list of available virtual system patterns,
and the detailed information is displayed in the pane.
- Configure the cloned pattern by adding the Configure
DB2 Results Database for RIT script package.
- Click the cloned pattern. The pattern details are displayed.
- Open the Pattern Builder. Click the Open icon
on the toolbar.
- Expand Scripts and drag the Configure
DB2 Results Database for RIT script into the OS Node box
on the canvas.
- Edit the connections between the script package and
the other components.
- Add a link between the script package and oltpdb.
Move the cursor over Configure DB2 Results Database for
RIT until the blue circle turns orange.
Helper text describes the asset that is
associated with the link. Select the circle, drag a connection to
the oltpdb asset until the asset is highlighted,
and then release.
- When you create a link between two assets, you can see that each
property of one asset is mapped to each property of the asset to which
it is linked.
Click OK to confirm the connection
and the data dependencies.
- Add another link between the script package and DB2
Server. Move the cursor over Configure DB2
Results Database for RIT until the blue circle turns orange.
Select the circle, drag a connection to the DB2 Server asset
until the asset is highlighted, and then release.
- When you create a link between two assets, you can see that each
property of one asset is mapped to each property of the asset to which
it is linked.
Click OK to confirm the connection
and the data dependencies.
- To save the changes to the pattern, click Save.
- Close the Pattern Builder.
- Deploy the cloned pattern. From the Virtual System
Patterns page, click the Deploy icon
on the toolbar.
- Complete the required fields to deploy the pattern.
- On the Deploy Pattern page, leave
the default name for the virtual system. If you change
the name, make note of this information for future use.
Restriction: The name can have no more than 64 characters.
- Enter any other required information:
- Select the environment profile to use for the deployment. Internally
or externally managed environment profiles can be used for single-system
deployments.
- Specify, or accept the default cloud group and IP group to deploy
into. These fields are displayed only for internally managed environment
profiles.
- Set a priority for the deployment.
- Optional: Set up Secure Shell (SSH) access to the deployment either
by generating an SSH public/private key pair, or by specifying an
externally generated SSH public key. The generated or specified public
key is uploaded to the virtual machines during deployment. If you
generated a key pair, be sure to download the private key file to
a secure location. You can distribute this file later to users who
are allowed to access the deployed virtual machines in the cloud group
for troubleshooting and maintenance purposes.
- Set the schedule for the deployment to be at the current time
or a later time that you specify.
- Click the component names to set the parameters for the individual
software components. Fields that have a red asterisk next to the name
are required parameters that you must set before the pattern is deployed.
You
can accept all or most of the default values, although you might prefer
to override some of them. For example, you might want to override
the cell name or node name to conform to your site naming conventions.
In most cases, only passwords need to be additionally specified.
- Click Quick Deploy to start the
deployment process. The length of time that is required
for the deployment to complete depends on the complexity of the pattern
that is being deployed.
Results
The deployment process creates and starts the virtual machine
for the cloned pattern.
What to do next
Get the database connection details. You need this information
to connect to the project results database.