Friday, January 30, 2015

How to take the Backup of WebSphere & DB2


md D:\TSRMBKPSCRIPT
if already exists
del D:\TSRMBKPSCRIPT
md D:\TSRMBKPSCRIPT
db2cmd -i -w db2clpsetcp
echo %DB2CLP%
db2
CONNECT TO MAXDB71 USER db2admin USING <db2admin’s password>
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
CONNECT RESET
force applications all
BACKUP DATABASE MAXDB71 USER db2admin USING <db2admin’s password> TO “D:\TSRMBKPSCRIPT” WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
CONNECT TO MAXDB71 USER db2admin USING <db2admin’s password>
UNQUIESCE DATABASE
CONNECT RESET
cd “C:\Program Files\IBM\WebSphere\AppServer\bin\”
backupConfig.bat -username wasadmin -password <wasadmin’s password>
move WebSphereConfig_*.zip D:\TSRMBKPSCRIPT

Maximo Rebuild and Redploy EAR


1 Ensure that no database configuration changes are pending.
2 Shut down the Maximo application server.
3 Back up the database.
4 Back up the C:\IBM\SMP\maximo.
5 Take Comodo Snapshot backup
6 Extract the files to a folder
7 Copy all files to C:\IBM\SMP\maximo
8 When asked choose to overwrite all files new copied files
9 Open a DOS prompt:
i) cd \<maximo_root>\tools\maximo
ii) updatedb
10 Apply any manual updates listed in this readme.txt file. Manual changes if any are listed for each APAR in the section “Manual Changes”
11 Delete the application server cache
C:\Program Files\IBM\Websphere\AppServer\profiles\CtgApp01\temp\ctgNode01\MAXIMOSERVER
12 Rebuild and redeploy the EAR files, and then restart the application server
i) Backup existing ear file.
cd C:\ibm\SMP\maximo\deployment\
run buildmaximoear.cmd
ii)     cd C:\ibm\smp\maximo\tools\maximo
run encryptproperties.bat
iii) shutdown application server
iv) cd C:\ibm\SMP\jacl\solutions
v) DeployApplication.bat wasadmin WASADMIN_PASSWORD “MAXIMO” ctgNode01 MXServer “C:\ibm\SMP\maximo\deployment\default\maximo.ear” maximo_host webserver1
vi) Now try to start MXServer from WAS  admin console https://localhost:9043/ibm/console/
It should automatically start Maximo Enterprise Application as well.
vii) if MXServer starts but Maximo Enterprise application does not, then try running Maximo Enterprise Application again while MXServer is running.
If it fails saying Not synchronized
Then follow the following:
a. stop nodeagent service from services.msc
b. run this command
C:\Program Files\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\bin>syncNode.bat TSRM_WAS_SERVER_NAME 8879 -username wasadmin -password WASADMIN_PASSWORD
(Note: If you face issues like unable to authenticate, check if TDS is running or not.)
output will be like below:
————————————–
ADMU0116I: Tool information is being logged in file C:\Program Files\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\logs\syncNode.log
ADMU0128I: Starting tool with the ctgAppSrv01 profile
ADMU0401I: Begin syncNode operation for node ctgNode01 with Deployment Manager
<hostname>: 8879
ADMU0016I: Synchronizing configuration between node and cell.
ADMU0402I: The configuration for node ctgNode01 has been synchronized with Deployment Manager <hostname>: 8879
————————————–
c. after successful syncnode start nodeagent from services.msc
d. start maximo enterprise application in WAS
Database configuration is in progress message starting Maximo. Start fails
Technote (troubleshooting)
Problem(Abstract)
java.lang.Exception : Database Configuration is in process . ConfigDB and RestoreFromBackup must complete before MXServer can be booted .
at pdsi.server.MXServer.boot
Login receives Error 500: system#notboundexception
Resolving the problem
It is possible for configdb to leave a flag set, which can stop Maximo from starting.
Run the following SQL
select * from MAXVARS where varname=’CONFIGURING’;
Check the VARVALUE returned. It will be a ’1′ to signify that configdb is running . If it is not, then do not continue and call into support to report the error.
update MAXVARS set varvalue=’0′ where varname=’CONFIGURING’;
This will reset the flag that signifies configdb to be running.
Maximo should now start.

