Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
5 replies Latest Post - ‏2013-01-30T14:21:54Z by maxmadman
swkim90049
swkim90049
278 Posts
ACCEPTED ANSWER

Pinned topic Make database name appear on every screen or at least login?

‏2013-01-28T18:17:58Z |
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.
Updated on 2013-01-30T14:21:54Z at 2013-01-30T14:21:54Z by maxmadman
  • scottsd
    scottsd
    121 Posts
    ACCEPTED ANSWER

    Re: Make database name appear on every screen or at least login?

    ‏2013-01-28T18:28:12Z  in response to swkim90049
    This information is stored in this system property, visible in the System Properties application:

    mxe.db.url

    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.

    Thank,
    Scott
    • swkim90049
      swkim90049
      278 Posts
      ACCEPTED ANSWER

      Re: Make database name appear on every screen or at least login?

      ‏2013-01-28T19:04:53Z  in response to scottsd
      I just made a bulletin board entry and put that in the start center for maxadmin. hopefully, that will be good enough. ;)
  • maxmadman
    maxmadman
    66 Posts
    ACCEPTED ANSWER

    Re: Make database name appear on every screen or at least login?

    ‏2013-01-29T15:32:09Z  in response to swkim90049
    Check 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.
    • swkim90049
      swkim90049
      278 Posts
      ACCEPTED ANSWER

      Re: Make database name appear on every screen or at least login?

      ‏2013-01-29T16:11:40Z  in response to maxmadman
      We are on 6.2.8... is this for 7.x and on?
      • maxmadman
        maxmadman
        66 Posts
        ACCEPTED ANSWER

        Re: Make database name appear on every screen or at least login?

        ‏2013-01-30T14:21:54Z  in response to swkim90049
        Should work for 6.x