MAM 7.6.1.2:

I can enable(create) audit tables without needing a db config outage.

If that's the case, then why do I need db config to create a custom table?

• Aren't the two scenarios similar? I would think a custom table would be low risk. It seems like it should be possible to add a custom table to the Maximo data dictionary on the fly -- without the need for db config.

I wonder if IBM could consider letting us create a custom table (or a custom view object) -- without the need for a db config outage.



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

#AssetandFacilitiesManagement
#Maximo

I am a little amazed that the code allows for an audit table to be created without going into admin mode...but a glance at the code would seem to indicate that you are correct.  However, I wonder if there is not a bug waiting to happen and simply has not arisen yet because of how little IBM exposes audit tables.  There are two reasons for admin mode.  One is for a change that needs to be synchronized with the UI and users  For example, adding a required field to workorder.  But, it is also done to refresh the server cache with information.  For some areas there is no cache involved.  But, objects and attributes are cached.  If all the servers are not refreshed then problems will eventually occur (obviously depends on the change and the implementation).  For a custom MBO, it and its attributes may or may not show up in app designer, but eventually it will be requested to the server that has no knowledge.  Audit table do have a separate path...but if someone puts it on the UI I have a feeling it won't work so well until the cache is refreshed...

------------------------------
Steve Hauptman
------------------------------