A fix is available
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 August 2017