Is there a way in Maximo to show the database name we are connected to? Maybe using a query like select * from v$database;
We have multiple databases (one for test mirror of production) and another database for upgrade testing.
It would help us make less mistakes if we explicitly know which database we are working on.
This topic has been locked.
5 replies Latest Post - 2013-01-30T14:21:54Z by maxmadman
Pinned topic Make database name appear on every screen or at least login?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-30T14:21:54Z at 2013-01-30T14:21:54Z by maxmadman
scottsd 2000003CK1121 PostsACCEPTED ANSWER
Re: Make database name appear on every screen or at least login?2013-01-28T18:28:12Z in response to swkim90049This information is stored in this system property, visible in the System Properties application:
Unfortunately, you can't get this into the start center or application header I don't think without tweaking some jsps (an unsupported hack). But your administrators maybe can be educated to check that system property before making major changes.
maxmadman 2700007WDK66 PostsACCEPTED ANSWER
Re: Make database name appear on every screen or at least login?2013-01-29T15:32:09Z in response to swkim90049Check out the MAXMESSAGES table, specifically the welcomemaximomessage.
Select * from maxmessages where msgkey = 'welcomemaximomessage' update the value column to reflect the database name e.g. 'Welcome to Maximo Test'
You will then see that message on the login screen.