Create a maxdemo database after installation

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

  1. Open a command window and change directory to C:\IBM\SMP\Maximo\tools\maximo.
  2. 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:
      set DB2DBDFT=dbname
    • 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.
  3. 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.
  4. 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.


Feedback