Maximo Spatial Database Federation

Originally posted on the developerWorks blog.

Maximo Spatial Database Federation

Author: Rodrigo Dombrowski, Maximo Product Designer & Architect
This article describes the Maximo Spatial architecture that integrates the IBM Maximo Asset Management database with a GIS geodatabase.

All information below is valid for Maximo Spatial 7.5 version.

Maximo Spatial integrates with the GIS database using a concept called database federation, often also called database links.

Database Federation provides the following benefits:

  • No data replication needed as GIS data can be exposed and displayed on Maximo forms
  • Distributed database transactions to ensure consistency
  • Higher performance for batch read and creation of GIS records and Maximo records
  • All Maximo framework functionality and security available when displaying and editing GIS data
  • Multiple geo databases support

Documentation about how to configure Maximo Spatial to integrate with feature class tables is available in:

http://publib.boulder.ibm.com/infocenter/tivihelp/v49r1/index.jsp?topic=%2Fcom.ibm.spl.doc%2Ft_ctr_configuring.html

Documentation about how to expose GIS data to Maximo forms is available in:

http://publib.boulder.ibm.com/infocenter/tivihelp/v49r1/index.jsp?topic=%2Fcom.ibm.spl.doc%2Fconfigure%2Ft_ctr_customize_spatial_apps.html

The Maximo Spatial database configuration is done independently for each feature class that the client want to integrate with Maximo. This allows supporting multiple geodatabases and feature classes in any database schema. For GIS data insert and updates Maximo Spatial requires that both databases be from the same vendor. Oracle+Oracle, or DB2+DB2, or SQLServer+SQLServer.

Configuration Overview

Configuration Overview

In some cases it is not possible to have both Maximo and GIS database from the same vendor or it is not possible to configure database links.
For these cases currently there are the following options:

Option 1 – Read only mode – No database federation (database link)

  • Same configuration process, including Database Configuration steps, but without database link
  • It makes Maximo Spatial only read-only mode for GIS data
  • Map toolbar tools like selection, query by attributes and update GIS list stays working
  • No GIS record link or cron task will be available
  • No GIS geometry creation and editing from Maximo

Option 1

Option 1

Option 2 – No federation, read/write GIS data moved to local Maximo database

Example: Maximo running on DB2 and GIS data on Oracle database

  • Full Maximo Spatial functionality for the GIS data that is moved to Maximo database
  • No federation required when GIS is on the same Maximo database instance
  • GIS data that can be read only to Spatial can stay on Oracle
  • May require additional ArcSDE license
Option 2

Option 2

Using Maximo Oil and Gas to manage permits to work

Using Maximo for Oil and Gas, v7.5.1 to manage work processes with permits to work

The following was originally posted in the IBM Developer Works blog by Liliane Himmel 

To manage the safety of personnel and the workplace, you can define permits to work. Using corresponding work order records, you can associate tasks with permits to work. You can also associate authorized personnel with permit or certificate types to ensure that personnel have the necessary credentials to carry out those tasks. You can specify who is authorized to review and approve the permits to work. You can define the isolations and hazards that are associated with specific assets, and the actions to be taken in emergency situations. You can also create related record relationships between tickets, permits to work, and work orders.

In the Drilling and Completion application, you can review the permits to work that are related to work orders to ensure that all permits are included. Permits to work provide a system of control to ensure the safety of the plant. You can use permits to work to manage the work activities and to ensure that steps are taken to prevent accidents.

Creating permits to work

A permit to work defines the hazards and isolations that are associated with work activities. When you create permits to work, you provide the details with which the permit is associated. You ensure that permits to work are ready to be issued. Optionally, you can hold toolbox talks to communicate the safety aspects of the work activities.

A permit to work defines the hazards and isolations that are associated with work activities. When you create permits to work, you provide the details with which the permit is associated. You ensure that permits to work are ready to be issued. Optionally, you can hold toolbox talks to communicate the safety aspects of the work activities.

About this task
When you create a permit to work, you must evaluate the hazards that are involved in completing the work that is associated with that permit. You can also define the conditions for work.

In addition to creating permits to work from the Permit to Work application, you can create permits to work from the Work Order Tracking application and from the Drilling and Completion application.

Assets or locations are isolated to allow work to be carried out without hazards for personnel. Procedures are followed to contain an asset or a location before an authorized person can work on it. For example, you can specify that an asset is isolated from a potentially hazardous source of energy. When the work is complete, the steps that were taken to isolate that asset are removed so that the asset can be returned to production.

Procedure

  1. In the Permit and Certificate Types application, define a permit or certificate type to associate with this permit to work. Use the rich text editor of the Long Description field to assign a color and a font size to the text. You can assign a different color to highlight the type of permit or certificate. The highlighted text displays in the Permit Header field of the Permit to Work application.
  2. In the People application, authorize qualified, active personnel to conduct gas tests and to record emissions.
  3. In the Risk Assessment application, identify the hazards that are associated with work operations and assess their risks. Hazard records must belong to the same organization as the permit to work.
  4. In the Permit to Work application, click New Permit to Work on the toolbar.
  5. On the Permit to Work tab, specify the beginning and end dates and times, the permit level, and the site for the permit to work.
  6. Specify the asset and location details that are associated with the permit to work. If a permit to work is associated with a work order, the asset and location fields are populated from the work order.
  7. Specify the task details. If the certificate type is an isolation certificate, specify the type of isolation specialization that is required, and the reason for the isolation.
  8. On the Hazards and Isolations tab, specify the risk assessment, the gas testing details, the conditions for work, the isolations, and the hazardous materials.
  9. Save the record.

Ensuring that permits to work are ready to be issued

Verifying the conditions that are associated with permits to work

