Preparing the system for sample data

You can add sample data to a demo database when you deploy Maximo® Manage. The sample data is useful for development or test environments. If you want to add sample data after Maximo Manage deployment is complete, you must re-create or clean your database and reconfigure Maximo Manage.

1. In Maximo Application Suite, update the configuration to install demo data.
   1. Log in to Maximo Application Suite by using administrator credentials.
   2. Click the Administration icon.
      Starting in Maximo Application Suite 9.1, select the Suite > Administration page.
   3. Click the Workspaces tile.
   4. In the Applications section, click the Manage tile.
   5. From the Actions list, select Update configurations.
   6. In the Update Manage configuration window, in the Database row, click the Edit icon.
   7. In the Advanced settings section, select the Install demo data checkbox.
   8. Click Apply changes.
   9. Click Confirm in the confirmation dialog.
2. In the Red Hat® OpenShift® web console, check if demodata is set to true.
   1. Log in to the Red Hat OpenShift web console by using your administrator credentials.
   2. From the side navigation menu, click Administration > CustomResourceDefinitions.
   3. On the CustomResourceDefinitions page, search for manageworkspace.
   4. Click ManageWorkspace and then click the Instances tab.
   5. Select the custom resource of your instance and click the YAML tab.
   6. In the spec.settings.db.maxinst section, check if demodata: true is set.
      Tip: If you do not see the demodata section, add it.
   7. Click Save to save your changes.
   8. Click Reload to check whether your changes were applied.
   Remember: If you do not see your changes, you might need to repeat this step because the automatic reload process can update the YAML file before you make your manual updates.
3. If you want to clean the database to force the maxinst process to restart, use a query tool by consulting your database provider. In your Maximo Manage database, delete the following database tables.
   • maxvars
   • apikeytoken
   • serversession
   • maxsession
   Note: If you want to drop your entire database, back up your database and then complete the steps that are provided by your database provider.
4. If you deployed Maximo Utilities with Maximo Manage, delete the plusdcuchngstatseq sequence.
5. Restart the maxinst pod.
   1. In the Red Hat OpenShift web console, from the side navigation menu, click Workloads > Pods.
   2. On the Pods page, search for the maxinst pod.
      For example, <mas_instance_id>-<mas-workspace-id>-manage-maxinst-<randomstring>.
   3. In the row for the maxinst pod, click the Overflow menu and select Delete Pod.
   4. In the Delete Pod dialog, click Delete to confirm deleting the maxinst pod.
      Important: Deleting the pod removes any files that are copied to the pod container directly. The deleted files are different from the ones in the Maximo Manage image that is built during the Maximo Manage deployment process. The files that are part of the Maximo Manage image include the contents of the Maximo Manage components and customizations that were added through customization archives.

      When the pod is deleted, another pod with a similar name is created.

   5. Select the new pod that was created and click the Terminal tab.
   6. Run the following commands.

      cd logs
      ls -ltr

      Tip: If you do not see the maxinst log, wait for five minutes and run the ls - ltr command again. You can also click the Logs tab to check for the maxinst log.