Add Tablespace in DB2 Database for Maximo


Symptom

You cannot save another record.
BMXAA4211E – There is a database error number -289 to operate longDescription Ldownertable Ldkey = 83,212 = Worklog Language = EN Ldownercol = DESCRIPTION. Unable to allocate new pages to the tablespace “MAXDATA”.

Resolving the problem

  1. Run –> cmd
  2. Type: db2cmd
  3. Another command prompt will open up
  4. type: db2
  5. you will now be at db2 prompt
  6. type: connect to maxdb71 user db2admin using <db2admin’s password>
  7. it will say you are connected
  8. type: set schema = maximo
  9. it will say command completed successfully
  10. type: LIST TABLESPACES show detail
  11. Locate/Find the “Tablespace ID” (TS ID) of the MAXDATA
  12. ie: MAXDATA is TSID of 3
  13. type: LIST TABLESPACE CONTAINERS FOR <TS ID of MAXDATA> SHOW DETAIL
  14. example: LIST TABLESPACE CONTAINERS FOR 3 SHOW DETAIL
  15. Output will be like below
Tablespace Containers for Tablespace 3
Container ID = 0
Name = C:\CTGINST1\NODE0000\SQL00001\CTGDAT\MAXDATA\container1
Type = File
Total pages = 152587
Useable pages = 152544
Accessible = Yes
16. Notice the containers already added (at the end of path, the file name). You can not use same container name for your new container.
17. Choose some new name. If already added one is container1, let’s name ours as container2
18. Add another container file. 
19. this command will add a 6.4GB file of space on your existing drive (200,000 pages of 32KB)
20. type: alter tablespace MAXDATA add ( file ‘container2′ 200000 )

Restore Database in DB2 to another instance


db2cmd -i -w db2clpsetcp
echo %DB2CLP%
db2
CONNECT TO MAXDB71 USER db2admin USING <db2admin’s password>
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
CONNECT RESET
force applications all
Restore DATABASE MAXDB71 USER db2admin USING <db2admin’s password> FROM “D:\TSRMBKPSCRIPT” WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
CONNECT TO MAXDB71 USER db2admin USING <db2admin’s password>
UNQUIESCE DATABASE
CONNECT RESET

How to recover a failed database configuration in Maximo



Run the following SQL
select * from MAXVARS where varname=’CONFIGURING’;
Check the VARVALUE returned. It will be a ’1′ to signify that configdb is running . If it is not, then do not continue and call into support to report the error.
update MAXVARS set varvalue=’0′ where varname=’CONFIGURING’;
This will reset the flag that signifies configdb to be running.
run —> db2cmd
connect to maxdb71 using db2admin using <db2admin’s password>
set schema = maximo
SELECT count(*) from maxobjectcfg where changed != 'N'
‘N’ indicates that a change has been committed. For this query, if entries are returned with a value of 0 instead of N, you must commit those changes.
select count(*) from sysibm.systables where name like 'XX%' and creator = 'MAXIMO'
This was to determine whether any temporary tables exist in your database.
If the returned value is not 0, follow these steps to drop the temporary tables:
open cmd.
cd C:\ibm\SMP\maximo\tools\maximo
run the following in order below:
configdb.bat
restorefrombackup.bat
dropbackup.bat


Then try to see if websphere admin console is running or not
localhost:9060/ibm/console
login
if can not login, then check have you started directory server?
Once logged in try to start mxserver
ideally it should start
if it complains of node agent being not started, then go to services.msc (run –> services.msc) and restart nodeagent service of websphere
retry the starting of mxserver. This time it should start and you should get the login screen at http://localhost/maximo

Move Maximo Database to another server


The installation properties are maintained in the Maximo database, and the maximo.properties file. These are required for fixpack installations, and other product installations. Over time passwords may change, hostnames/ip-addresses or database names may change. In order to update these values, follow these instructions:
1. Update the \ibm\SMP\maximo\applications\maximo\properties\maximo.properties file on the Admin Workstation to change the IP-Address/Hostname for either the database server or the webserver. Also to update the password
a. Delete the file named maximo.properties
b. Rename the file named maximo.properties_orig to maximo.properties (this is an unencrypted file)
c. Edit the maximo.properties file and update the hostname/IP-address for the database server.
d. If necessary, update the password for the user to access the database
e. Save the file
Note: The file will be automatically re-encrypted when you install a fixpack or other product. If this is not an immediate activity, you can run encryptproperties.bat file located in C:\ibm\smp\maximo\tools\maximo directory against the file to encrypt it.
2. Update the \ibm\SMP\etc\install.properties file on the Admin Workstation to change the IP-Address/Hostname for either the database server or the webserver.
3. Update the values in the maximo database to change the IP-Address/Hostname for a variety of servers, or to update passwords.
a. Connect to the maximo database using your favorite SQL editor utility.
b. Query the maxpropvalue table, and find the key you need to edit. For example, WAS.DeploymentManagerHostName is the key for the hostname or IP address of the WebSphere machine.
c. Create a query to update that value to the new value, and run the query.
d. Repeat for any passwords, ip addresses etc that need to be updated.
4. Rebuild and redeploy the EAR files.

http://www-01.ibm.com/support/docview.wss?uid=swg21382026

How to set up a clustered Maximo application environment


The following describes the steps required to set up a clustered Maximo application (an example). Maximo clustering provides a means to group like functionality. In this example the Maximo EAR file is deployed to the cluster is for the UI. From there the IHS web server will be used to distribute the requests between identically defined application servers. This is a great way to scale your Maximo system.
Note: To share resources in a clustered environment, all resources must be defined at the cell-level within the WebSphere console.
In the example configuration below, we will use the following names:
MXCLUSTER is the cluster
MXUI1 is a cluster member
MXUI2 is a cluster member

Creating a cluster and cluster members

First, you define both the Cluster and the Cluster members that make up the Cluster. Begin by using the following “example” configuration for a single application server Java Virtual Machine (JVM):
50 concurrent users, 1 CPU and 2GB of RAM memory.
So, using the above example, if you had 100 concurrent users, you would create a 2-JVM cluster and the server environment would have 2 CPUs and 4GB of ram memory.
1. Login to the WebSphere Administrative Console.
2. Click Servers > Clusters, in the Server clusters screen, click New.
3. Enter the basic cluster information,
a. Enter MXCLUSTER in the Cluster name field.
b. Check Prefer local checkbox, click Next.
4. Create first Clustered Servers member, enter the following:
a. Enter MXUI1 in the Member name field.
b. Accept the defaults in the Select Node and Weight fields.
c. Check the Generate Unique Http Ports checkbox.
d. Select the “Create the member using existing application server as a template” radio button and choose MXSERVER (this is the application server name created initially for Maximo) from the drop down list and click Next.
5. Create additional cluster members, enter MXUI2 in the Member name field, click Add Member and then click Next.
6. Click Finish to create the cluster and clustered servers, then click Save
7. Heap size: Click Application servers, then click on each new server > Java and Process Management > Process Definition > Java Virtual Machine and fill in both the Initial and Maximum Heap sizes. Click Apply and then click Save
NOTE: When setting the Initial/Maximum heap size for the MXUI1/MXUI2 application server JVMs, the following recommended heap size should be used for each JVM:
32-bit server = 512MB/1024MB
64-bit server = 1024MB/2048MB.

Update Virtual Hosts

This procedure describes how to verify port numbers used by the clustered servers. It also explains how to update the virtual host with the port number information. A virtual host enables a single host machine to resemble multiple host machines. Each virtual host has a logical name and a list of one or more DNS aliases by which it is known.
1. To verify port numbers of the clustered application servers, perform the following actions:
a. Servers > Application Servers, click MXUI1.
b. Under the Communications, click Ports.
c. Make a note of the WC_defaulthost port number for use below (9081, 9082).
2. Repeat Step 1 for MXUI2.
3. Environment > Virtual Hosts, click New.
4. Enter MXCLUSTER_host is the Name field, click Apply.
5. Click Host Aliases under Additional Properties.
6. Click New in the Host Alias panel to add 3 Host name and port number values to the host aliases list:
a. Host Name: *, Port: 80 (IBM HTTP Server port), click OK.
b. Host Name: *, Port: 9081 (same as port number for MXUI1), click OK.
c. Host Name: *, Port: 9082 (same as port number for MXUI2), click OK.
7. Click Save.

Deploying to the Cluster

