1429 - 可视化您的 Db2 环境.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025#1429Tom CrockerRocket Software1429-Visualizing Your Db2 EnvironmentAgenda0102030405Why VisualisationDb2 and Db2 Tools dataData Streamed by Db2 ToolsDelivery MethodExamplesIBM TechXchange|2025 IBM CorporationDb2 Tools are great but every tool has its own scope

2、3IBM TechXchange|2025 IBM Corporation1500+metricsDb2 for Db2 for z/OSz/OSConsole Console MessagesMessagesTraces Traces Db2 LogsDb2 LogsControl Control BlocksBlocksRealtime Realtime StatsStatsUtility Utility HistoryHistoryDb2 Db2 CatalogCatalogQuiet and busy timesSQL and object activityIBM OMEGAMON P

3、E for Db2IBM Db2 Log Analysis ToolIBM Db2 Automation ExpertIBM Db2 Query MonitorClosing the gap between monitoring and dashboarding Captures metrics from OMEGAMON agents(Db2 and other)in near real-time Feeds platforms such as IBM Instana,Grafana,Elastic,Splunk,etc.Also leveraged by other IBM Db2 Als

4、o leveraged by other IBM Db2 ToolsTools Runs on z/OS with optional component off-platformIBM TechXchange|2025 IBM Corporation4IBM OMEGAMON Data Provider(ODP)IBM OMEGAMON Data Provider(ODP)IBM OMEGAMON Data Requester(ODR)IBM OMEGAMON Data Requester(ODR)Specific to OMEGAMON family of products Focuses

5、on Grafana infrastructure Provides Grafana plugin for visualization of OMEGAMON real-time metrics in Grafana dashboards Customizable sample dashboards Relies on existing OMEGAMON infrastructure on z/OSIBM OMEGAMON Data Provider OverviewIBM TechXchange|2025 IBM Corporation5OMEGAMON Data Broker:fed by

6、 OMEGAMONs and other Db2 ToolsOMEGAMON Data Connect:target specific data transformation and forwardingStreaming Data by Db2 ToolsSummary Metrics streamed by intervalEvents(on occurrence)Negative SQLCODESExceptionsNew REST API unlocks your dataReal Time Statistics(temporal RTS not required)Db2 Utilit