A toolbox talk is a safety presentation that is given to inform employees about safety procedures. You can also use toolbox talks to verify the conditions that are associated with the work activities. You record the attendees.

Before you begin

The permit to work must be reviewed, approved, issued, and in Active status before the toolbox talk is conducted.

The operating procedures that you add to the toolbox talk must also be in Active status. Operating procedures can be added or removed only when the permit to work is in Draft status.

About this task

You can specify the same identifier for multiple operating procedures, but the combination of organization, site, and procedure number must be unique.

Standard actions can be added when the permit to work is in Request or in Draft status. Review the checklist of standard actions during the toolbox talk. Standard actions cannot be added or removed when the permit to work is in Active status.

Items to be reviewed can include additional work hazards and control measures, or stop the job entries.

Procedure

  1. In the People application, add members of the team and their authorizations and certificates.
  2. In the Operating Procedures application, create the operating procedures to be discussed during the toolbox talk.
  3. On the Toolbox Talk tab of the Permit to Work application, specify the permit to work that requires a toolbox talk.
  4. On the Toolbox Talk tabs, specify the operating procedures, the actions or action groups, and the items to be reviewed.
  5. On the Work Party Declaration tab, specify the members of the team who attended the toolbox talk.
  6. In the Toolbox Talk Completion table, specify whether a toolbox talk was held and the person who held the toolbox talk. You also specify the date and time when the toolbox talk was held.
  7. Save the record.

Completing permits to work

Effective communication throughout the permit to work process is crucial to ensuring that risks are managed. After work is complete or if work is left to be done by another team, the details of returning the permit to work must be documented.

Canceling permits to work

When all of the work activities are complete, and the plant is returned to a safe condition, you can cancel or suspend active permits to work.

About this task

You can review and audit the permit to work before or after you close the record. Audit and survey records that are associated with permits to work must belong to the same site and organization. Before a permit to work can be closed, all isolations that are in place must be removed.

Procedure

  1. In the Permit to Work application, select the permit to work that you want to cancel.
  2. On the Cancelation Details table of the Handback and Cancellation tab, specify the cancellation details.
  3. Specify whether a lessons learned meeting was held or whether there are lessons learned that are associated with this permit to work.
  4. Specify whether this permit to work must go through an audit process. If this permit to work is linked to an audit and survey record, specify the record identifier.
  5. Specify whether the work site was cleared.
  6. Save the record.

Help! Your Maximo Questions Answered

Are you stuck on a particular Maximo question? You can either post up at the MaximoUsers.org/forum for specific questions. But, if you are looking for more general information, IBM has a wealth of information, such as manuals and training videos.  The IBM Education Assistant, or IAE, provides training videos, educational demonstrations, tutorials and other information that is targeted toward the IT professional.

The IEA has just released several new videos:

Other topic of interest:

Maximo V7.1

Maximo v7.1.1

Maximo 7.5

Information originally posted to http://www-01.ibm.com/support/docview.wss?uid=swg21373538

Supporting Windows Mobile 6.5: Why it is still important.

Many folks are very excited about the growth of iPads, Android tablets and smart phones for their Maximo mobile strategy. Field users obviously love the large screen and great interfact. But, as noted in a previous post, there may be a few drawbacks, such as scanning capabilities. For serious enterprise asset management implementations, a mix is very important. Obviously, you would not use a hammer to turn a screw, so the right tool for the job is very important. And if one of those tools is missing, or may be removed from the tool crib, there is every reason to be concerned.

Microsoft has recently announced their latest mobile embedded framework. The latest operating system for handhelds, Windows Embedded 8, as it stands now, will provide a full featured operating system, with a new set of APIs, full device encryption and a “modern intuitive, multi-touch app experience”, which will make using tablets even easier to use.

Yes, once again, the Field worker may appear to be getting most of the love.
Here’s the big drawback.

No Physical Keyboard.

That’s right: No support of physical keyboards. Only on screen keyboard support, which hurts right in the old 10-key. I think several veteran inventory workers just visibly shuttered. Oh, and that user out there that takes meter readings all day just turned a little green, too.

Martin Cooper, Father of the mobile phone

Martin Cooper, Father of the mobile phone

Many of us have taken in stride the on screen keyboards that let you see what you are typing. The idea of “touch typing” is disappearing, especially if you cannot feel the keys as you type.  So, the result is stopping, looking at what you are typing, and resuming your work. These few seconds really can add up. If you haven’t been in the warehouse when a seasoned cycle count worker is kicking out their job, then think about the person at the bank, or accountant that is using 10-key. They fly through those digits without nary a glance. And they are all the speedier for it. Imagine if they stopped and looked at every key before entering it into the system, and you get an idea of how bad an idea of is is to eliminate support.

Now, there is no reason to gather the pitchforks quite yet. Microsoft has said they will support Mobile 6.5 until at least 2020. So all of those commercial handheld units with scanners, including you folks in the Oil and Gas industry that require I-Safe devices for your calibration equipment have about 6 years to make sure Microsoft understands how important physical keyboard support is to your bottom line.

Or, perhaps a new technology will come out in that time, so that this is just a “cry wolf” situation. Since the days of Martin Cooper’s first cell phone call, technology does march on (Or we’d still be using “Brick” phones). I just hope that technology conforms to improve the end user experience, and not the opposite.

Kat Pullen is a Convergence Specialist at DataSplice, LLC, a mobile computing company founded in 2001 to deliver handheld technology to Maximo users in the field. While DataSplice Mobile supports iPad, Android and Windows 8.1, the majority of clients are still very happy with Windows Mobile 6.5. DataSplice is committed to supporting a full range of devices, both mobile and desktop, because you shouldn’t have to compromise.