If you postponed creating the database tables
for the IBM Performance Data Warehouse until after profile creation,
you or your database administrator must create the tables manually.
You can use the scripts that the Profile Management Tool generates
during profile creation or augmentation.
Before you begin
You have performed the following actions:
- Created or augmented a stand-alone profile.
- Chosen not to run the database scripts to initialize the databases
during the configuration.
- Created the database that you want to create the Performance Data
Warehouse database tables in. The default name for the Performance
Data Warehouse database is PDWDB.
Procedure
- Go to the directory that holds the SQL scripts
for creating the database tables. By default,
SQL scripts are output to profile_root/dbscripts/PerformanceDW/SQLServer/ at
profile creation time.
- Run the following script.
configPerformanceDWDB.sh
Note: You
can specify the createDB parameter after the command
to create a local database. Skip this parameter if you have already
created the required database.
Results
You have created the database tables for your Performance
Data Warehouse and have completed the database configuration.