IBM Support

PI77826: DB2 11 FOR Z/OS NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • DB2 11 for z/OS new function.
    IDAAV5R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users who use IBM        *
    *                 DB2 Analytics Accelerator.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: Currently, customer data could be       *
    *                      stored in different DB2 subsystems,     *
    *                      separated by line of business or        *
    *                      location. The customer cannot use a     *
    *                      single query to reference tables from   *
    *                      from different DB2 subsystems in a non- *
    *                      datasharing environment even if all     *
    *                      tables are already offloaded into the   *
    *                      same accelerator.                       *
    *                      This APAR addresses that requirement    *
    *                      by providing the new function support   *
    *                      to allow a single query to reference    *
    *                      tables from different DB2 subsystems.   *
    *                      This APAR requires APAR PI76645 to be   *
    *                      applied together with this APAR.        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    IBM DB2 Analytics Accelerator Federation support enables
    customers to issue a single query to reference tables from
    different DB2 subsystems.
    This APAR helps in the following use cases:
    Use case 1: Each owning DB2 has a different set of tables
    (different schema/name)
    The owning DB2 subsystems are different lines of business (LOB)
    with different data set that should all be consolidated in the
    central DB2 to create the federated view.
    Use case 2: Multiple tenants - each has the same logical data
    model - are consolidated into a single federated system
    Here the referencing system conceptually wants to build a UNION
    ALL view of all tenants' tables.
    For example if owning DB2 DB2NORTH has the SALES records for
    north region and owning DB2 DB2SOUTH has the SALES records for
    south region then referencing DB2 DB2MAIN should have a UNION
    ALL view ALL_SALES that is the superset of the north and south
    sales.
    Customer can create a single UNION ALL view in the referencing
    DB2 subsystem that provides the union across all AOTs that
    reference part of the data in each owning DB2 subsystem.
    
    A new audit trace IFCID 392 has been added which will be
    written by the IBM DB2 Analytics Accelerator stored procedures
    The IBM DB2 Analytics Accelerator stored procedures will use
    IFIWRITE to generate the new DB2z audit trace record and fill
    in the required data. This trace is written when audit trace
    class 9 is on.
    This APAR also provides High Availability (HA) support for
    reference tables if the table being referenced is also in HA
    configuration. On the reference DB2 system, the reference table
    will show in SYSIBM.SYSTABLES as a table with TYPE = 'D' and in
    SYSACCEL.SYSACCELERATEDTABLES table it will show the Owner
    system location in REMOTELOCATION column. If the reference
    table is in HA configuration, there will be more than one
    entries in SYSACCEL.SYSACCELERATEDTABLES table and each one will
    show the accelerator where it is referenced at in the
    ACCELERATOR column.
    This APAR checks for the new catalog table
    SYSACCELERATEDTABLESAUTH, its index and the new
    SYSACCELERATEDTABLES.REMOTELOCATION column existence and
    definition, tolerates when they do not exist and restrict
    Insert/Update/Delete on Federated reference table. A federated
    reference table will show in SYSIBM.SYSTABLES as a table with
    TYPE = 'D' and in SYSACCEL.SYSACCELERATEDTABLES table it will
    show the Owner system location in REMOTELOCATION column.
    This APAR also changes DROP TABLE code to support Federated
    reference tables with RESTRICT ON DROP if table is a Federated
    reference table type (REMOTELOCATION column not blank) and
    delete corresponding SYSACCELERATEDTABLESAUTH record if there is
    one exists.
    
    This APAR requires PI76645 to be applied together for catalog
    changes needed for federation support
    

Problem conclusion

Temporary fix

Comments

  • IDAA Federation Support
    ADDITIONAL KEYWORDS: IDAAV5R1/K
    

APAR Information

  • APAR number

    PI77826

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-08

  • Closed date

    2017-07-06

  • Last modified date

    2017-08-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI48595

Modules/Macros

  •    DSNDQWHS DSNDQW05 DSNTIJAS DSNTXSTB DSNWAAPI
    DSNWVCOL DSNWVINT DSNWVSR1 DSNWVZPS DSNXEDSC DSNXEET  DSNXERT
    DSNXERT2 DSNXISB6 DSNXONZA DSNXONZB DSNX8CTG
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI48595

       UP17/07/25 P F707

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI77826

Modified date: 02 August 2017


Translate this page: