IBM Support

PI74053: SUPPORT DRDA ACCESS TO MS SQL SERVER ALONG WITH DRDA AND MAPREDUCE FEATURES FOR OPTIMIZATION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • * Add support for access to Microsoft Host Integration Server
    and SQL-Server.
    
    * Automated VT Map generation for DRDA enabled datasources.
    
    * Allow SET CURRENT QUERY ACCELERATION WITH FAILBACK for DB2
    Virtual Tables.
    
    * Add sample DRDARange and IMSRange dsclient job.
    
    * Add connection string property PrepareMetadataSQL=true|false
    for SQLServer Support
    
    * Fix for Map Reduce Failure IORC 8, RC 0, Error Code 0 with
    Empty Sequential Table
    
    * Interface to IAM for key ranges for MapReduce.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Support direct DRDA access to Microsoft *
    *                      SQL Server.                             *
    *                                                              *
    *                      Fix for Map Reduce Failure IORC 8,      *
    *                      RC 0, Error Code 0 with Empty           *
    *                      Sequential Table                        *
    *                                                              *
    *                      Interface to IAM for key ranges for     *
    *                      MapReduce.                              *
    *                                                              *
    *                      Automated VT Map generation for DRDA    *
    *                      enabled datasources.                    *
    *                                                              *
    *                      Allow SET CURRENT QUERY ACCELERATION    *
    *                      WITH FAILBACK for DB2 Virtual Tables.   *
    *                                                              *
    *                      Add sample DRDARange and IMSRange       *
    *                      dsclient job.                           *
    *                                                              *
    *                      Add connection string property          *
    *                      PrepareMetadataSQL=true|false for       *
    *                      SQLServer Support.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI74053

  • Reported component name

    QMF DATA SERVIC

  • Reported component ID

    566872103

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-12-20

  • Closed date

    2017-10-09

  • Last modified date

    2017-11-01

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

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

    UI50940

Modules/Macros

  •    CQD$GDBD CQD$PDBD CQD#ARCN CQD#BCOM CQD#BDIR
    CQD#BRGN CQD#CPOL CQD#DBDI CQD#DBRC CQD#FSCD CQD#GMSG CQD#IDEF
    CQD#IMSR CQD#JESI CQD#MSG0 CQD#ODIR CQD#ORGN CQD#RACB CQD#TRAC
    CQD#XACB CQDABIGG CQDADASG CQDADB2G CQDADDBG CQDADRBG CQDAIFXG
    CQDALUWG CQDALUWI CQDAMSSG CQDAODBG CQDAORAG CQDAQMFG CQDA2VTD
    CQDA2VTR CQDCACCU CQDCADAL CQDCADOP CQDCADRD CQDCADSB CQDCBDML
    CQDCCMAL CQDCCMCL CQDCCMSL CQDCCRCB CQDCDBIF CQDCDBST CQDCDCCB
    CQDCDLSG CQDCDRCK CQDCDREX CQDCDSAL CQDCDSFR CQDCDSHM CQDCDSIS
    CQDCDSOP CQDCDSRD CQDCD2CL CQDCD2SS CQDCFIIC CQDCFRBD CQDCFRBK
    CQDCFRCB CQDCFRCU CQDCGBLV CQDCGSIO CQDCGTBK CQDCGTCM CQDCGTMM
    CQDCGTSR CQDCIAML CQDCIDBD CQDCIDCL CQDCIMCL CQDCIMDB CQDCINIC
    CQDCINWK CQDCISBR CQDCISCL CQDCMDK7 CQDCMDSG CQDCMRFU CQDCMSCG
    CQDCMSDA CQDCMSMQ CQDCMTCL CQDCOPDM CQDCOPFB CQDCPRNA CQDCREOW
    CQDCRLOW CQDCRQIF CQDCSCOW CQDCSDBD CQDCSQAD CQDCSQCL CQDCSQCM
    CQDCSQDT CQDCSQEV CQDCSQLM CQDCSQMM CQDCSQOP CQDCSQRW CQDCSQTB
    CQDCSVCL CQDCTEXT CQDCTGOP CQDCTSAL CQDCTSOP CQDCTSRD CQDCTVAL
    CQDCTVCL CQDCTVOP CQDCTVRD CQDCTVTK CQDCTZOP CQDCVPAL CQDCVPCL
    CQDCVPEV CQDCVPGT CQDCVPPT CQDCWUID CQDCXQEV CQDCZFIO CQDC2SRB
    CQDC2TCB CQDDBRCT CQDDYNAL CQDFDBRC CQDFDJCL CQDFDMDA CQDGRERR
    CQDGREXC CQDGREXE CQDGRINI CQDGRITB CQDGRRLT CQDGRSVP CQDGRTER
    CQDGRXCL CQDGRXCM CQDGRXCT CQDGRXEQ CQDGRXSR CQDGRXZA CQDIMSA1
    CQDIMSB1 CQDIMSC1 CQDIMSDB CQDIMSD1 CQDIMSE1 CQDIMSOF CQDIMS91
    CQDIR4AT CQDIR4ED CQDIR4SQ CQDISACI CQDISCBG CQDISIDM CQDISIV1
    CQDISMEM CQDISMNW CQDLTENU CQDMBTPA CQDMGENU CQDMODST CQDMTMTC
    CQDMTMT6 CQDOACDA CQDOAOPR CQDOAPDR CQDOATFU CQDOAUCK CQDOAUMG
    CQDOBJ   CQDOBOFU CQDOBRFE CQDOBRID CQDOBRIM CQDOBRIS CQDOBRSQ
    CQDOBRSR CQDOBRTV CQDOBRXM CQDOCKLM CQDOCLUP CQDOCNCL CQDOCOSB
    CQDOCOSE CQDOCOSF CQDOCOSK CQDODARU CQDODBIN CQDODBTP CQDODMMG
    CQDODMWR CQDOESRU CQDOFXCQ CQDOHOPA CQDOINAS CQDOINSQ CQDOIOMG
    CQDOIO31 CQDOISMP CQDOKYAD CQDOKYAN CQDOKYBD CQDOKYBN CQDOKY9D
    CQDOKY9N CQDOLIAD CQDOLIAN CQDOLIBD CQDOLIBN CQDOLINK CQDOLI9D
    CQDOLI9N CQDOMABR CQDOMAIN CQDOMASM CQDOMBTP CQDOMPTP CQDOPAEX
    CQDOPAFU CQDOPFU  CQDOPML  CQDOPMM  CQDOPMS  CQDOPPA  CQDOPPT
    CQDOPRUT CQDOPST  CQDOPVT  CQDORXDM CQDORXMD CQDOSCFU CQDOSGMG
    CQDOSKRU CQDOSVTP CQDOTBEV CQDOTBMG CQDOTBRU CQDOVPMG CQDO31AD
    CQDO31AN CQDO31BD CQDO31BN CQDO319D CQDO319N CQDPB    CQDRANGE
    CQDRAVTC CQDRAVTR CQDSBIGC CQDSDDBC CQDSDRBC CQDSEQIN CQDSEQOU
    CQDSFPAR CQDSIFXC CQDSLUWC CQDSMSSC CQDSORAC CQDSQLAD CQDSQLAN
    CQDSQLBD CQDSQLBN CQDSQL9D CQDSQL9N CQDSQMFC CQDSQ2AD CQDSQ2AN
    CQDSQ2BD CQDSQ2BN CQDSQ29D CQDSQ29N CQDTSVTR CQDTT094 CQDVPDS1
    CQD1PROC HQDCC10J
    

Fix information

  • Fixed component name

    QMF DATA SERVIC

  • Fixed component ID

    566872103

Applicable component levels

  • RC10 PSY UI50940

       UP17/10/19 P F710

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 July 2020