How to create Maximo demo database (MAXDEMO)

The Maximo contains an extremely useful command to create a demo database filled with a sample data. This can be really helpful when learning haw Maximo works.

Tho create the demo database perform these steps.

  • Stop the application server (MXServer)
  • Open a command prompt
  • Move to:[SMP_DIR]\maximo\tools\maximo
  • Issue the following command:
    maxinst -s[INDEXTABLESPACE] -t[DATATABLESPACE]

By default both tablespaces are equals to MAXDATA so the following command should work.

maxinst -sMAXDATA -tMAXDATA

To create an empty databasse add the -imaximo parameter.

maxinst -imaximo -sMAXDATA -tMAXDATA

For further details about the maxdemo command see this IBM technote.

How to create Maximo demo database (MAXDEMO)

3 thoughts on “How to create Maximo demo database (MAXDEMO)

  1. Your DBA creates the database. The tablespace name can be whatever you want it to be or that your DBA has named within the database. For demo database, the tables and indexes can be in the same tablespace. For production use, the tablespace may be different names (allocated to different disks) for performance reasons.

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top