Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
Back to discussions
Expand all | Collapse all

Non-structural database configuration (partial live; admin mode not required)

  • 1.  Non-structural database configuration (partial live; admin mode not required)

    Posted Wed December 22, 2021 09:58 AM
    Edited by System Admin Wed March 22, 2023 11:49 AM

    MAM 7.6.1.2:

    What kinds of things can we do in db config that don't require admin mode?
    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Non-structural database configuration (partial live; admin mode not required)

    Posted Wed December 22, 2021 10:13 AM
    Edited by System Admin Wed March 22, 2023 11:49 AM
      |   view attached

    From page 52-54 in the Administering Maximo Asset Management 7.5 manual:
    (I'm not sure why, but this information was removed from the 7.6 manual. And the info in the Knowledge Center is pretty light.)


    Non-structural database configuration

    You can implement partial live database configuration without turning on admin mode. For example, if you add a domain or default value for an attribute, you do not need to turn on admin mode to configure the database.

    You can use partial live database configuration for the following changes:

    • Changes that you can apply without disrupting the live MboSets. If there are any pending changes for which you cannot use partial live database configuration, you must perform a full live configuration or a traditional shutdown configuration.
    • For changes that are reversible. If a user applies live changes that are later determined to be incorrect, you can perform another live update to remove the changes.
    If you change the field validation class for an attribute and perform a live update to apply the changes, the business objects that are already instanciated are not revalidated.



    Database changes unrelated to eAudit

    Some object-level and attribute-level parameters are eligible for live update.


    Changes to certain attribute-level parameters are eligible for live update. The following table lists these attribute-level parameters.


    If any of the Cfg tables for an object or any of its attributes have changes that are not listed in the preceding tables, that object and its attributes are not eligible for live update.

    Database changes involving eAudit

    An audit table is an object that MaxTableCfg.EauditTbname references.

    Example
    If the Person table is audited and its audit table is named A_Person, two rows exist in MaxTable Cfg, as shown in the following example.


    For the base table, changes to the audit-related, object-level parameters in the following table are eligible for live update. For an audit table, if the object you add (MaxObjectGfg.Changed = I) and its base table are eligible for live update, then the audit table is also eligible.

    The table that follows lists the object-level parameters that are eligible for live update.


    The following table lists changes to the audit-related, attribute-level parameters on the base table that are eligible for live update.


    #AssetandFacilitiesManagement
    #Maximo


  • 3.  RE: Non-structural database configuration (partial live; admin mode not required)

    Posted Wed December 22, 2021 10:22 AM
    From IBM Support:
    Non-structural database changes include:
    • Adding an index to a table
    • Adding a domain value to an existing attribute or removing domain from a field
    • Creating a new relationship for a table
    • Changing the title of an existing field
    • And so on...
    TS007917481
    Original Message