In a previous versions of the Web Sphere did observe the messaging engine behavior when after the fail over, it couldn’t obtain an exclusive lock and register in SIBOWNER table because the the failed server kept holding lock on a data store. That would lead to cluster restart and application down time. In new WAS8.5 the option “ Restrict long running locks” was introduced and the algorithm used behind ths future allows the switch phase to be quick with no service interruption Please see the attached screen shot fro location of... [More]
Yes it is possible and the best way is to take the offline backup of the source database db2 “backup database maximo to <directory> include logs” then on the target server. db2 “restore database maximo from <directory > taken at <timestamp> redirect generate script maximo.clp “ and then execute the generated maximo.clp sript The restore will autocratically upgrade maxmo database from v9.7 to v10.5 I hope this is helpful. P.S For more details please use this link: ... [More]
Today I am putting this blog together to provide a little information on VMMSync and LDAPSync, two methods used to bring users from a directory server into Maximo. There are two directory servers that are supported, MSAD - (Microsoft Active Directory) and TDS (Tivoli Directory Server). LDAPSYNC process was developed to copy user data from the Active Directory LDAP server to the Maximo table structures and enable authentication to Maximo. This tool communicates directly with the Active Directory and uses straight Active Directory queries... [More]
I didn't want August to end without a blog entry. I had lined up several projects to work on during the month. Unfortunately, I was unable to complete any of them. I concluded that one of them (pulling user, groups and group membership information from Maximo into Microsoft Active Directory) was too narrowly focused. Another one (configuring SSL on WebSphere) was missing an important element: it doesn't require making any changes to Maximo itself. It was too broadly focused, and not of particular interest specifically to... [More]
Please use the fallowing string to start a workflow that would change the workorder staus for workorderid 37 http://192.168.1.8:9080/maximo/rest/mbo/workorder/37?&_lid=maxadmin&_lpwd=maxadmin&wfname=TEST Workflow TEST must have NO interactions.
It is important to maintain a good health of the database and run Reorganization Utility on tables and indexes to help Optimizer keep the best access path. So please run the following sql that would build an executable statements that need to be run to provide a report. Build statement: select 'reorgchk update statistics on table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,50),';' from syscat.tables where type = 'T' and tabschema='MAXIMO' Sample of the executable statement: reorgchk update... [More]
Please use the fallowing sql that would create ALTER statements then execute them SELECT 'ALTER TABLE '||TBNAME||' ALTER COLUMN '||NAME||'SET DATA TYPE '||'VARGRAPHIC'||'('||LENGTH||')'||';' FROM SYSIBM.SYSCOLUMNS where TBCREATOR ='MAXIMO' AND COLTYPE='VARCHAR'
Over the years I have had several clients state that they attempted to synchronize the Nodes from the WebSphere Console and were unsuccessful. If you are unable to sync the Nodes from within the WebSphere console than you can do this manually. Here are the steps to manually sync the Nodes. Make sure CellManager service is started and Nodeagent service is stopped. (StopNode.bat) Open a command prompt window and cd to C:\Program Files\IBM\WebSphere\AppServer\bin and run syncnode hostname and then you will get prompted for... [More]
In most of the core Maximo applications, the process of changing status of a record is fairly standard. Usually, the record starts it's life in WAPPR (Waiting for Approval), DRAFT or INACTIVE. You have a Change Status Toolbar button and you can proceed to change the status as per the options available in this Change Status dialog. There are some applications however, where the process of changing status is different and a bit more complicated to the one mentioned above. In this blog entry, I am going to show you an example where a... [More]
Building an Alter statement SQL when need to change the column's definition from VARCHAR to VARGRAPHIC for all columns in maximo database SELECT 'ALTER TABLE '||TBNAME||' ALTER COLUMN '||NAME||'SET DATA TYPE '||'VARGRAPHIC'||'('||LENGTH||')'||';' FROM SYSIBM.SYSCOLUMNS where TBCREATOR ='MAXIMO' AND COLTYPE='VARCHAR' Use the output of the above SQL and run it .
Steps to run eAudit, eSig and others Database Configuration reports without grating full access to the application. It is possible to run Database reports without granting FULL access to Database Configuration app. However, you have to grant at least a Read Access to Database Configuration application. Please follow this steps. 1. Go to Application Designer application and bring up CONFIGUR app. 2. Click Select Action -> Add/Modify Signature Options 3. Find the READ option and remove the values from "Option Also... [More]
IBM Maximo Asset Management and Tririga newsletters. These communications are designed to help you derive maximum value from your software by providing you with helpful e-Support technical information, answers to frequently asked questions, and links to other key information. Please take a moment to read through the materials provided below. We are confident that you will find these resources helpful and informative. http://ow.ly/oIdKg - Maximo Asset Management http://ow.ly/R11cw - Tririga
If you want to use another server as file server and mapping doclinks to an UNC path in this environment - Windows Servers - WebSphere platform please follow below steps: 1. Create a service account or account that exists on both Maximo /HTTP Server and File Server where Doclink files are to be stored. 2. Edit WebSphere application server for Maximo, WebSphere nodeagent for Maximo, and IBM HTTP Server in the Windows-Services panel. From its 'Log On' tab, click 'This account' , input the username and password... [More]
Sometimes the fields that you would like to show in the inbox are not always available from the inbox portlet in Start Center. In that case, you might want to use a relationship to display the extra field. Below are the steps to add the schedule start date from the Changes application to the workflow inbox: 1. Go to Database Configuration application Bring up WFASSIGNMENT object Go to Relationships tab Click New Row to add a new relationship called CHANGEWFASSIGNMENT Child object should be WOCHANGE Where Clause... [More]