Now that you have created and configured the MXCLUSTER, you then should deploy your enterprise application (EAR) within the cluster.
Note: When mapping modules to servers, make sure you select both MXCLUSTER and the webserver1 as the web server:
WebSphere:cell-ctgCell01,cluster=MXCLUSTER
WebSphere:cell-ctgCell01,node=ctgNode01,server=webserver1
Also, when mapping virtual hosts to web modules, use the virtual host you created above for the cluster:
MXCLUSTER_host
Lastly, start the MXCLUSTER Cluster

IBM PMR URL

Following is the IBM PMR URL.

https://www-947.ibm.com/support/servicerequest/Home.action

You will require an IBM web id and password to log in.

Thursday, October 24, 2013

How to send e-mail Sending with Report

This is a comprehensive tutorial. Meaning it will be lengthy as I walk you through the entire process from start to finish. Since it is impossible for me to cover every single detail, I expect you to know some basics.

Please check out the Below Link for further details.

http://maximobase.blogspot.in/2012/11/how-to-send-e-mail-sending-with-report.html


For more knowledge base please visit 

http://www.techmcq.com

You can also install the Q&A app by techmcq for exploring your knowledge.

Upgrading databases

To upgrade a DB2 database to DB2 Version 9.7:
  1. Log on to the DB2 server as the instance owner or a user with SYSADM authority.
  2. Optional: Rename or delete the db2diag log files so that new files are created. Also, remove or move to another directory any existing dump files, trap files, and alert log files in the directory indicated by the diagpath parameter. By doing this, the files only contain information about the upgrade process that helps you to isolate and understand any problem that might occur during database upgrade.
  3. Upgrade the database using the UPGRADE DATABASE command:
       db2 UPGRADE DATABASE database-alias USER username USING password
    where database-alias is the name or the alias of the database you want to upgrade and the username and password to authenticate a user with SYSADM authority.
  4. If the UPGRADE DATABASE command fails and returns the SQL1704N error message with a reason code that describes the cause of the failure, find this SQL error code and determine the action to take from the list of the possible solutions for each reason code. One of the most common causes of upgrade failure is that the log file space is not large enough, in which case the following error is returned:
    SQL1704N  Database upgrade failed.  Reason code "3". 
    You must increase log file size and execute the UPGRADE DATABASE command again. After the database upgrade is complete reset the value of logfilsizlogprimary and logsecond database configuration parameters.
    There are additional error codes that are returned by the UPGRADE DATABASE command for specific cases not supported by database upgrade. These cases are described in the upgrade restrictions.
  5. If the UPGRADE DATABASE command returns the SQL1243W warning message, you need to drop or rename the SYSTOOLS.DB2LOOK_INFO table. Otherwise, the ALTER TABLE and COPY SCHEMA statements will fail to run. Check if the SYSTOOLS.DB2LOOK_INFO table exists by running the following command:
       db2 "SELECT tabname, tabschema, definer FROM syscat.tables 
              WHERE tabschema = 'SYSTOOLS' AND tabname = 'DB2LOOK_INFO'"
    If you created this table, rename it by running the RENAME statement:
       db2 RENAME SYSTOOLS.DB2LOOK_INFO TO new-table-name
    If you did not create this table, remove it by running the DROP command:
       db2 DROP TABLE SYSTOOLS.DB2LOOK_INFO
  6. If the UPGRADE DATABASE command returns the SQL1499W warning message and writes theADM4100W warning message with all the details to the administration notification log, you have external unfenced routines on Linux or UNIX that have no dependency on the DB2 engine libraries and the UPGRADE DATABASE command redefines your external routines as FENCED and NOT THREADSAFE. Also, the DB2_FENCED option is set to 'Y' for all user-defined wrappers.
    This command also generates a script called alter_unfenced_database-name.db2 with all the SQL statements to redefine external unfenced routines, altered during the database upgrade, as NOT FENCED and THREADSAFE. This script is created in the directory specified by the diagpathdatabase manager configuration parameter. If the diagpath parameter is not set, the script is created in the INSTHOME/sqllib/db2dump directory where INSTHOME is the instance home directory.
    If you need to define your routines as NOT FENCED and THREADSAFE, refer to Upgrading C, C++, and COBOL routines for details on how to safely run your routines in the new multithreaded database manager and then use the generated script to redefine your routines.
  7. If the UPGRADE DATABASE command returns the SQL1499W warning message and writes theADM4101W warning message to the administration notification log, take note of the system catalog tables reported in the ADM4101W message so that you collect statistics on these tables as part of the post-upgrade tasks.
  8. If the UPGRADE DATABASE command returns the SQL1499W warning message and writes theADM4102W warning message to the administration notification log, qualify or delimit with quotes the identifiers called NULL in your SQL statements to avoid conflict with the NULL keyword.
    If you use identifiers called NULL for column names, routine parameter names, or variable names in an SQL statement that are not fully qualified or delimited with quotes, the identifier name might resolve to the NULL keyword instead. This would result in a change in behavior from previous releases. Refer to Upgrade essentials for database applications for details.
  9. If the UPGRADE DATABASE command returns the SQL1499W warning message and writes theADM4106W warning message to the administration notification log, drop all references to the XML Extender user-defined data types and drop all XML Extender database objects under the DB2XML schema. Starting with DB2 Version 9.7, XML Extender is discontinued.
    To avoid this error, perform all the steps in Upgrading a DB2 server with XML Extender to DB2 Version 9.7 to completely disable XML Extender and remove XML Extender functionality before upgrading your instance and databases.
  10. If the UPGRADE DATABASE command returns the SQL1499W warning message and writes theADM4105W warning message to the administration notification log, create new MQ functions for the XML data type by running the enable_MQFunctions command with the -xml parameter. The set of DB2 WebSphere® MQ functions for XML Extender are dropped during database upgrade.
  11. If the UPGRADE DATABASE command returns the SQL1499W warning message and writes theADM9516W warning message to the administration notification log, verify that the indexrecconfiguration parameter is set to RESTART and issue the RESTART DATABASE command to rebuild indexes marked as invalid during database upgrade. Otherwise, index rebuild starts on your first access to the table and you might experience an unexpected degradation in response time.
    Type-1 indexes and indexes with an index page that could not be upgraded are marked invalid during database upgrade.
  12. If the UPGRADE DATABASE command returns the SQL0473N error message, you need to reverse the database migration and re-create all user-defined data types that use a system built-in data type name with a different name that is not restricted.
    To avoid the UPGRADE DATABASE command failure, re-create these user-defined data types duringVerifying that your databases are ready for upgrade.
  13. If the UPGRADE DATABASE command returns the SQL1700N error message, you need to reverse the database migration and re-create database objects that use restricted schema names with a schema name that is not restricted.
    To avoid the UPGRADE DATABASE command failure, re-create these database objects duringVerifying that your databases are ready for upgrade
    .
  14. Compare your database configuration settings after upgrade with the configuration settings you had before you upgraded your database. Verify the following settings and database information are the same:
    • Database configuration parameter settings
    • Table spaces information
    • Packages information for your applications only
    You do not need to check package information for system generated packages. The information about system generated packages can change after upgrade.
  15. Verify your database upgrade is successful. Connect to the upgraded databases and issue a small query:
       db2 connect to sample
    
         Database Connection Information
    
        Database server        = DB2/AIX64 9.7.0
        SQL authorization ID   = TESTDB2
        Local database alias   = SAMPLE
    
       db2 "select * from syscat.dbauth"
    Alternatively, if you have sample files installed, run the testdata.db2 script:
       cd samplefile-dir-clp
       db2 connect to sample
       db2 -tvf testdata.db2
    where samplefile-dir-clp is DB2DIR/samples/clp on Linux and UNIX andDB2DIR\samples\clp on Windows, DB2DIR represents the location specified during DB2 Version 9.7 installation, and sample is the database name.

