PI66176: IDAA: LIMITED SUPPORT FOR AOTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• IDAA - provide limited support for AOTs (GEN,DDL,DROP, and
  CatNav only).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM DB2 Analytics Accelerator       *
  *                 (IDAA) for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: This enhancement adds support           *
  *                      in DB2 Admin for the following          *
  *                      operations on Accelerator-only          *
  *                      tables (AOT):                           *
  *                                                              *
  *                      Create, Display, Drop and               *
  *                      Generate DDL.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Accelerator-only tables (AOTs) are tables whose data exists
  solely on the accelerator and offers a facility of faster
  operations (via DML statements) on accelerator data.  Queries
  referencing AOTs can only run on the accelerator and
  facilitates data manipulation like aggregation, cleansing
  etc on the accelerator, taking advantage of accelerator's
  performance.
  
  This enhancement adds support in DB2 Admin for the following
  operations on AOTs:
  
  - Create: CRE line command can be issued on Panel ADB21T
            'Tables, Views and Aliases' and accelerator name can
            be specified on ADB26CTF panel 'Create Table Columns'.
  
  - Display: Panel ADB21T 'Tables, Views and Aliases' will display
             AOTs (Type = 'D' in DB2 catalog table).
  
  - Drop: DROP line command can be issued on AOT objects on panel
          ADB21T 'Tables, Views and Aliases', to drop them from
          DB2 catalog.
  
  - Generate DDL: DDL line command can be issued on AOT objects on
                  panel ADB21T 'Tables, Views and Aliases', that
                  will generate a DDL of the selected AOT object.
  

Problem conclusion

Temporary fix

Comments

• Enhancements have been delivered.
  

APAR Information

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

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

Modules/Macros

•    ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST
  ADBCP    ADBCRCC  ADBCRCR  ADBCSPG  ADBCVC   ADBCVCT  ADBCVEY
  ADBCVIC  ADBCVOC  ADBDAT   ADBDK    ADBH1T   ADBH6CTF ADBLI
  ADBNSPB  ADBPA1   ADBTEPI  ADBTEPR  ADBTEPU  ADBTEP2  ADBVFC
  ADBVFCA  ADBVFCF  ADBV99   ADB2CDC  ADB2CID  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM1
  ADB2CM2  ADB2CM3  ADB2DEP  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2OVW
  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2RE
  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES
  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT  ADB2WCL
  ADB2WVL  ADB21T   ADB21TI1 ADB26CT  ADB26CTF ADB26CTS ADB26CUU
  ADB26DT  ADB26TOP ADB27AC  ADB28MC  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI42390

     UP16/11/19 P F611

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.