Installing and Configuring IBM Db2 AI for IBM z/OS v1.4.0

Installing and Configuring IBM Db2 AI for IBM z/OS v1.4.0

by Tim Hogan, Lydia Parziale, Guanjun Cai, Janet Figone
Released January 2022
Publisher(s): IBM Redbooks
ISBN: 9780738459837

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Artificial intelligence (AI) enables computers and machines to mimic the perception, learning, problem-solving, and decision-making capabilities of the human mind. AI development is made possible by the availability of large amounts of data and the corresponding development and wide availability of computer systems that can process all that data faster and more accurately than humans can.

What happens if you infuse AI with a world-class database management system, such as IBM Db2®? IBM® has done just that with Db2 AI for z/OS (Db2ZAI).
Db2ZAI is built to infuse AI and data science to assist businesses in the use of AI to develop applications more easily. With Db2ZAI, the following benefits are realized:


  • Data science functionality
  • Better built applications
  • Improved database performance (and DBA's time and efforts are saved) through simplification and automation of error reporting and routine tasks
  • Machine learning (ML) optimizer to improve query access paths and reduce the need for manual tuning and query optimization
  • Integrated data access that makes data available from various vendors including private cloud providers.

This IBM Redpaper® publication helps to simplify your installation by tailoring and configuration of Db2 AI for z/OS®. It was written for system programmers, system administrators, and database administrators.

Table of contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  4. Chapter 1. Architectural overview
    1. 1.1 Introduction
      1. 1.1.1 Other features and benefits
  5. Chapter 2. Road map for planning to installing
    1. 2.1 Order of installation
  6. Chapter 3. Planning
    1. 3.1 IBM Z capacity planning
    2. 3.2 Software prerequisite overview
    3. 3.3 Software installation prerequisites
    4. 3.4 User types and roles
  7. Chapter 4. Security and configuration considerations
    1. 4.1 IBM Watson Machine Learning for z/OS user ID
      1. 4.1.1 Allocating other required user IDs for WML for z/OS base
    2. 4.2 Configuring a keyring-based keystore (JCERACFKS) for user authorization
    3. 4.3 Configuring security for Db2ZAI
      1. 4.3.1 Allocating system resources for the Db2ZAI user ID
      2. 4.3.2 Configuring a keyring-based keystore for Db2ZAI SSL communications and for user authorization
      3. 4.3.3 Defining users for RACF
      4. 4.3.4 Enabling PassTicket support for Db2ZAI
  8. Chapter 5. Installation, customization, and configuration
    1. 5.1 Installing IBM Open Data Analytics for z/OS
      1. 5.1.1 SMP/E considerations and options
      2. 5.1.2 Installing user ID
      3. 5.1.3 Installation steps
      4. 5.1.4 Installing all maintenance packages
    2. 5.2 Installing IBM Watson Machine Learning for z/OS base
      1. 5.2.1 Configuring ports for WML for z/OS base
      2. 5.2.2 Configuring user authentication
      3. 5.2.3 Configuring WML for z/OS base
      4. 5.2.4 Configuring WMLz base for scoring services
      5. 5.2.5 Configuring WML for z/OS base for high performance
      6. 5.2.6 Configuring a WMLz base cluster for high availability
    3. 5.3 IBM Db2 AI for z/OS
      1. 5.3.1 Installing and deploying IBM Db2 AI for z/OS
      2. 5.3.2 Specifying GRANT privileges for configuring the Db2ZAI metadata
      3. 5.3.3 Configuring the Db2 database for Db2ZAI
      4. 5.3.4 Configuring the Db2ZAI network ports
      5. 5.3.5 Configuring Db2ZAI metadata
      6. 5.3.6 Authorizing users for Db2ZAI
      7. 5.3.7 Configuring the SMTP server
      8. 5.3.8 Configuring Db2ZAI for high availability
  9. Chapter 6. Administration and maintenance
    1. 6.1 Starting and stopping IBM Watson Machine Learning for z/OS base
    2. 6.2 Migrating from IBM Watson Machine Learning for z/OS base
    3. 6.3 Migrating from IBM Db2 AI for z/OS
      1. 6.3.1 Migrate from IBM Db2 AI for z/OS 1.3.1 to IBM Db2 AI for z/OS 1.4.0
      2. 6.3.2 Migrate from IBM Db2 AI for z/OS 1.4.0 to IBM Db2 AI for z/OS 1.4.0 APAR PH38247
      3. 6.3.3 Administering IBM Db2 AI for z/OS
      4. 6.3.4 Specifying GRANT privileges for configuring the Db2ZAI target pseudo-catalog
      5. 6.3.5 Creating target connections
      6. 6.3.6 Adding user connections
      7. 6.3.7 Editing target connections
      8. 6.3.8 Configuring alerts
      9. 6.3.9 Managing the Db2ZAI catalog
      10. 6.3.10 Starting Db2ZAI on the target Db2
      11. 6.3.11 Starting and stopping Db2ZAI
      12. 6.3.12 Viewing Db2ZAI connections
      13. 6.3.13 Viewing the Db2ZAI connection overview
      14. 6.3.14 Checking the status of the Db2ZAI services
      15. 6.3.15 Viewing service documentation
      16. 6.3.16 Scheduling Db2ZAI table cleanups
      17. 6.3.17 Changing the settings for system assessment concurrency
      18. 6.3.18 Integrating vendor data into Db2ZAI
      19. 6.3.19 Updating keyring information for Db2ZAI
    4. 6.4 Troubleshooting IBM Db2 AI for z/OS
      1. 6.4.1 Viewing Db2 connection logs in Db2ZAI
      2. 6.4.2 System assessment logs
      3. 6.4.3 Db2ZAI support services logs
      4. 6.4.4 Db2ZAI user interface logs
  10. Related publications
    1. IBM Redbooks
    2. Online resources
    3. Help from IBM
  11. Back cover

Product information

  • Title: Installing and Configuring IBM Db2 AI for IBM z/OS v1.4.0
  • Author(s): Tim Hogan, Lydia Parziale, Guanjun Cai, Janet Figone
  • Release date: January 2022
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738459837