PH15527: CQD AUGUST 2019 RELEASE 19/09/18 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ==========================CLOSING TEXT
  ===================================
  * IMS-Direct S0C3 abend
  * SQL engine returns Invalid token NOT found after left
  parenthesisT in Studio is calling SDBC1010 instead of
  * BIND/GRANT in Studio is calling SDBC1010 instead of CQDC1010
  * Pass User ID/PWD to IMS over DBCTL for authentication with
  addition to using IMS Open Thread TCB (OTT) to bypass DRA
  * Server fails to recognize that the full key has been provided
  for the second virtual table in a IMS view
  * SQL INSERT to IMS child segments fails using DBCTL access
  * Unable to build virtual tables due to DBD Parsing problems
  * Abend running SQL Query using CASE
  * SQL engine not passing where predicates down into view of an
  IMS join
  * UDTF for VSAM ALLTYPES VT CREATE FUNCTION gives DSNT408I
  SQLCODE = -060, ERROR: INVALID LENGTH SPECIFICATION : 300
  * DB2 Direct fails with Invalid Data Page on compressed
  non-segmented linear data sets
  * SQL re execute on IMS-Direct table reverts to schedule a PSB
  * zcEE Parms are not Updateable but listed as Updateable
  * Server's STC ID used for dataset permissions with VSAM file
  * Cannot create IMS Virtual Table with specific DBD
  * The SSA is not constructed with the correct value when using
  the RECORD_ID = 'value'
  * If VSAMOPENRLS is set to YES, query on a VT VSAM file causes
  the server keep the vsam file allocated
  * Query on SMF_00600 causing the server to LOOP
  IBM QMF Data Service branded DV_ODBC driver for Intel Linux
  (RHEL on x86_64) and zLinux (RHEL on s390x)
  ===================END TEXT
  =================================================
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: -IMS-Direct S0C3 abend                  *
  *                      -SQL engine returns Invalid token NOT   *
  *                       found after left parenthesis           *
  *                      -BIND/GRANT in Studio is calling        *
  *                       SDBC1010 instead of CQDC1010           *
  *                      -SELECT casting to DAYS/INTEGER fails   *
  *                       with "Timestamp string contains        *
  *                       invalid delimiters"                    *
  *                      -Pass User ID/PWD to IMS over DBCTL for *
  *                       authentication with addition to using  *
  *                       IMS Open Thread TCB (OTT) to bypass    *
  *                       DRA                                    *
  *                      -Server fails to recognize that the     *
  *                       full key has been provided for the     *
  *                       second virtual table in a IMS view     *
  *                      -SQL INSERT to IMS child segments fails *
  *                       using DBCTL access                     *
  *                      -Unable to build virtual tables due to  *
  *                       DBD Parsing problems                   *
  *                      -Abend running SQL Query using CASE     *
  *                      -SQL engine not passing where           *
  *                       predicates down into view of an IMS    *
  *                       join                                   *
  *                      -DB2 Direct fails with Invalid Data     *
  *                       Page on compressed non-segmented       *
  *                       linear data sets                       *
  *                      -SQL re execute on IMS-Direct table     *
  *                       reverts to schedule a PSB              *
  *                      -zcEE Parms are not Updateable but      *
  *                       listed as Updateable                   *
  *                      -Server's STC ID used for dataset       *
  *                       permissions with VSAM file             *
  *                      -Cannot create IMS Virtual Table with   *
  *                       specific DBD                           *
  *                      -The SSA is not constructed with the    *
  *                       correct value when using the           *
  *                       RECORD_ID = 'value'                    *
  *                      -If VSAMOPENRLS is set to YES, query on *
  *                       a VT VSAM file causes the server keep  *
  *                       the vsam file allocated                *
  *                      -Query on SMF_00600 causing the server  *
  *                       to LOOP                                *
  ****************************************************************
  * 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:

  UI65685

Modules/Macros

•    CQD$G600 CQD$OLGS CQD$060E CQD$060M CQD$1E0E
  CQD$2AOE CQD$4F2E CQD$4F3E CQDCPROC CQDCRDBD CQDCSCHE CQDCSQOP
  CQDOBJ   CQDOBRIM CQDODMMG CQDOIMSR CQDOIO31 CQDOLIAD CQDOLIAN
  CQDOLIBD CQDOLIBN CQDOLICD CQDOLICN CQDOLI9D CQDOLI9N CQDOPMS
  CQDOPPA  CQDO2DSA CQDPB    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 UI65685

     UP19/10/08 P F910 Ø

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.