Creating a Maximo and/or Maxdemo Database

Technote (FAQ)


Question

After the installation additional Maximo and/or Maxdemo database(s) creation

Answer

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 in Chapter 6. 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 maximo.properties 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 mxe.db.url.property
-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 maximo.properties
-i file name Filename of input file (without path or extension). The default filename is Unlcvt if the -i param is not provided.
-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.

After the MAXINST has built the Maximo database, the installation related properties will need to be added. These properties are used when installing add-ons or fix packs. The properties and there values are in the install.properties file. The install.properties file is located in the ibm\smp\etc folder. You can add these properties to the database from the System Properties application in Maximo.

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

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management

Software version:

7.1, 7.1.1

Operating system(s):

Windows

Reference #:

1314938

Modified date:

2009-06-26

Translate my page

Machine Translation

Content navigation