PH10564: MAY RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• - Pass User ID/PWD to IMS over DBCTL for authentication with
  addition to using IMS Open Thread TCB (OTT) to bypass DRA
  - 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 datasets
  - SMF79DAT in SMF 079 subtype 02 and 03 formatted incorrectly
  - SQL re-execute on IMS-Direct table reverts to schedule a PSB
  - POSTGRES VT JOIN with DB2 VT gives error SQL error code -1
  during Prepare processing, DB2 ssid
  - xxxDRATH encryption script does not support JGATE
  - VPD returns wrong number of rows in DB2 Direct and MQ Series
  with VPIO=1
  - IN00 changes needed for IAM Map Reduce
  - Include Java DV Server Binary HLVBINJ
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Analytics Accelerator Loader    *
  *                 Server for z/OS                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: -Support accelerator group names on     *
  *                       Consistent Load and Image Copy load    *
  *                       jobs. ISPF also modified to generate   *
  *                       Consistent Load and Image Copy load    *
  *                       jobs with group names.                 *
  *                      -TCz changes to specify Microsoft SQL   *
  *                       Server as a source during              *
  *                       configuration of the HLV server and    *
  *                       generate IN00 including SQL Server.    *
  *                      -Support usage of DB2 SSID or Group     *
  *                       attach name for data sharing in ISPF.  *
  *                      -HA LOAD jobs may fail with             *
  *                       SQLCODE = -804, when many tables       *
  *                       specified. This changes are to handle  *
  *                       this by increasing the Variable length *
  *                       so that HALOAD can handle more         *
  *                       characters in the list of tables.      *
  *                      -ISPF panels updated to follow          *
  *                       guidelines on abbreviations.           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  - Pass User ID/PWD to IMS over DBCTL for authentication with
  addition to using IMS Open Thread TCB (OTT) to bypass DRA 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 datasets
  - SMF79DAT in SMF 079 subtype 02 and 03 formatted incorrectly
  - SQL re-execute on IMS-Direct table reverts to schedule a PSB
  POSTGRES VT JOIN with DB2 VT gives SQL error code -1 during
  Prepare processing, DB2 ssid
  - xxxDRATH encryption script does not support JGATE VPD returns
  wrong number of rows in DB2 Direct and MQ Series with VPIO=1
  - IN00 changes needed for IAM Map Reduce
  - Include Java DV Server
  Binary HLVBINJ
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

Comments

• ×**** PE19/06/04 FIX IN ERROR. SEE APAR PH10564  FOR DESCRIPTION
  ×**** PE19/06/04 FIX IN ERROR. SEE APAR PH10564  FOR DESCRIPTION
  ×**** PE19/06/04 FIX IN ERROR. SEE APAR PH10564  FOR DESCRIPTION
  ×**** PE19/03/05 FIX IN ERROR. SEE APAR PH09356  FOR DESCRIPTION
  

APAR Information

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

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

  UI62959

Modules/Macros

• HLV$4F2E HLV$4F2M HLV$4F3E HLV$4F3M HLV$OLGS HLVBINJ  HLVCMQIO
  HLVCPROC HLVCSCHE HLVCTGOP HLVCTGRD HLVDRATH HLVO2DSA HLVOIMSR
  HLVOLGUX HLVOPAGN HLVPB    HLVSIN00 HLVSQ29D HLVSQ29N HLVSQ2AD
  HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD HLVSQ2CN HLVSQL9D HLVSQL9N
  HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI62959

     UP19/05/24 P F905

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.