Create Maxdemo data post installation

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. 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

IBM Support Link 

How to retrict an application to show limited data from the object

In some case u may want to create a new application from an existing application and want to restrict the data to be shown based on some condition or you want to do it in an existing application. Following steps will help

1. From the application designer export the applications that you want to work on.
2. Save the XML and keep a backup of working XML.
3. Open the XML in any XML editor like npp 
4. Add the following text in the table control of List tab apprestrictions="'TYPE='TOOL'" where TYPE='TOOL' is the condition that I have used, this can any complex where clause on the main object on which the application is based on.
5. Save the XML and import it from the application designer.