You must configure an Oracle usage
records database. The crtsrvOra.sh script is
provided for this purpose.
Before you begin
Before you begin, the following software
should be installed:
- Oracle Database,
version 11.1.0.7
- Log in to the Oracle server
as a database administrator.
- Create a directory that has write and
execute permission, for example DB_dir.
- Copy the installation .tar file, IBMXdmsDbPackage_7.0.0.tar,
from the installation medium to the new directory.
- Switch to the new directory.
- Unpack the installation .tar file using the following command:
tar -xvf IBMXdmsDbPackage_7.0.0.tar
- Switch to the following directory: DB_dir/usageRecords.
- Delete the usage record table, if it has already been created.
- Run the crtsrvOra.sh script using
the following command
./crtsrvOra.sh dbName dbAdmin dbAdminPW dbUser dbUserPW INITorDDLFile infoflag
Use
the following parameter values:Parameter |
Description |
Example value |
dbName |
Database name |
XDMS |
dbAdmin |
Database administrator ID |
SYSTEM |
dbAdminPW |
Database administrator password |
pw |
dbUser |
Database user ID |
xdmsuser |
dbUserPW |
Database user password |
pw |
INIT or DDLFile |
'INIT' to initialize or path to DDL file |
UsageDbOra.ddl |
infoflag |
Display information flag |
TRUE |
Example:./crtsrvOra.sh XDMSUR SYSTEM password xdmsuser password UsageDbORa.ddl TRUE
- After the script displays the input values, press Enter
to continue.
- After the script completes, verify that the database tables
were created properly by running a command similar to the following:
select USAGERECORDS from user_tables
If the script ran properly, the USAGERECORDS table is
shown in the display.