Maximo

Importing data from a CSV file into Maximo

This entry is part of the Maximo Integration Framework series. In this tutorial I will show how to configure the Maximo Integration Framework (MIF) in order to import data in Maximo from a Comma Separated Values (CSV) text file. The best thing is to start with an export. Please follow this article before proceeding. To […]

Flat CSV file export with Maximo Integration Framework

This entry is part of the Maximo Integration Framework series. In this tutorial I will show how to configure the Maximo Integration Framework in order to export data from Maximo into a Comma Separated Values (CSV) text file. To achieve such goal we must configure the following chain: Object Structure Publish Service External System For […]

List Maximo customizations

In this little post I will share few database queries to list the customizations made to your Maximo environment. It also applies to other TPAE based products. Security restrictions SELECT * FROM securityrestrictORDER BY objectname, attributename; Custom objects and attributes SELECT * FROM maxobjectWHERE userdefined=1ORDER by objectname;SELECT * FROM maxattributeWHERE userdefined=1ORDER by objectname, attributename; Custom […]

Maximo performances and network latency

Maximo and other IBM service management products based on TPAE (like SmartCloud Control Desk) can be seen as sitting at the apex of a pyramid that consists of network, hardware, and software services. As you can see, network performance are the foundation of the pyramid.The simplest way of measuring network performances and speed is the […]

How to improve DocLinks performances in Maximo/TPAE applications

During a performance assessment of a production customer environment I have set the mxe.db.logSQLTimeLimit system property to 2000 to log all long-running SQL statements (see this TechNote for details). Looking at the system logs I have noticed many entries like this. select * from doclinks where (ownertable=’WORKORDER’ and ownerid=1065680) or (ownertable=’WORKORDER’ and ownerid in (select […]

How to enable Axis (Web Services) logging

This entry is part of the Maximo Integration Framework series. Maximo uses the Apache Axis library to call external Web Services. Sometimes could be useful enable the logging for this library instead of sniffing connections and protocols to figure out what is going on.Axis uses Apache commons logging for logging which in turn provides a […]

Checkpoints for fixpack and addon installation

Many customers I work with use a procedure like this one to clone Maximo environments between production, test and development environments. When you use such techniques, you may quickly screw up some settings used during installation of Maximo fixpacks and upgrades.Here are some important things to check before installing any release, fixpack or add-on. Maximo […]

Scroll to top