Maximo Maintenance - EMA Notes

greasyservantInternet and Web Development

Jul 30, 2012 (5 years and 17 days ago)

552 views

EMA Notes


Maximo is maintained on 4 servers


1.

Report Server
-

d
edicated to the reporting software Actuate

2.

W
ebsphere, which is on a Unix box. Websphere contains Test, Dev, and Production and
is a webpage server
. It

produces the sessions for the Maximo dat
abase.

3.

Staging/Application Server
-

dedicated for the application files and is needed
if

changes
are made to the database configuration. This server can be a Windows based PC and can
contain all Maximo environments such as Test, Dev, Demo, Production. Th
is server is
extremely important
, but not necessary to keep the database running

4.

Main Database Host
-
dedic
a
ted to host the main database and is built on a Unix box using
Oracle


this is the production server.


EAR FILES


EAR files make and apply changes t
o the database configuration. They take classes and put into
a package(compile code). To deploy EAR files you must be signed onto websphere from the
application server. EAR files are compiled on the application server from the command prompt.


Buildin
g an EAR File



G
o to command prompt on the Application Server.



Go to c:
\
MaxDev(or Test)
\
Deployment
\
Default



DEL Maximo.ear. Doing this ensures that a new EAR file is created.



CD .. to go back to C
:
\
MaxDev(or Test)
\
Deployment



type buildmaximoear


Additi
onal documentation regarding building EAR files can be found in
62_mx_install_was60_unix.pdf


After
EAR

files are created, the server must be stopped and the application must be re
-
installed.
In order to re
-
install you must be on the websphere server at
http://ramah:9060/ibm/console/secure/logon.jsp?okaction=OK

Use initials to log
-
in and click on OK

Click on Servers
-

Application Servers

Check on the box to the left of the server t
o select the server and select Stop from the toolbar. If
the server selected to be stopped is in use


notify the users FIRST!!

Once stopped click on Applications


Enterprise Applications

Click and select the
application and select uninstall

This may tak
e a few minutes

Then a Reinstall must occur

From the same screen Select Install

At the screen Preparing for new application installment there will be a prompt for a new path file


browse to the newly created EAR file

Click Next

The prompt will be for gene
rate default binding


Click Next

There will be an error message that will pop up


this is okay click Next

You will be prompted for an application name


the default will show Maximo


change the
name to reflect the application ex. DEV Maximo or TEST Maxi
mo click Next

On the next screen you will need to select from the list at the top of the screen using the CTRL
key

Select the first and last item on the list

And then change the default names in the lower part of the
screen to

MAXDEV/MAXTEST

Click Next or
Finish

Re
-
Start the server
-

check the log
files

and sign out of websphere


Maximo Properties

To find properties for Maximo go to C:
\
MaxDev(Test)
\
applications
\
maximo
\
properties

Use this file to identify locations for files, servers, etc. Keep the port a
t 0 so that Maximo will
look for the server. Do not change this unless it can’t find the port.


Maximo Properties files contains:

The directory that points to the database

Our license number which is = LXN812760


Welcome Screen

Whenever the database is co
pied from Production to Test
or Production to any location and the
database is to be deployed for use


the Welcome screen will need to be changed to reflect the
database in use. The Welcome scripts located in the EMAStuff folder will help to accomplish
t
his task. These scripts have been provided to the DBAs since they will most likely be the ones
inititating the changes.


Errors

Errors on web log
-
in

500 = connection to the database is not right

400 = websphere problem


Apply Hot Fix

To apply the patch/ho
t fix



BACK UP THE DATABASE!!!!

Follow instructions provided with the hot fix

Copy the Hot fix script into Tools


only need to copy the files which apply or appear to apply to
the fix

Open DOS
prompt go

to the directory RUNSCRIPTS_001 if you need to re
peat for additional
scripts use the arrow key to bring up the previous line and cha
n
ge the ending number

Check log file for success

Build the EAR file and re
-
deploy the application


Log Files

To create a log file to narrow the scope or troubleshoot a probl
em

Go to Log file

Change

logging file wh
ich is located

in the same directory as the p
roperties file [logging.txt]

Where it says info


change to debug

Save

Shut down appserver

Rebuild EAR files

Deploy EAR files

Restart application

Run application and tak
e steps to get error

Go to webshpere

Click on Logs & Trace

Locate the server name

JVM Logs

Runtime


Things that need to be changed



E
-
Mail server


change the name in production/test/dev in the properties file


Customizations in Tables

MaxVars


initial dat
a load

MaxObject

MaxObjectcfg

MaxAttribute

MaxAttributecfg


No siteid


default to abcwtr


GOOD PRACTICE



Weekly shutdown of of websphere


this will help to clear the open sessions



Once a month bring down database and do cold backup



Regenerate XML file reg
enerate for Actuate

Do this when websphere brought down & need to regenerate report server

o

If EAR files are rebuilt

o

Go to Application

o

Report Administration

o

Box on the Right Hand Side
-

BUILD XML



Good things to know

Database Version = V 600.647

Which is
version 600.01 from the diskettes + one patch


MEA


used for interfaces
-

send XML


read into Maximo



it is unclear whether we have
licensing for MEA


APP files are built in TEST, PROD, & DEMO but not Dev

Of the diskettes we have for Maximo


DO NOT US
E the Windows Disk


UNIX ONLY


To run updates on software


go to DOS and run update from
MAX{TEST}{DEV}/PowerupdateClient/MXES6/Install


To determine which table and field names are used within Maximo


click onto the field while in
Maximo and press F1 &

the ALT key


Keep in mind


once files are built on websphere


the application/staging server files are no
longer needed unless additional changes are made


Passwords

Test


Maxadmin

Prod 4 the authority

DevMaxadmin


EMA Points of Contact

Patruick Fulle
r 407
-
786
-
5367

John Brietz 407
-
786
-
5381

Pat Morrow 727
-
365
-
1910 (cell)