PH16668: CQD OCTOBER RELEASE 2019

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• CQD October Release 2019
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: - Abend S0C3 reading SYSLOG from        *
  *                        Virtual Tape dataset                  *
  *                      - Need Virtual Table/Map support for    *
  *                        ACF2 SMF records type 229 and 230     *
  *                      - Abend S0C4 reading OPERLOG_SYSLOG     *
  *                        with no LIMIT                         *
  *                      - Missing data using LEFT OUTER JOIN    *
  *                        between PARENT and CHILD Table        *
  *                      - Mapped IMS segment SQL Error Data     *
  *                        cannot be added to table              *
  *                      - Discovery time-out when creating IDMS *
  *                        Virtual Table - 0C4                   *
  *                      - View execution returns Invalid prefix *
  *                        length 16895 result set column 11     *
  *                        min =1 , max = 3998                   *
  *                      - IMS Virtual Table Creation Failure    *
  *                        where DBD contain NULLVAL             *
  *                      - Virtual View create validates WHERE   *
  *                        AND as Successful                     *
  *                      - SQL Engine ABEND when running our     *
  *                        JDBC unit tests                       *
  *                      - Reusable Prepared Statements do not   *
  *                        execute second and subsequent         *
  *                        requests                              *
  *                      - Problem using 'short' day format in   *
  *                        where clause with a Db2 timestamp     *
  *                        column                                *
  *                      - No range data found error on Creating *
  *                        virtual tables for DB2 wizard needs   *
  *                        to be changed to "Connection to DB    *
  *                        server failed"                        *
  *                      - Invalid date/time comparison on       *
  *                        Virtual Table with DB2 Direct         *
  *                      - Incorrect message for IMS DBCTL       *
  *                        Virtual tables - IMS-Direct skipped   *
  *                        for DBD xxx - map reduce is disabled  *
  *                        for this DBD                          *
  *                      - IMS record count discrepancy when     *
  *                        running with Direct vs DBCTL          *
  *                      - Above the bar memory leak in UNION    *
  *                        Query                                 *
  *                      - Invalid Column reference message when *
  *                        creating VT from attached copybook    *
  *                        and run SQL Query                     *
  *                      - SQL Engine parsing IMS DBD fail and   *
  *                        S0C3 ABEND                            *
  *                      - Errors in supplied IN00 file          *
  *                      - Unable to process map error/Invalid   *
  *                        column name length when creating VSAM *
  *                        Virtual table                         *
  *                      - UDTF for VSAM ALLTYPES VT CREATE      *
  *                        FUNCTION gives DSNT408I               *
  *                        SQLCODE = -060, ERROR: INVALID LENGTH *
  *                        SPECIFICATION: 300                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

  UI66255

Modules/Macros

•    CQD$E6DE CQD$E6DM CQD$E6VE CQD$E6VM CQD$OLGS
  CQD$U6D0 CQD$U6V0 CQDCDSRD CQDCGTMM CQDCPGRD CQDCRDFI CQDCSQMM
  CQDCTSOP CQDOBRTV CQDOINAS CQDOISMP CQDOLGUX CQDORXMD CQDSIN00
  CQDSQLAD CQDSQLAN CQDSQLBD CQDSQLBN CQDSQLCD CQDSQLCN CQDSQL9D
  CQDSQL9N CQDSQ2AD CQDSQ2AN CQDSQ2BD CQDSQ2BN CQDSQ2CD CQDSQ2CN
  CQDSQ29D CQDSQ29N HQDCC10J
  

Fix information

• Fixed component name

  QMF DATA SERVIC

• Fixed component ID

  566872103

Applicable component levels

• RC10 PSY UI66255

     UP19/11/06 P F911

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.