EAM Implementation Approach



From developing the Maximo “footprint” to conducting end user training, we have to involved in almost every aspect of Maximo based project execution.  we can make project succeed in the areas such as:

  • Project planning

  • Maximo Site Assessment

  • Business process analysis and reengineering

  • Requirements gathering and analysis

  • Maximo 4.1/5.2/6.2/7.1 installation, upgrade, customization and configuration including

  • security, database configuration, multisite and general system setup

  • equipment, system and location hierarchy design 

  • vendor, inventory and purchasing configuration

  • maintenance management setup including work orders, PMs, Routes and Job Plans

  • Development and integration with custom applications

  • Multi-site and multi-database implementation

  • Data extraction, transformation and loading (ETL)

  • Actuate and BIRT Report development

  • Post implementation support.



Maximo installation System Requirements

Hardware (distributed topology)

Distributed deployment hardware prerequisites: This table contains hardware information for IBM middleware components. If you deploy the product using non-IBM middleware components, see the documentation provided with the product. 
 Administrative workstation:
  • 2-4GHz processor (minimum)
  • 4 GB RAM (minimum)
  • 10 Mbit/s network connection between administrative workstation and middleware servers (minimum)
  • 11 GB disk space
You must have a minimum of 11 GB disk space available for a fresh installation. Ensure 7 GB of disk space is available if you are performing an upgrade.
An additional 6 GB of disk space must be available in the TEMP directory of the administrative workstation during the installation.
Consider future process managers you might install when determining your disk space needs.

