Diagnostic Tool
App Diagnostic Utilities
| Name | Description | Used For |
|---|---|---|
| Flame Graphs | A simple profiling (for IBM Internal Only). | app jvm/pod slowness and high cpu |
| IBM Health Center | A java profiling tool | app jvm/pod slowness and high cpu (offering more detailed insights beyond Flame Graphs) |
| Maximo Perfmon | Maximo Activity Dashboard Note: Enabling PerfMon may significantly degrade server performance Recommend for a single user with Dev/Test env only |
Maximo UI Activity Tracing |
| MAT | MemoryAnalyzer | JVM Dump Analysis |
| HTTP Archive Viewer | HAR Analysis - for web page and client side (browser) performance | Maximo API and UI Activity Tracing |
| Maximo Ping Test Utility | A maximo ping service to idenify the timeout limit. | Detect the transacton timeout limit E.g. external gateways |
DB Diagnostic Utilities
| Name | Description | Used For |
|---|---|---|
| DBTest | A simple utility that can run in the MAS Manage Pod for measuring SQL execution time, database network latency, and data fetching duration. | - identify the network issue between db and UI test - execute the query |
| maximocpi-db | An utility to collect db metrics, test network latency and execute sql | - collect db configurations and metrics - identify the network issue between db and UI test - execute the query |
| IBM DSM | DB2 Troublshooting tool | - Historical and Realtime Troubleshooting |
| db2top and other cmds | DB2 Troublshooting commands | - Realtime Troubleshooting |
| AWR, StatsPack | Oracle DB Troublshooting | - collect db metrics and performance diagnosis |
Misc
| Name | Description | Used For |
|---|---|---|
| Poor SQL | Online SQL Formatter | Format SQL with an elegant presentation. |
| SSL Shopper | Online certificate decode tool | decode the certificate |
| Squirrl | Universal SQL Client | SQL Execution, SQL Explain... |
| mongotop, mongostat | MongoDB Realtime Troubleshooting | troubleshoot mongodb performance e.g. slow queries |
| sar | a system command be used to monitor system resources like cpu, memory, disk, network... | troubleshoot the storage class performance |