IBM Support

PI12614: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 4 GA UPDATE #2

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • SECOND SMP/E INSTALLABLE FOR IDAA VERSION 4.1.0
    IDAAV4R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the                             *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 4.1                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: This PTF contains stored procedure      *
    *                      and accelerator server updates that are *
    *                      part of IBM DB2 Analytics Accelerator   *
    *                      for z/OS version 4 refresh 2.           *
    *                                                              *
    *                      IDAAV4R1/K                              *
    ****************************************************************
    * RECOMMENDATION: Before installing this PTF,                  *
    *                 make sure that all prerequisites are         *
    *                 installed on your target system.             *
    *                 For information, see:                        *
    *                 http://www.ibm.com/support/                  *
    *                   docview.wss?uid=swg27039487                *
    *                                                              *
    *                 This PTF contains:                           *
    *                 Server version: 4.1.2                        *
    *                   (build: 20140414-1822)                     *
    *                 Stored procedure build: 4.1.2                *
    *                   (build: 20140313-1711)                     *
    *                                                              *
    *                 If you have not yet configured               *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 4.1, read the following manuals      *
    *                 that are all available on                    *
    *                 http://www.ibm.com/support/                  *
    *                    docview.wss?uid=swg27040146               *
    *                 - The "Getting Started" manual               *
    *                 - and the Installation Guide                 *
    *                 - and the Release Notes                      *
    *                                                              *
    *                 ATTENTION:                                   *
    *                 Prerequisite for activating this PTF:        *
    *                 1. The base package (RELFILES) for FMID      *
    *                    HAQT410 must have been applied. Do not    *
    *                    transfer or apply any software from these *
    *                    RELFILES to any accelerator.              *
    *                 2. FMID HCHCA21 must have been applied.      *
    *                 3. The IBM DB2 Analytics Accelerator Studio  *
    *                    version 4.1.0 was installed.              *
    *                 4. a. Netezza Firmware (FDT) version:        *
    *                       For Netezza models 100/1000/C1000/     *
    *                       N1001, a minimum of FDT version 2.3.1. *
    *                       For model N2001, and later             *
    *                       a minimum of FDT version 3.0.          *
    *                    b. Netezza Host Platform (HPF) version:   *
    *                       a minimum of HPF version v5.3.1.       *
    *                 5. Netezza Performance Server (NPS) version  *
    *                    higher or equal to 6.0.8.P2               *
    *                 6. DB2 PTFs and Infosphere Change Data       *
    *                    Capture Agent PTFs or ++APARs must be     *
    *                    installed for the APARs listed on         *
    *                    following prerequisites site:             *
    *                    http://www-01.ibm.com/support/            *
    *                      docview.wss?uid=swg27039487             *
    *                                                              *
    *                 Activating the PTF is a multi-step process:  *
    *                                                              *
    *                 1. Transfer and activate Incremental Update  *
    *                    parts (provided with prerequisite PTFs)   *
    *                    in the following order (unless these or   *
    *                    later versions are already installed):    *
    *                    For instructions, see the                 *
    *                    Installation Guide, Chapter 11:           *
    *                      "Installing Updates"                    *
    *                    1.Access Server update version            *
    *                       10.2.1.2221 (build date 20140414-1822) *
    *                    2.Replication Engine base                 *
    *                       version 10.2.1 (Build CCTRJYPP_20_4)   *
    *                       (build date  20140414-1822)            *
    *                    3.Replication Engine update               *
    *                       version 10.2.1 (Build CCTRJYPP_20_36)  *
    *                       (build date 20140414-1822)             *
    *                                                              *
    *                 2. Transfer and activate the software on     *
    *                    the IDAA system with the update included  *
    *                    in this PTF (unless this or a later       *
    *                    version is already installed).            *
    *                    For instructions, see the                 *
    *                    Installation Guide, Chapter 11:           *
    *                           "Installing Updates"               *
    *                                                              *
    *                 3. Activate the stored procedures included   *
    *                    in this PTF by following                  *
    *                    the steps in the                          *
    *                    Installation Guide, Chapter 6:            *
    *                           "Setting up IBM DB2 Analytics      *
    *                            Accelerator for z/OS".            *
    *                    Having completed the activation,          *
    *                    verify the configuration by following the *
    *                    steps in the Installation Guide under     *
    *                    "Verifying the installation of            *
    *                      IBM DB2 Analytics Accelerator for z/OS  *
    *                      stored procedures".                     *
    *                                                              *
    *                 4. Transfer and activate NPS (provided with  *
    *                    prerequisite PTFs) if the NPS version is  *
    *                    lower than NPS 7.0.4.3 P2 (build 35925)   *
    *                    (build date 20140331-1528).               *
    *                    The process to determine the Netezza FDT  *
    *                    and HPF versions is described in the      *
    *                    Release Notes on                          *
    *                    http://www.ibm.com/support/               *
    *                       docview.wss?uid=swg27040146            *
    *                                                              *
    *                    If the Netezza FDT and HPF version        *
    *                    prerequisites listed above are not met,   *
    *                    plan for an outage to upgrade.            *
    *                    For details, see:                         *
    *                    http://www-01.ibm.com/support/            *
    *                       docview.wss?uid=swg21626217            *
    ****************************************************************
    This PTF contains fixes for the issues described below.
    
    A detailed description for each fix can be found in the
    following support document:
    http://www.ibm.com/support/docview.wss?uid=swg27041549
    
    ================================================================
    1. What's New                                                  v
    ================================================================
    1.1 Some AQTENV environment variables can be passed as input   v
        parameter to stored procedures                             v
    ================================================================
    ****************************************************************
    ================================================================
    1.2 Data Studio Client 4.1.0.1 uses web browser for Visual     v
        Explain access plan graph                                  v
    ================================================================
    ****************************************************************
    ================================================================
    1.3 Migrating tables with the SYSPROC.ACCEL_MIGRATE stored     v
        procedure to support workload balancing                    v
    ================================================================
    ****************************************************************
    ================================================================
    1.4 Support the TIME value 24:00:00 and TIMESTAMP values with  v
        a time portion of 24:00:00.000000                          v
    ================================================================
    ****************************************************************
    ================================================================
    1.5 Support columns with a data type of CHAR FOR BIT DATA or   v
        VARCHAR FOR BIT DATA in EBCDIC tables                      v
    ================================================================
    ****************************************************************
    ================================================================
    2. Solved Problems                                             v
    ================================================================
    2.1 'Alter Keys' dialog shows incorrect column cardinality     v
    ================================================================
    ****************************************************************
    ================================================================
    2.2 Log files that contain load failure information are        v
        deleted                                                    v
    ================================================================
    ****************************************************************
    ================================================================
    2.3 Failure of DB2 Utilities called by                         v
        SYSPROC.ACCEL_ARCHIVE_TABLES or                            v
        ACCEL_RESTORE_ARCHIVE_TABLES stored procedure              v
    ================================================================
    ****************************************************************
    ================================================================
    2.4 SQL query fails with SQLCODE -904 and message 'Cannot      v
        allocate memory'                                           v
    ================================================================
    ****************************************************************
    ================================================================
    2.5 Incorrect time stamp information for incremental update    v
        capture events in the z/OS SYSLOG                          v
    ================================================================
    ****************************************************************
    ================================================================
    2.6 Function 'Clear Trace' does not delete orphaned            v
        incremental-update trace-directories                       v
    ================================================================
    ****************************************************************
    ================================================================
    2.7 The accelerator remains in state 'Initializing' or 'Down'  v
        and does not change to 'Online'                            v
    ================================================================
    ****************************************************************
    ================================================================
    2.8 Incremental update terminates abnormally                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.9 Weighted deviation of query results for REAL columns       v
        greater than 0.000001                                      v
    ================================================================
    ****************************************************************
    ================================================================
    2.10 SQL error with SQLCODE -901 and error message is lacking  v
         the table name                                            v
    ================================================================
    ****************************************************************
    ================================================================
    2.11 IBM DB2 Analytics Accelerator Studio hangs during logon   v
         to DB2 subsystem                                          v
    ================================================================
    ****************************************************************
    ================================================================
    2.12 The query history shows incomplete entries                v
    ================================================================
    ****************************************************************
    ================================================================
    2.13 Table load fails with DRDATCPIPException                  v
    ================================================================
    ****************************************************************
    ================================================================
    2.14 Table space in state 'AERO' causes AQT10131I error        v
    ================================================================
    ****************************************************************
    ================================================================
    2.15 Stored procedure SYSPROC.ACCEL_REMOVE_TABLES returns      v
         parsing error AQT10402I                                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.16 DSNX881I message requesting a restart of the accelerator  v
         (reason code 21) occurs very frequently                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.17 Stored procedure SYSPROC.ACCEL_REMOVE_TABLES returns      v
         error message AQT20009I                                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.18 Retrieving the replication event log takes unexpectedly   v
         long                                                      v
    ================================================================
    ****************************************************************
    ================================================================
    2.19 Table cannot be enabled for incremental updates           v
    ================================================================
    ****************************************************************
    ================================================================
    2.20 Enabling or disabling incremental updates for a DB2       v
         subsystem fails with timeout error                        v
    ================================================================
    ****************************************************************
    ================================================================
    2.21 Warning if the 64-bit version of Installation Manager is  v
         used for the installation of IBM DB2 Analytics            v
         Accelerator Studio                                        v
    ================================================================
    ****************************************************************
    ================================================================
    2.22 Stored procedures do not run to completion                v
    ================================================================
    ****************************************************************
    ================================================================
    2.23 IBM DB2 Analytics Accelerator Studio Version 4.1 displays v
         the message 'Value 'Initialized' is not legal'            v
    ================================================================
    ****************************************************************
    ================================================================
    2.24 SQL query fails if it contains a parameter marker that    v
         references DECIMAL columns. SQLCODE: -352, SQLSTATE:      v
         '56084'                                                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.25 Trace data lost after running dwa-verify-installation     v
    ================================================================
    ****************************************************************
    ================================================================
    2.26 Sample job AQTSJI03 fails with condition code 8 in step   v
         RMTABLE.                                                  v
    ================================================================
    ****************************************************************
    ================================================================
    2.27 IBM DB2 Analytics Accelerator Studio for z/OS extension   v
         plug-ins not installed                                    v
    ================================================================
    ****************************************************************
    Limitations:
    Users affected:
       All product users who have enabled multiple encoding and
       run SQL queries against Unicode tables that reside alongside
       EBCDIC tables on the same accelerator.
    Short summary:
       Certain DB2 for z/OS queries are incompatible with the
       product.
    Details:
       1. If the query contains a LIKE condition, and the string
          value of the condition is shorter than the value
          length of the column definition, the string value is
          padded with space characters so that its length
          matches the length of the column definition. However,
          the padding might change the string value in the query
          so that it no longer fits the purpose.
          Example: A column defined as CHAR(10) contains a
          string value "012345678". The query reads
          SELECT * FROM TABLE1 where COLUMN1 LIKE '0123456%_ '.
          The argument of the LIKE expression no longer fits its
          initial purpose because a space character is appended
          to the end of the string.
          Work-around: Use wildcards for characters at the end
          of the string, for example '0123456%' or '0123456___'.
       2. If a query contains character-based functions, such as
          RPAD(), to operate on strings in multi-byte encoding,
          DB2 for z/OS counts the bytes used by the strings,
          while the Netezza database counts the number of
          characters.
          Work-around: Add a 'CAST TO GRAPHIC' expression to the
          output SQL of the RPAD() function.
    
    Users affected:
       All users of IBM DB2 Analytics Accelerator for z/OS with
       Netezza Performance Server (NPS) 7.0.4.3 running SQL
       queries against Unicode tables that reside alongside
       EBCDIC tables on the same accelerator with multiple
       encoding function enabled
    Short summary:
       Query results differ when they are compared with results
       delivered by DB2 for z/OS.
    Details:
       1. Use of the TRANSLATE function might result in the
       truncation of space characters at the end of the result
       string.
       2. Query results differ if queries contain SUBSTRING()
       and LOCATE() functions that operate on the same table
       column.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI12614

  • Reported component name

    SMRT ANL OPT DB

  • Reported component ID

    5697AQT00

  • Reported release

    410

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-27

  • Closed date

    2014-04-16

  • Last modified date

    2014-05-02

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

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

    UI17115

