IBM Support

Supported platforms for IBM Data Server Manager

Technote (FAQ)


Question

Supported platforms for IBM Data Server Manager

Answer


The pages listed supported platforms for IBM Data Server Manager, it supports IBM Db2, IBM Db2 for z/OS, IBM Big SQL, IBM Db2 on Cloud, IBM Db2 Warehouse, IBM Db2 Warehouse on Cloud and offers unique features for each of the products.

IBM Db2


    Data Server Manager provides advice on when/what to convert from row-to-column-organized tables to take advantage of the breakthrough performance that Db2 with BLU Acceleration offers. Other benefits to help you reduce data management complexity and increase operational efficiency include:

    Reduce data management complexity

    • Deliver applications faster with ground-to-cloud data services
    • Resolve performance problems quickly with simple visual explain and query tuning capabilities.
    • Monitor managed clients and locate the exact source of problem with end-to-end time breakdown, detailing the time spent in each layer for each component such as the client driver or network.
    • Determine the root cause of problems using interactive diagnostic dashboards for trend and root cause analysis with the ability to drill down for more detailed, resource-specific information.
    • React immediately to new problems using the critical information that configurable alerts, Simple Network Management Protocol (SNMP) traps and email notifications provide.
    • Simplify database administration, including Db2 database partitioning feature (DPF) and IBM Db2 pureScale® topologies, using built-in wizards and enterprise-ready infrastructure.

    Increase operational efficiency
    • Manage broad data infrastructures with enterprise scale oversight and guidance.
    • Improve manageability with centralized data models and client inventory for controlling, migration planning and problem determination.
    • Track and optimize client/server environment, including workload balancing properties in Db2 pureScale systems, to enforce best-practice configuration settings from anywhere, anytime.
    • Alert developers automatically of deviations from best-practice configuration settings for compliance. And, prevent problems from insights into operations with scalable historic persistence.
    • Optimize storage requirements by finding trapped storage, infrequently accessed objects and compression opportunities.

    Meet Service Level Agreements
    • Optimize query performance and prevent bottlenecks with expert guidance – from investigation to action.
    • Make effective decisions faster via interactive computing with content assist, smart edits, debug and deploy support.
    • Enable DBAs of different skill levels to review and tune queries with actionable advice and smart alerts on poorly performing queries, missing index, or buffer pool hit ratio based on trends, statistics and thresholds.
    • Identify storage hot spots and savings opportunities with smart alerts.
    • Meet performance and availability objectives by isolating misbehaving client connections within a Db2 pureScale group or routing them across data servers.
    • Solve performance problems faster with automated responses to alerts through user-defined jobs and expert tuning recommendation on problematic or high-cost workloads.
    • View estimates of performance improvements using what-if analysis to test indexes virtually before creating them.
    • Improve performance with precise recommendations on shadow and column-organized tables, statistical views, materialized query tables (MQTs), multidimensional clustering and redistribution of data over database partitions.

IBM Db2 for z/OS

    IBM Data Server Manager offers advanced capabilities with centralized configuration management available in the Db2 Administration Solution Pack for z/OS. Db2 Query Workload Tuner for z/OS takes advantage of Data Server Manager architecture as an individual product or component of the Db2 Performance Solution Pack for z/OS.

    Advanced configuration management capabilities in the Db2 Administration Solution Pack enable you to build an inventory of Db2 for z/OS data servers and clients, and centrally manage configurations to help you reduce operational costs:

    • Build data server and client inventory quickly for configuration problem determination and migration planning.
    • Enforce best practice configuration settings continually to avoid outages and receive automated alerts on deviations to aid in resolution and compliance.
    • Optimize workloads dynamically so z® System resources are efficiently utilized

    Db2 Query Workload Tuner provides advanced guidance and tuning recommendations to help you improve performance of single queries to entire query workloads. You can maximize application performance, reduce specialized skill requirements and lower total cost of ownership for Db2 for z/OS:
    • Simplify and expedite query tuning by creating workloads for iterative tuning and testing indexes virtually without consuming resources such as CPU utilization.
    • Improve performance with guidance to help you improve query design, statistics quality, index value and more.
    • Speed up tuning with guidance on the entire tuning process. A tuning wizard from the query tuning dashboard guides you from the capture to recommended tuning actions of individual SQL statements to complete workloads from multiple sources.
    • Resolve problems quickly with several tuning advisors offered to analyze SQL statements or entire workloads, and provide specific recommendations. The Statistics advisor makes recommendations to collect necessary statistics including missing, conflict, and obsolete statistics. The Index advisor provides expert recommendations to optimize indexes, including new indexes, modification of existing indexes and dropping of unused indexes.
    • Get recommendation from IBM Db2 Analytics Accelerator Advisor on which tables to offload to the Accelerator or retain in Db2. You can easily discover the queries that are eligible/ineligible for acceleration or candidates for rewrite.
    • Increase efficiency and lower costs using a collaborative platform that reduces specialized skill requirements and integrates with other Db2 for z/OS tools.

IBM Big SQL

    IBM Data Server Manager is offered with IBM Big SQL to help you:

    Reduce data management complexity

    • Simplify real-time monitoring with BigSQL integration
    • Resolve performance problems faster with familiar visual explain and query tuning capabilities

    Increase operational efficiency
    • Accelerate application development and deployment with browser based tools for on premises, hybrid or cloud services
    • Maintain compliance with enterprise security policies and easily extend access to new users with built-in Knox support

    Meet Service Level Agreements
    • Make effective decisions faster via interactive computing with content assist, Smart edits, debug and deploy support
IBM Db2 on Cloud, IBM Db2 Warehouse, IBM Db2 Warehouse on Cloud

    IBM Data Server Manager provides enterprise management capabilities on IBM Db2 on Cloud, IBM Db2 Warehouse, IBM Db2 Warehouse on Cloud.

    Reduce data management complexity
    • Common user experiences on database monitoring and administration.
    • Determine the root cause of problems using interactive diagnostic dashboards for trend and root cause analysis with the ability to drill down for more detailed, resource-specific information.
    • React immediately to new problems using the critical information that configurable alerts, Simple Network Management Protocol (SNMP) traps and email notifications provide.

    Increase operational efficiency
    • Manage broader data sources on premise, hybrid and cloud services with integrated status, KPIs and Alerts.
    • Automatically drill down to individual IBM Db2 Warehouse console without broken of the workflow.

Document information

More support for: IBM Data Server Manager

Software version: 2.1.2, 2.1.3, 2.1.4, 2.1.5

Operating system(s): AIX, Linux, Windows

Software edition: All Editions

Reference #: 2000006

Modified date: 19 January 2018


Translate this page: