PI89079: VARIOUS IMS, IDMS AND STUDIO FIXES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• - Support suppressing the extracted IMS segment maps when
  creating Virtual Tables by specifying parameter
    SQLENGENABLESEGMAP to NO.
  - Studio allows user to specify IMS ID in the DBD wizard and
    editor to support multiple IMS subsystems.
  - Studio changes to default Enable Loader Parallelism to enabled
    and Degree of Parallelism set to 4.
  - Slow performance on IDMS SQL JOIN due to table scan on the
    inner table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM DB2 Analytics Accelerator Loader         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: - Support suppressing the extracted     *
  *                       IMS segment maps when creating Virtual *
  *                       Tables by specifying parameter         *
  *                       SQLENGENABLESEGMAP to NO.              *
  *                      - Studio allows user to specify IMS ID  *
  *                       in the DBD wizard and editor to        *
  *                       support multiple IMS subsystems.       *
  *                      - Studio changes to default Enable      *
  *                       Loader Parallelism to enabled and      *
  *                       Degree of Parallelism set to 4.        *
  *                      - Slow performance on IDMS SQL JOIN     *
  *                       due to table scan on the inner table.  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UI53496

Modules/Macros

•    HALE210J HLVBIN   HLVCCAEX HLVCCMAL HLVCCM64
  HLVCDSOP HLVCFLIB HLVCFRUB HLVCMDK7 HLVCMQFB HLVCMQIO HLVCMSCG
  HLVCMSMQ HLVCOPDM HLVCSDBD HLVCSQOP HLVCSQTB HLVCSVCL HLVCTSAL
  HLVCTSOP HLVCVPAL HLVGDGS1 HLVMTMT6 HLVOAOEX HLVOBRID HLVOBRIM
  HLVOBRSQ HLVOBRTV HLVOCOSD HLVOCOSG HLVOCOSR HLVODBIN HLVOINAS
  HLVOINCI HLVOINCM HLVOINMQ HLVOINSQ HLVOIO31 HLVOLIAD HLVOLIAN
  HLVOLIBD HLVOLIBN HLVOLINK HLVOLI9D HLVOLI9N HLVOMLGN HLVOPGPR
  HLVOPMM  HLVOPMS  HLVOTBEV HLVOTBMG HLVOTPIN HLVO31AD HLVO31AN
  HLVO31BD HLVO31BN HLVO31CD HLVO31CN HLVO319D HLVO319N HLVO64CD
  HLVO64CN HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN
  HLVSQL9D HLVSQL9N HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD
  HLVSQ2CN HLVSQ29D HLVSQ29N
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI53496

     UP18/02/15 P F802

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.