Modules/Macros

  •    AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10
    AQTDBDYN AQTDBQIT AQTDBTRC AQTDBUNL AQTDBZPR AQTENV   AQTNOTE
    AQTOSR   AQTPKAP1 AQTPKAP2 AQTPKCFG AQTSCALL AQTSCI01 AQTSCI02
    AQTSJI00 AQTSJI01 AQTSJI02 AQTSJI03 AQTSJI04 AQTSSCHK AQTSSCPY
    AQTSXADD AQTSXALT AQTSXCN0 AQTSXCN1 AQTSXCN2 AQTSXCN3 AQTSXCN4
    AQTSXIM0 AQTSXQHI AQTSXSD1 AQTSXTCO AQTSXTSL AQTSXTSU AQTSXTS0
    AQTTIJSP AQT02AAC AQT02ALT AQT02ART AQT02ATB AQT02CAC AQT02CDC
    AQT02ENQ AQT02FGV AQT02FRF AQT02GQD AQT02GQR AQT02GTC AQT02GTI
    AQT02LTB AQT02PSD AQT02RAC AQT02RAT AQT02RTB AQT02STA AQT02TCO
    AQT02UCR AQT02USW
    

Fix information

  • Fixed component name

    SMRT ANL OPT DB

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R410 PSY UI17115

       UP14/04/18 P F404

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: z/OS family

Software version: 410

Operating system(s): z/OS

Reference #: PI12614

Modified date: 02 May 2014


Translate this page: