Invisible Bits of MaximoSolved
Search Maximo CLOB fields with DB2 LOCATE
Use the DB2 LOCATE function to find text inside Maximo CLOB columns such as AUTOSCRIPT.SOURCE, understand its return value and avoid expensive searches.
Series
Invisible Bits of Maximo
WebSphere, databases and the middleware behind Maximo.
29 articles
Invisible Bits of MaximoSolved
Return useful Maximo error messages from SOAP web services
Configure WebSphere fault unification so an approved SOAP client can receive the Maximo business error behind an Internal Error response.
Invisible Bits of MaximoSolved
Fix SQL2563W after restoring a DB2 database
Find which DB2 table spaces were not restored, diagnose their storage failure and rerun or redirect the restore safely.
Invisible Bits of MaximoSolved
Fix CWPKI0022E and CWPKI0428I SSL handshake failures
Add a verified HTTPS signer to the WebSphere trust store used by Maximo outbound connections.
Invisible Bits of MaximoSolved
Create a reusable read-only DB2 role for Maximo
Create a MAXIMO_RO role, generate its SELECT grants into a SQL file and assign the role to reporting users.
Invisible Bits of MaximoSolved
Fix archived DB2 logs filling the active log path
Work around a DB2 11.1.3.3 defect that can leave archived transaction logs in the active log directory until the filesystem fills.
Invisible Bits of MaximoSolved
Change a DB2 server hostname on Windows
Update a Windows DB2 instance after renaming its server without manually editing db2nodes.cfg or resetting extended security.
Invisible Bits of MaximoSolved
Size DB2 secondary transaction logs for Maximo
Measure a representative Maximo workload with temporary DB2 infinite logging, then use the peak secondary-log usage to choose a finite LOGSECOND value.