IBM Support

Creating a Maximo or Maxdemo Database

Technote (FAQ)


After the installation, what additional steps need to be taken for Maximo and/or Maxdemo database(s) creation?


The Maximo product installation contains an option to automatically create a Maximo/Maxdemo database. If you choose to manually create the database and/or would like additional databases you can run the MAXINST program. Additional Maximo and/or Maxdemo databases can be created after the installation using the MAXINST program.

Follow the steps in the Installation Guide to manually create a database. Refer to the section for the database platform and version you are using. Once the database has been created a Maximo or Maxdemo database can be created in that database instance.

1 Open a command prompt

2 Change directory path to: ibm\smp\maximo\tools\maximo

3 At the prompt, type maxinst -s<tablespacename> -t<tablespacename>

Maximo reads the file (i.e. c:ibm\smp\maximo\applications\maximo\properties) for database connectivity information. It then connects to the database (via the JDBC connection) and
creates a Maxdemo database. If you would like to create the empty Maximo database, use the -imaximo flag. For example, at the command prompt, instead of just maxinst, type: maxinst -imaximo

The following table lists the flags that you can use with maxinst.

Flag Description
-a database alias Database alias. If not specified, uses
-d log file directory If using the -l parameter, it will output logfile to the specified directory; otherwise, it outputs to the Maximo log directory, (i.e. ibm\smp\maximo\tools\maximo\lo)
-e none Causes SQL to be executed. Required, Already present in maxinst.bat
-f file name Filename for properties file. If not specified, uses
-i file name Filename of input file (without path or extension).
-k prop. file directory Directory for properties file
-l none Outputs a detailed log file. Strongly recommended. Already in maxinst.bat
-o file name If using the -l parameter, the filename for the logfile.
-p password Password for the database connection. If not specified, uses mxe.db.password property, or MAXIMO (must be all capital letters).
-s index tablespace Tablespace for index storage
-t table tablespace Tablespace for table storage
-u user name Username for database connection. If not specified, uses mxe.db.user property, or MAXIMO (must be all capital letters).
-x doclink file separators This parameter fixes the doclink (Attached Documents) file separators. If a Unix environment is deployed without using this parameter, the doclinks will not work properly.

CAUTION -S and -T PARAMETERS: Maxinst does not provide a default value for tablespace.
The -S and the -T PARAMETERS are required. You must always specify the data and index tablespace names. There is no default value

The -X flag is required for UNIX environments.

CAUTION If MAXINST fails for any reason, you must drop and recreate the Maximo schema before re-running MAXINST.

NOTE Each flag must be followed by the parameters without a space, for example: -uMAXIMO.

NOTE In Maximo 7.6, the maxdemo files in C:\ibm\smp\maximo\tools\maximo\en are compressed and must be decompressed before using with maxinst.

After the MAXINST has built the Maximo database, the installation related properties may need to be added or changed to reflect a new database creation. These properties are used when installing add-ons or fix packs. The properties and there values are in the file. The file is located in the ibm\smp\etc folder. You can add these properties to the database from the System Properties application in Maximo. If a new database was created, the file also needs to be modified to use the new database. The file is located in the ibm\smp\maximo\applications\maximo\properties folder.
See the folowing for editing the files -

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT All
Systems and Asset Management Maximo Asset Management Essentials All

Document information

More support for: Maximo Asset Management

Software version: 7.1, 7.1.1, 7.5, 7.6

Operating system(s): Platform Independent

Reference #: 1314938

Modified date: 26 July 2017

Translate this page: