Exploring IBM Db2 for z/OS Continuous Delivery

Exploring IBM Db2 for z/OS Continuous Delivery

by Chris Crone
Released March 2018
Publisher(s): IBM Redbooks
ISBN: 9780738456713

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

This IBM® Redpaper™ publication provides key information about continuous delivery in IBM Db2® 12 for z/OS®. It discusses how continuous delivery works and the changes that have been made in Db2 12 to support continuous delivery, such as adding a new catalog table and changing existing catalog tables. Also the paper covers the effects on applications and how to take advantage of new function provided using the continuous delivery model.

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. Continuous delivery for Db2 12 for z/OS
    1. 1.1 Why continuous delivery
      1. 1.1.1 Proposals for implementing continuous delivery
      2. 1.1.2 The strategy
    2. 1.2 Migration from Db2 11 to Db2 12
      1. 1.2.1 Function levels
      2. 1.2.2 Relationship between code levels and function levels
      3. 1.2.3 Relationship between a function level and APPLCOMPAT
      4. 1.2.4 Catalog levels
      5. 1.2.5 Migrating Db2 11 data sharing groups to Db2 12
    3. 1.3 New function activation beyond base Db2 12 capability
      1. 1.3.1 Activate new function without catalog changes
      2. 1.3.2 Activate new function with catalog changes
      3. 1.3.3 Activate new function with catalog change while skipping function levels
      4. 1.3.4 Function activation of previous level (* mode)
      5. 1.3.5 SYSLIB.SYSLEVELUPDATES table
      6. 1.3.6 Additional table changes
    4. 1.4 DISPLAY GROUP command
      1. 1.4.1 DISPLAY GROUP (coexistence): From Db2 12 member
      2. 1.4.2 DISPLAY GROUP (new function not available)
      3. 1.4.3 DISPLAY GROUP (New Function Active)
      4. 1.4.4 DISPLAY GROUP (after CATMAINT)
    5. 1.5 Function level adoption preferred practices
    6. 1.6 APPLCOMPAT adoption preferred practices
  5. Chapter 2. Changes in Db2 12 affecting applications and more
    1. 2.1 Application considerations
      1. 2.1.1 The behavior of SQL, DDL, and DCL in Db2 12
      2. 2.1.2 Dynamic SQL, DDL, and DCL
    2. 2.2 New built-in global variables
      1. 2.2.1 PRODUCTID_EXT
      2. 2.2.2 CATALOG_LEVEL
      3. 2.2.3 DEFAULT_SQLLEVEL
    3. 2.3 The IBM Data Server Driver
      1. 2.3.1 The ClientApplCompat keyword
      2. 2.3.2 What the clients see after Connect
      3. 2.3.3 SQLCA and GET DIAGNOSTIC impacts
      4. 2.3.4 DDF commands and messages
  6. Chapter 3. Db2 12 documentation: Information in a new way
  7. Chapter 4. Final thoughts on continuous delivery
  8. Related publications
    1. IBM Redbooks
    2. Online resources
    3. Help from IBM
  9. Back cover

Product information

  • Title: Exploring IBM Db2 for z/OS Continuous Delivery
  • Author(s): Chris Crone
  • Release date: March 2018
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738456713