IBM Support

PI76778: SQL ACCESS TO IDMS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • This enhancement introduces SQL access to IDMS record and set
    information managed by IDMS central versions running on z/OS.
    Virtual tables are mapped to IDMS records and sets that can be
    joined using standard SQL to navigate IDMS information.
    Map/Reduce processing will be supported to improve performance
    of large data extracts of IDMS information.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM DB2 Analytics Accelerator       *
    *                 Loader for z/OS.                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: This enhancement introduces SQL access  *
    *                      to IDMS record and set information      *
    *                      managed by IDMS central versions        *
    *                      running on z/OS. Virtual tables are     *
    *                      mapped to IDMS records and sets that    *
    *                      can be joined using standard SQL to     *
    *                      navigate IDMS information. Map/Reduce   *
    *                      processing will be supported to         *
    *                      improve performance of large data       *
    *                      extracts of IDMS information.           *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

Temporary fix

Comments

  • APPLY the PTF.
    

APAR Information

  • APAR number

    PI76778

  • Reported component name

    IDAA LOADER DAT

  • Reported component ID

    5639OLE01

  • Reported release

    210

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-16

  • Closed date

    2017-08-16

  • Last modified date

    2017-09-02

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

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

    UI49614

Modules/Macros

  •    HALE210J HLV$GDBD HLV$PDBD HLV#ARCN HLV#BCOM
    HLV#BDIR HLV#BRGN HLV#CPOL HLV#DBDI HLV#DBRC HLV#FSCD HLV#GMSG
    HLV#IDEF HLV#IMSR HLV#JESI HLV#MSG0 HLV#ODIR HLV#ORGN HLV#RACB
    HLV#TRAC HLV#XACB HLVBIN   HLVCACCU HLVCADAL HLVCADOP HLVCADRD
    HLVCADSB HLVCASOW HLVCBDML HLVCBIIM HLVCCMAL HLVCCMCL HLVCCMSL
    HLVCCNEV HLVCCUBI HLVCCULG HLVCDABK HLVCDRCK HLVCDREX HLVCDSFR
    HLVCDSHM HLVCDSIS HLVCDSOP HLVCDSRD HLVCD2CL HLVCFIIC HLVCFRBR
    HLVCFRCU HLVCFREX HLVCFRUB HLVCGBLV HLVCGSIO HLVCGTBD HLVCGTBK
    HLVCGTBR HLVCGTCL HLVCGTCM HLVCGTMM HLVCIAML HLVCIDBD HLVCIDCL
    HLVCIMBR HLVCIMDB HLVCINIC HLVCISBR HLVCISCL HLVCKYEX HLVCLGEX
    HLVCMRFU HLVCMSCG HLVCMSDA HLVCMSMQ HLVCMTCL HLVCOPDM HLVCOPFB
    HLVCPIIN HLVCPIOU HLVCPRNA HLVCPRPA HLVCPRSE HLVCREOW HLVCSCOW
    HLVCSDBD HLVCSEND HLVCSQAD HLVCSQCL HLVCSQCM HLVCSQDT HLVCSQLM
    HLVCSQMM HLVCSQOP HLVCSQRW HLVCSQTB HLVCSVCL HLVCTEXT HLVCTGOP
    HLVCTPOP HLVCTREX HLVCTSAL HLVCTSOP HLVCTSRD HLVCTVAL HLVCTVCL
    HLVCTVOP HLVCTVRD HLVCTVTK HLVCTZOP HLVCUSED HLVCVPAL HLVCVPCL
    HLVCVPEV HLVCVPGT HLVCVPPT HLVCXDIO HLVCXMUP HLVCZFIO HLVC2SRB
    HLVC2TCB HLVDBRCT HLVDYNAL HLVFDBRC HLVFDJCL HLVFDMDA HLVGRERR
    HLVGREXC HLVGREXE HLVGRINI HLVGRITB HLVGRRLT HLVGRSVP HLVGRTER
    HLVGRXCL HLVGRXCM HLVGRXCT HLVGRXEQ HLVGRXSR HLVGRXZA HLVIMSA1
    HLVIMSB1 HLVIMSC1 HLVIMSDB HLVIMSD1 HLVIMSE1 HLVIMSOF HLVIMS91
    HLVISACI HLVISCBG HLVISIDM HLVISIV1 HLVISMEM HLVISMNW HLVLTENU
    HLVMGENU HLVMODST HLVMTMT6 HLVOACDA HLVOAPDR HLVOATFU HLVOAUCK
    HLVOBOFU HLVOBRFE HLVOBRIM HLVOBRIS HLVOBRSQ HLVOBRSR HLVOBRTV
    HLVOBRXM HLVOCKLM HLVOCLUP HLVOCNCL HLVOCOSB HLVOCOSE HLVOCOSF
    HLVODARU HLVODMMG HLVODMWR HLVOESRU HLVOFUGN HLVOHOPA HLVOINAS
    HLVOINSQ HLVOIOMG HLVOIO31 HLVOISMP HLVOLIAD HLVOLIAN HLVOLIBD
    HLVOLIBN HLVOLINK HLVOLI9D HLVOLI9N HLVOMABR HLVOMAIN HLVOMASM
    HLVOMBTP HLVOMLGN HLVOMPTP HLVOPAEX HLVOPAGN HLVOPMM  HLVOPMS
    HLVORXDM HLVORXMD HLVOSCFU HLVOSGMG HLVOSKRU HLVOSTGN HLVOSVTP
    HLVOTBEV HLVOTBMG HLVOVPMG HLVOVTGN HLVO31AD HLVO31AN HLVO31BD
    HLVO31BN HLVO319D HLVO319N HLVPB    HLVRANGE HLVSBIGC HLVSDDBC
    HLVSDRBC HLVSEQIN HLVSEQOU HLVSIFXC HLVSLUWC HLVSMFT1 HLVSMSSC
    HLVSORAC HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQL9D HLVSQL9N
    HLVSQMFC HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ29D HLVSQ29N
    HLV1PROC
    

Fix information

  • Fixed component name

    IDAA LOADER DAT

  • Fixed component ID

    5639OLE01

Applicable component levels

  • R210 PSY UI49614

       UP17/08/23 P F708

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":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCQN5S","label":"Db2 Analystics Accelerator Loader Data Map"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 September 2017