You can create a maxdemo database and additional databases
after you have installed the product. You can populate the database
with sample data. You use the maxinst program to create additional
databases.
Before you begin
The maxinst program does not provide default values for
table space parameters. Specify the data and index table space names
to ensure that your installation runs smoothly.
About this task
If you created a database either automatically or manually
during the installation, you can use maxinst to optionally create
a maxdemo database in that database instance. If the maxinst program
fails, you must recreate the
Maximo® database schema
before running the maxinst program again.
Procedure
- Open a command window and change directory to C:\IBM\SMP\Maximo\tools\maximo.
- You can create an additional database in one of the following
ways:
- To create a DB2® database,
run the following command to set the DB2DBDFT variable:
- To create an SQL Server database,
Launch maxinst using
the –s and –t parameters:
maxinst -sPRIMARY -tPRIMARY –m2
- To create an empty Maximo database for
Oracle, run the following command:
maxinst -s<tablespacename> -t<tablespacename> -imaximo
- To create a maxdemo database for Oracle, run the following
command:
maxinst -s<tablespacename> -t<tablespacename>
For example, type maxinst -sMAXIMO -tMAXIMO.
The system reads the maximo.properties file
for database connectivity information. The maximo.properties file
is located in the C:IBM\SMP\Maximo\Applications\Maximo\Properties directory.
The system connects to the database through the JDBC connection and
creates a maxdemo database.
- You can populate the additional database by running commands
with specific parameter values. The following table lists the maxinst
database parameters:
Parameter |
Description |
-a |
Database alias. If not specified, the alias mxe.db.url.property is
used. |
-d |
Log file directory. If you are using the -l parameter,
the log file is sent to the specified directory. Otherwise, the log
file is sent to the log directory, for example C:\IBM\SMP\Maximo\tools\maximo\lo. |
-e |
Runs the SQL. This parameter is required and already present
in the maxinst.bat file. |
-f |
File name for the properties file. If not specified, maximo.properties is
used. |
-i |
File name of the input file (without path or extension). If
not specified, the default file name Unlcvt is
used. |
-k |
Directory of the properties file. |
-l |
Creates a detailed log file. This parameter is already present
in the maxinst.bat file. |
-o |
If you are using the -l parameter,
the -o parameter specifies the file name for
the log file. |
-p |
Password for the database connection. If not specified, the mxe.db.password property
or MAXIMO is used. If MAXIMO is
used, it must be entered in uppercase letters. |
-s |
Required: Table space for index storage. |
-t |
Required: Table space for table storage. |
-u |
User name for database connection. If not specified, the mxe.db.user property
or MAXIMO is used. If MAXIMO is
used, it must be entered in uppercase letters. |
-x |
Required for UNIX: Fixes
the doclink file separators in UNIX environments. Note: If
a UNIX environment
is deployed without using this parameter, the attached documents do
not function properly. |
- Add the installation-related properties to the database
from the install.properties file. The install.properties file
is located in the C:\IBM\SMP\ETC folder. You
can add these properties to the database from the System Properties
application.