SSUVRQ_1.1.0 - Documentation Index

Table of Contents

• Welcome
• Overview
  • Architecture
• Preparing for installation
  • Software requirements
  • User types and roles
  • System capacity requirements
  • Required Db2 privileges
• Installing and configuring the IBM Z Database Assistant solution
  • Obtaining the IBM Z Database Assistant code
  • Installing the Assistant chat
    • Troubleshooting the Assistant chat installation
  • Installing the IBM Z Database Assistant user interface
  • Assigning the IBM Z Database Assistant network ports
  • Creating the IBM Z Database Assistant home directory
  • Allocating system resources for the IBM Z Database Assistant started task ID
  • Creating the IBM Z Database Assistant metadata catalog and granting privileges to the IBM Z Database Assistant metadata scheduler ID and metadata end user IDs
  • Configuring security for IBM Z Database Assistant
    • Configuring a keyring-based keystore for IBM Z Database Assistant SSL communications and for user authorization
    • Enabling PassTicket support for IBM Z Database Assistant
    • (Optional) Using an MFA-enabled user ID with IBM Z Database Assistant
  • Configuring IBM Z Database Assistant
  • Starting IBM Z Database Assistant
  • Creating a IBM Z Database Assistant target catalog and granting privileges to the IDs that require access to the IBM Z Database Assistant target catalog
  • Creating a target connection
  • Authorizing access to the IBM Z Database Assistant user interface and features
• Working with Db2 databases
  • Getting started with Db2 databases
    • Connecting to Db2 subsystems
    • Exploring the Db2 catalog
    • Editing and running SQL statements
    • Optimizing new SQL queries
    • Running Db2 commands
    • Using the Assistant chat with Db2
  • Monitoring Db2 system health at a glance
  • Optimizing SQL performance
    • Updating SQL tuning settings
    • Scheduling SQL optimization tasks
    • Manually starting an exploration
    • Canceling an SQL optimization exploration process
    • Evaluating SQL performance
    • Deploying recommended access paths
    • Manually resolving access path regressions
    • Improving query performance using index recommendations
    • Rewriting queries to improve their performance
  • Assessing the health of Db2 systems
    • Setting up IBM Z Database Assistant for Db2 system assessments
      • Defining work periods for Db2 system assessments
      • Scheduling training for Db2 system assessment
      • Scheduling Db2 system assessments
    • Evaluating Db2 system performance using system assessments
      • Evaluating exception details for a system assessment in a table view
      • Evaluating a system assessment's exception details in a tree view
      • Analyzing a system assessment's key workload metrics
      • Checking exception types and categories used in a system assessment
      • Analyzing the data for an exception-related metric
      • System assessment table column descriptions
    • Running an on-demand Db2 system assessment
    • Restarting an on-demand system assessment
  • Understanding performance insights
    • Investigating system performance
    • Customizing system performance reports
    • Investigating System assessment exception trends
  • Working with Db2 by using the Assistant chat
    • Obtaining Db2 subsystem information
    • Tuning SQL queries
    • Generating SQL statements
    • Exploring user access
    • Comparing DDL statements
    • Analyzing locking and suspension activity
    • Asking general questions about Db2
  • Working with Db2 Analytics Accelerator by using the Assistant chat
    • Working with Db2 Analytics Accelerator
    • Getting accelerator status and configuration
    • Monitoring accelerator health and performance
    • Checking table synchronization and changes
    • Managing IDAA tables
    • Generating SQL statements for Db2 Analytics Accelerator catalog tables
• Working with IMS databases
  • Connecting to IMS systems
    • Configuring IMS Connect timeout values
  • Exploring IMS databases
  • Running IMS commands
  • Working with SQL
  • Working with IMS by using the Assistant chat
    • Exploring IMS databases and running commands
• Using the Assistant chat
• Administering
  • Stopping the Liberty and Node.js servers with started task procedures
  • Stopping the Liberty and Node.js servers from USS
  • Changing the IBM Z Database Assistant Spark settings
  • Scheduling IBM Z Database Assistant table cleanups
  • IBM Z Database Assistant tables that require cleanup
  • Checking the status of the Db2 services
• Commands
  • -DISPLAY ML (Db2)
  • -START ML (Db2)
  • -STOP ML (Db2)
• Collecting service documentation
• Notices