PM54508: CODE TO SUPPORT NEW FUNCTION ON V9

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Code to support new function on V9.
  IDAAV2R1/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 9 for z/OS who are also     *
  *                 using IDAA (IBM DB2 Analytics Accelerator)   *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR makes various enhancements    *
  *                      and fixes various bugs that may         *
  *                      occur when using IDAA with DB2 9:       *
  *                      - DB2 does not return correct parameter *
  *                        metadata                              *
  *                      - ABEND04E RC00E20022 in                *
  *                        DSNLAGNT.DSNSFBK+0502 and DB2 may     *
  *                        crash due to a storage leak           *
  *                      - DISPLAY ACCEL(*) MEMBER(...) may      *
  *                        display the wrong member              *
  *                      - Parameter markers queries not         *
  *                        supported for data types BIGINT       *
  *                        and SMALLINT                          *
  *                      - ABEND0C4 RC10 in DSNVDTA+521A         *
  *                      - SQLCODE -904 RC00E7000E 'Invalid      *
  *                        precision  38' may be issued          *
  *                        erroneously                           *
  *                      - SQLCODE -901 or -514 may be issued    *
  *                        erroneously                           *
  *                      - ABEND0C4 RC38 in DSNXONZC+2C5C        *
  *                        on a query referencing multiple       *
  *                        views with outer joins                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR makes various enhancements and fixes various bugs
  that may occur when using IDAA with DB2 9:
  - DB2 does not return correct parameter metadata
    For example, a JDBC program may return an invalid result for
    a query with parameter markers, such as:
    SELECT CAST(? AS INTEGER) FROM LINEITEM WHERE 1=1
    resulting in incorrect output
  - ABEND04E RC00E20022 in DSNLAGNT.DSNSFBK+0502 and DB2 may
    crash due to a storage leak
  - DISPLAY ACCEL(*) MEMBER(...) may display the wrong member
  - Parameter markers queries not supported for data types BIGINT
    and SMALLINT
  - ABEND0C4 RC10 in DSNVDTA+521A
  - SQLCODE -904 RC00E7000E 'Invalid precision  38' may be issued
    erroneously
  - SQLCODE -901 or -514 may be issued erroneously
  - ABEND0C4 RC38 in DSNXONZC+2C5C on a query referencing
    multiple views with outer joins
  
  Additional Keywords:
  IDAAV2R1/K DB2STGLK/K SQLCODE904 SQLCODE901 SQLCODE514
  SQLVIEW SQLOUTERJOIN SQLOUTER
  PARAMETERMARKER SQLPMARKER SQLPMK
  DB2INCORR/K SQLINCORR SQLINCORROUT INCORROUT
  

Problem conclusion

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

• The problems mentioned above which can be encountered when
  using IDAA with DB2 V9 are corrected.
  

APAR Information

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

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

  UK76160

Modules/Macros

• DSNLCDG1 DSNLCDP1 DSNLCITR DSNLCSRR DSNLIAAC
  DSNLIRCA DSNLISDA DSNLXCMT DSNLXCQH DSNLXMRF DSNLXRBF DSNLXRCL
  DSNLXREL DSNLXRFT DSNLXROP DSNLXRSQ DSNLXRUW DSNLZMON DSNLZRPY
  DSNLZR00 DSNLZSRM DSNLZSR2 DSNXEDP  DSNXONZC DSNX8CDA DSNX8CMD
  DSNX8STO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK76160

     UP12/02/29 P F202

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.