IBM DB2 (alternative database can be used):
  •  Minimum 20 GB disk space.
 IBM WebSphere Application Server Network Deployment (alternative J2EE server can be used):
  • 2-6 GHz processor
  • 40 GB disk space
  • 6 GB RAM
Oracle WebLogic Server(alternative J2EE server can be used): 

  • 2-6 GHz processor
  • 40 GB disk space
  • 6 GB RAM
IBM Tivoli Directory Server (optional component):

Linux®and UNIX® systems require 1 GB of space available in the /opt directory.


Please check out the Below Link for further details


http://www.ibm.com/developerworks/wikis/display/maximo/System+Requirements+for+Version+7.5+Maximo+Products

Maximo Modules and Features of each module.

Asset Module

• Track assets, associated costs, histories and failures of serialized asset.
• Use asset modeling to determine relationships between a piece of asset, its
physical location & the systems with which it may be associated.
• Create hierarchies identifying operating locations as part of multiple systems.
• Build an equipment history to roll up maintenance costs.
• Build failure code hierarchies to record asset problems for analysis.
• Set measurement points, perform trending and defect analysis through condition
monitoring.
• Assign stores, repair shops, and vendors as location records to facilitate continual
tracking of equipment as it is moved.
• Analyze the potential for failure based on a piece of assets location and the
possible effects on systems with which it is associated.

Work Orders Module

• View detailed planning information: work plan, scheduled costs, labor, materials,
equipment, failure analysis and related documents via Work Order Tracking screen.
• Enter simple or detailed day-to-day maintenance requests via Work Request screen.
• Record maintenance work and close work orders from the shop floor via Quick
Reporting screen.
• Schedule work orders based on real-time update of criticality.
• Define and sequence work for multiple assets based on location and/or equipment.
• WBS for related work orders or projects.
• Compare real-time budgets or estimates against actuals and historical work orders.
• Track inside/outside machinery that must be off-line prior to work being performed.

Work Manager Option

• Develop daily plans and manage backlogs to lower response time and equipment
downtime.
• In dispatch mode, enter work, assign employees and track ongoing jobs in real time.
Centralized dispatching and shop floor dispatching are supported.
• In planning mode, assign employees to future work orders scheduled and track
employee availability.
• Plan upcoming work based on priority of work and craftsperson availability.

Inventory Module

• Specification of attributes and the ability to search by attribute for Items, Equipment
and Locations.
• Over 2,000 material classification templates.
• Track stocked and non-stocked items through multiple stores.
• Track items, costs and balances by bin, lot and storeroom.
• Replenish stock from vendor, ventral store, or other storeroom, when quantities fall
below minimum levels.
• Reorder items automatically by shelf life.
• Track item costs by last cost, average cost or user-defined standard cost.
• Automatically reorder materials through user-defined EOQ, ROP, and Safety Stock
algorithms.
• Use ABC analysis to assign inventory item priorities governing frequency of physical
item counts.
• Access material forecasting and time availability information.
• Create temporary stores for carriers responsible for items in transit.
• Employ just-in-time methodologies by utilizing WO Reservation Dates as well as lead
time to generate POs.
• Identify out-of-stock items or make substitutions with alternate parts, vendor and
location tracking capabilities.
• Establish EOQs, ROPs and safety stock by individual storeroom.
• Issue parts directly or in batch to work orders and GL Account Codes.
• View work order reservations for inventory items.
• Display all assets on which a given part is used.
• Mandate a date/time stamped and system verified authorization before changes in
inventory can be made.
• Access latest cost information and item levels instantly.

Preventive Maintenance Module

• Generate PM work orders individually, batched or automatically.
• Accommodate multiple criteria for work order generation.
• Generate seasonal preventive maintenance work orders for planned shutdowns.
• Sequence multiple job plans and consolidate multiple procedures on one PM master.
• Cluster PM work orders to take advantage of unplanned downtime.

Purchasing Module

• Create RFQ for multiple vendor bids on materials and services.
• Create purchase requisitions or purchase orders for materials and services.
• Create purchase requisitions from scratch or from the Inventory or Work Orders
Module.
• Automatically create purchase orders from purchase requisitions; create purchase
orders in batch from line items of multiple purchase requisitions.
• Store standard descriptions for use on PR, PO, or invoice items.
• Create agreement purchase orders to purchase parts over time.
• Automatic release of agreement POs.
• Create special orders by entering item descriptions as line items for parts not in
inventory database.
• Use direct purchasing to order and issue parts and services directly to work orders or
GL Account Codes.
• Analyze vendor performance when ordering parts.
• Use Invoice Matching to complete purchasing cycle within Maximo for seamless
interface with other enterprise financial applications; automatically perform two-way
(PO/Invoice) and three-way (PO/Receipt/Invoice) matches.
• Define an unlimited number of currencies to track purchases from different countries.
• Optimize purchasing efficiency with electronic commerce.

Plans Module

Job Plans

Track multiple quantities and costs by operation or job plan.
Divide job plans sequentially, each with its own parts, labor and tool estimates.
Automatically retrieve the most current rate and cost information for material, labor
and tool cost estimates.
Duplicate job plans for modification.

Safety Plans

• Hazardous material identification.
• Identification of hazards that can be eliminated by Lockout/Tagout.
• Identification of hazards that cannot be eliminated with their resulting precautions.
• Ability to identify affected equipment and locations.
• Associate and track permits.

Inspections

• Define Inspection plans and schedules for inspection.
• Record Inspection information thereby enabling auditability of statutory requirements.
• Analyze Inspection data to support Predictive Maintenance.

Labor Module

• Store information by employee, craft, or contractor.
• Maintain personnel files for each employee's attendance, vacation, sick, and nonproductive
work time; track overtime history and individual pay rates.
• Create craft records including regular and overtime pay rates.
• Associate labor records with craft records for organizing labor by craft.
• Report actual labor on work orders in timecard format.

Calendars Module

• Create schedules for equipment, craft, and labor records.
• View calendars via start/end date illustrating shifts, holidays, and vacations.
• View calendars by month or day displaying total work hours available.
• Associate calendars with labor and craft records to plan work based on equipment and
labor availability.

Resources Module

Maintain detailed company, service contract, and tool records for use in other modules
to plan and analyze maintenance work.

Compliance Assurance Systems Features

Track regulatory compliance activities by agency: planning, implementation and
documentation.
• Control, verify and document precautions, storage, treatment, transportation and
disposal of hazardous materials and wastes.
• Set up and track countless compliance details, such as instrument calibration,
emissions data, groundwater waste volume, radioactive waste, operating hours,
operator training and certification, scheduled parts replacement, equipment
specifications, and hazardous container locations.
• Document safety and emergency processes and procedures.
• Facilitate safety, regulatory and permit sign-offs.
• Identify and track step-by-step safety and lockout/tagout procedures.
• Establish links to regulatory agencies, documents, filings, service bulletins and recall
information.
• Preview current best practices and standards to aid compliance decisionmaking and
modeling.
• Create a clear, complete audit trail.

Integration Features

• Risk free integration with multiple financial systems including commercial integration
to SAP, Oracle and PeopleSoft.
• Eliminates duplicate handling of data and ensures upgradeability to future versions of
Maximo with commercial APIs.
• Supports double entry accounting for complete integration with your own financial
system.
• Manage purchasing process via Maximo or integrate with your own financial system.
• Take advantage of user-defined financial calendars to correlate directly with your
accounting periods.
• Summarize transactions for integration while providing detailed audit trail information
in Maximo.
• Preserve your corporate General Ledger codes through Maximo's customizable, multisegment
General Ledger account field.
• Use Application Launching to register and launch applications from within any Maximo
module.
• Use Documents function to establish relationships between drawings and equipment;
launch drawings and images in their native application.
• Use Chart of Accounts to validate and control financial GL accounts.
• Access Maximo data directly, query or update the database, and run reports with
Interactive SQL.

Using Maximo’s Master PM’s and PM Hierarchies

Usage / Definitions

Master PM –Used to control or update PM records. When used with a “Rotating Item” the PM can create PM records for all equipment associated with the item.

PM Hierarchy –Used to group PM’s into Parent-Child relationships. When the PM Hierarchy is generated the same Parent-Child relationships will be maintained for the work orders generated.

Route-A route is a list of related assets or locations. A route generates a Work Order Hierarchy.

PM Hierarchy

•Used to manage larger projects with multiple assets/locations
•Used to generate a structure where work order can be assigned to various groups, departments and/or individuals

Examples:

  • Shutdown / turnaround “template”
  • Motor rewind



    • Routes

      •Used to generate a checklist for a large number of asset.
      •Work or procedure is relatively quick
      •Work history is required for each location/asset on the route
    • Examples:

    • Fire extinguisher inspection
    • Lube route

    Master PM

    •Large number of similar assets requiring the same preventive maintenance activities.
    •A large number of PM’s where there are benefits in controlling them together for operations reasons.

    Examples:

    • 50 identical motors or pumps
    • A section of the plant with varying operating seasons 

    Master PM's -Two Methods

    Method#1


    Method#2








What are Beans in IBM Maximo

The information provided in this post is based on my Maximo 6 experience. I don’t know if or to which extent it has changed in Maximo 7.

There are 2 types of Beans in IBM Maximo, AppBean and DataBean.


AppBean
The AppBean manage application functionality, such as WOTRACK or ASSET. 

This class is defined in the beanclass attribute of the presentation tag in the application’sXML.

If you export the WOTRACKapplication xml and go to the bottom of the file you can see a group of actions (action tag) defining actions and their corresponding method in the AppBean beanclass.

For instance if you’d like to add a button on WOTRACK to approve a workorder (OOTB in Maximo 7 but not in 6) besides of creating the SIGOPTION andTOOLBAR records for that operation you’d also have to develop custom Javacode for it, this would be done in the AppBean. 

DataBean

Data Beans can manage both dialog boxes and tables. The DataBean class associated is defined in the beanclass attribute of both the dialog and tabletags in the application’s XML.

For instance, on dialog boxes you can use a DataBean to control what to do when the OK button is pressed (submit() method).

On tables you can do things such as custom the way to load the MBOSet on that table (getMboSet() method).

You have to have in mind that the flow control of the dialog’s execution is quite complex.
 For instance, if you don’t provide a submit() method on your dialog’s bean class, Maximo will try executing other methods and will end up executing the execute() (I think this is the method) method of the MBOSet asociated with your dialog (defined with the mboname attribute of the dialog tag).
 If you export the WOTRACK application xml and go to the bottom of the file you can see a group of actions (action tag) defining actions and their corresponding method in the AppBean beanclass. ”
The Action tag in Presentation XML for any application, associates an event with a method on the primary MBO for that application, this code is not neccessarily associated with a method on a bean class.
The id specified in the action specifies the event-name for the method on the primary mbo.

Example:

This invokes the createWorkorder method on the WO mbo when the “CREATEWO” event is raised within the WOTRACK app.
When a button is pushed, or other action is generated in a Maximo screen, it generates a WebClientEvent (such as “CREATEWO”)
The Maximo event-handler will walk up it’s hierarchy of Data and App bean classes, looking for a method with a name matching the event. if it finds one, it executes that code.
If no matching method is found (or if the method returns with EVENT_CONTINUE), it will check the Action tags within the presentation, and execute the associated method on the primary mbo if found.
If no matching action is found in the presentation, it searches for a dialog of the same name within that application and invokes that.
if no matching dialog is found on the application xml, it searches LIBRARY.xml for the dialog, and opens that dialog if found.
Failing all of this, a nothing-handled-exception gets thrown.