DB2 Cost Base Optimizer in AN algorithm that identifies the quickest access path to the data based on information stored in DB2 Catalog. Maximo SQL’s are dynamic that means that path is evaluated before execution for each stamen being executed and every time the statement runs. So, it is time consuming and expensive ( CPU) procedure. I many cases using REOPT(ONCE) could improve maximo performance. This option tells the Optimizer to calculate the access path only once upon first execution of the statement. Steps to take... [More]
Following up from yesterday's post , let's set up the JMS Queues. 1. Persistent Stores a. Log into the Admin Server b. Click Lock & Edit c. On the left-hand side, go to Services > Persistent Stores From the New popup, select Create FileStore and enter the following information: Name: sqinstore Target: maximoserver Directory: C:\Oracle\Filestore (or the location of your choice) Click OK From the New popup, select Create FileStore and enter the... [More]
We have had some customers ask if MS Office 2016 supported with Maximo 7.5.x and 7.6.x? . Short answer, MS Office 2016 is currently not supported as it has not been fully tested with Maximo. However, if you really still want to use MS Office 2016, you will notice some of the functions in Maximo such as the download list will not work nicely and not allow you to open it like previously. You may get errors like this, when trying to open the downloaded list from Maximo in Excel.. This is because with MS office 2016, a feature called Extension... [More]
For those who tuned in yesterday, hello again! For those just joining us, take a look at that post to catch up . Note: Because this entry was too short, I updated this entry to including configuring WebLogic configuration for Maximo. A. Creating a WebLogic Domain 1. Start Configuration Wizard C:\Oracle\Middleware\Oracle_Home\wlserver_12.1\common\bin\config.exe 2. Create Domain Change domain name to maximoserver. Click Next. 3. Templates Keep only Basic WebLogic Server Domain -... [More]
Welcome to another of my multi-parters! This one will be somewhat complex. Not Maximo installation, but, of course, the order of installation. There are five parts: Part 1. WebLogic installation done. Part 1.5 Install Maximo Asset Management 7.6.0 done. Part 2. Configure WebLogic Part 3. Create JMS and email listener queues Part 4. Configure Maximo Asset Management 7.6.0 Part 5. Deploy the Maximo ear files to WebLogic Parts 1 and 1.5 are below, nice and short. Since IBM includes WebSphere 188.8.131.52 with Maximo 7.6, the... [More]
Trouble rendering Microsoft Office attachments in Maximo, selecting attached filed to open. You may face a scenario where when opening an attachment for a work order that is Word or Excel, it opens in the browser which does not render it correctly. These attachments used to open outside of the browser in the correct Microsoft Office application and render correctly. Picture this scenario : As an overview, Maximo users open a work order, select an attachment to open, and it opens in the... [More]
The TASKSCHEDULER table is used by Maximo to control the schedule of cron jobs (escalations and crontasks) . You may wonder : Is it safe to delete entries from the TASKSCHEDULER table ? It is safe to delete those entries from the TASKSCHEDULER table. When you remove the entries from the table Maximo will add themselves back according to the schedule information from the active crontasks present in the system. Sometimes the recommendation to solve a problem with a crontask or escalation is to remove the records from the... [More]
And then you are working with your Maximo environment database, and decide to run the following query in the database : SELECT count(distinct(maxuser.userid)) user_count, applicationauth.app, maxapps.description, ml.module, ml.description module_description FROM applicationauth INNER JOIN maxmenu ON applicationauth.app=maxmenu.keyvalue INNER JOIN groupuser ON applicationauth.groupname=groupuser.groupname INNER JOIN maxuser ON groupuser.userid=maxuser.userid INNER JOIN maxapps ON... [More]
Have you ever wondered if it's possible to see the children Asset attachments also in the parent Asset? If so, you have to follow this steps. For you to be able to see the children attachments in the parent asset you have to add a where clause to the relationship. Please do the following steps: 1. Go to Database Configuration application 2. Bring up ASSET object 3. Select the Relationships tab and filter by DOCLINKS 4. Add the following to the end of the relationhip: or (ownertable = 'ASSET' and ownerid in (select... [More]
When a person's Locale is set to RU, the History flag and all Yes/No flags in the system are displayed as question marks in the Advanced Search screen in applications. When locale is set to RU, there are two System Properties that must be set. 1. Go to System Properties application. 2. Find the "setting.YES_RU" property. 3. Set the global value as image below. 4. Find the "setting.NO_RU" property. 5. Set the global value as image below. 6. Do a Live Refresh.
If you experience a scenario where you cannot view or edit Long Description fields in Maximo, the icons are greyed out and you cannot add any text to this any long description field you could be having a bad day or there some configuration issue needs adjustment. Many of your records have a long description, but you cannot see them. What could be happening ? Well, there are some suggestions you can try. Let's take as an example the Assets application. Follow these steps : 1. Go Application Designer app, and... [More]
For those of you not yet familiar with our free (Yes, FREE!) modular Maximo education - I would definitely say 'go and check it out'! Our courses have been designed to keep you up to date on the latest features in your IBM IoT solutions. They also include best practices and practical simulations. We currently have 17 Maximo related sessions, ranging from "Maximo 7.6 - Introduction and Overview" to "7.6 - Corrective Maintenance Work", to "Maximo 7.6 - Infrastructure and Implementation Certification... [More]
Just wanted to let everyone know that we posted the integration-related materials from the conference on the MIF wiki page https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20Maximo%20Asset%20Management/page/Integration%20Framework Scroll down to the bottom of the Integration Topics list - you will find a link to a .zip file that contains presentation/lab materials. Additionally you will find links in the Topics list for documentation on the JSON API and the Federated Resource that we covered in two of the MIF... [More]
Recently I have had a few clients inquire about the possible values for Login Tracking in Maximo and what they mean. So here is a summary of the possible values. For the Attempt Result in Login Tracking (Logintracking.AttemptResult), here are the following possibilities and their meaning: FAILED -- Failed login or electronic signature authentication attempt. LOGIN -- Successful user login. LOGOUT -- User logout. SYSLOGOUT-- Session timed out by Maximo... [More]
How do you add a secondary language to your Maximo 7.6 environment? 1) Using Tivoli Process Automation Suite Configuation Tool Usually, the easiest most straight forward method. Under Deployment Options section, choose the option to 'Add additional languages' and simply go through the screen to have this installed. 2) Using command line interface However, at times, do you have restrictions with using a browser or GUI to perform certain configuration actions for Maximo 7.6.? Alternatively, you can perform the same configuration by using... [More]
With the release of Maximo 184.108.40.206 a new JSON API is available. You can find information here: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20Maximo%20Asset%20Management/page/Maximo%20JSON%20API Moving forward, we will be supporting the JSON API. We will no longer be enhancing the REST or OSLC API's.
According to our latest Product Configuration Matrix , Maximo 7.6 adds supports Google Chrome 37, and Maximo 220.127.116.11 supports Microsoft's new Edge browser, in addition to Microsoft Internet Explorer and Mozilla Firefox. These support statements require some clarification. To use Maximo applications that use applets (for example, Scheduler or Workflow Designer), you have to install a JRE or JDK, and enable the Java applet in your browser. This is usually done by downloading the JRE from Oracle and... [More]
Hi, If you want to disable 'Delete Row' button in the 'View Attachments dialog' depending on the workorder's status, you can follow below idea. At first, 'View Attachments dialog' definition is existed in library.xml because this dialog is used commonly for some applications. So, if you want to limit the scope for only WOTRACK application, you may need to have own 'View Attachments dialog' definition in WOTRACK application. Requirement : 'Delete buttion' is shown only when... [More]
This error has an error code SQLCODE=-964, SQLSTATE=57011, DRIVER=4.11.69." and means the space issue with db2 logs due to large number of transactions. To overcome the problem , please run the fallowing statements changing to number specified is usually sufficient enough for medium work load db2 UPDATE DB CFG FOR <DBNAME> USING LOGSECOND 80; db2 UPDATE DB CFG FOR <DBNAME> USING LOGPRIMARY 120; db2 UPDATE DB CFG FOR <DBNAME> USING LOGFILSIZ 4096; DB2STOP ; DB2START; Please take in configuration that... [More]
It is important to have maximo db2 database to run in ARCHIVE mode in Production environments. This configuration will allow the Roll Forward recovery option and and restore the database to the closest possible point in time before the crash. To use this future , please run db2 update db configuration for maxdb76 using logarchmeth1 disk: \\m1maxdb\c:\db2_backups\db2_logs ; Note: the disk: \\m1maxdb\c:\db2_backups\db2_logs sample path on windows OS , change it to the location you would like to have the logs saved.
Hello I thought I would write this quick Blog to Update Maximo 7.6 . We are now calling our previous versions of Maximo 7 fix packs to now be identified as Feature packs . Starting with Maximo 18.104.22.168 and future release of Maximo 7.6 will now be addressed as Feauture Packs .
Interested in learning more about The Weather Company Acquisition by IBM? Come to these Interconnect 2016 sessions: Number Title Where When 7433A Special Session: Open for Data - An Open Invitation to Help You Solve your Greatest Data Challenges The Open for Data Dome Mon, 22-Feb 03:00 PM - 04:00 PM 4852A The Weather Company: How Insurers Can Differentiate with Weather Data Mandalay Bay SOUTH - South Seas D Tue, 23-Feb 08:30 AM - 09:30 AM 1140A IBM Analytics and the IoT Bring Advanced Weather Insights to Business Mandalay Bay SOUTH -... [More]
Going to Interconnect? Don't miss out these Maximo Anywhere Sessions: Number Title Where When 1865A Maximo Anywhere—Maximo Mobility Strategy Come True! Mandalay Bay SOUTH - South Seas J Mon, 22-Feb 01:30 PM - 02:30 PM 3666A Introducing Maximo Calibration on Maximo Anywhere IoT Engagement Center Mon, 22-Feb 06:30 PM - 06:50 PM 1886A Real-Life Implementations and Extensibility of IBM Maximo Anywhere Mandalay Bay SOUTH - South Seas J Wed, 24-Feb 08:30 AM - 09:30 AM 5096A Maximo Anywhere Work and Asset Management Mobile Apps:... [More]
Are you ready for a life-changing, breath-taking, mind blowing data analysis experience??? We are and it is FABULOUS! The perfect combination of IBM's Maximo Asset Management and Watson Analytics! Watson provides user-friendly, advanced, collaborative tools to analyze exported Maximo .csv files. As a cloud-based offering, no complex installations or integrations are required. Additionally, you can utilize it in ANY Maximo or Industry Solution offering. Find out more about Watson thru..... 1. Demo... [More]
Are you ready? Did you pack your bag full of business cards, and those super comfortable socks and walking shoes? We're ready! We're super ready for InterConnect 2016 and can't wait to see you all SOON! Here's a few hints to maximize your experience and networking at InterConnect 2016! 1. Look for Maximo in Watson IoT (Internet of Things). Need a way to remember this? Try Maximo=Watson or MaxWatsonIoT or for acronoymn fans, MWIoT. : ) 2. ... [More]
Once every couple of months I will hear about our client getting the following Oracle error messages. If you get one of these errors after restoring from backup or migrating to another server, please rebuild the sequence or Recreate Triggers: 1. ORA-01400: cannot insert NULL into ("MAXIMO"."WORKPERIOD"."ROWSTAMP") RECREATE and ENABLE the TRIGGER For Example: create or replace TRIGGER WORKPERIOD_T BEFORE INSERT OR UPDATE ON WORKPERIOD FOR EACH... [More]
Hello everyone! I want to share something that I have learned regarding the Maximo Calibration 7.5 Industry Solution with you. If you are wondering if your Maximo Calibration 7.5 was properly installed or where your Calibration applications/modules in Maximo 7.5 environment, then Google search led you to the right place (or blog)! Maximo Calibation 7.5 is already included in the base code for Maximo so when you do the install of the said industry solution, you are actually just activating the license so that you can use it. There... [More]
Hello! It seems we are still receiving requests here in support about what versions of Maximo are supported with IE11. As a refresher I have attached this information below. Hopefully this will help avoid having to submit a PMR with the support team. Have a great day! Maximo support for Internet Explorer 11. Full support for Internet Explorer 11 will be made available within Maximo Asset Management fixpack 22.214.171.124. Full support is also available in Maximo Asset Management 7.6. IE11 support will not be back ported to... [More]
Hello! I wanted to share a quick problem resolution of a call (actually, Sametime messages between myself and an IBMer at a customer site) I took this afternoon. He was installing Feature Pack 126.96.36.199 for Maximo to an installation that did not have Internet access. Following my blog post on installing a Feature Pack to Maximo 7.6 , he launched IBM Installation Manager. From the Preferences menu, he selected Repositories, selected the Maximo 188.8.131.52 FP and added it to the list of... [More]