PI94416: VARIOUS FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. VTB rules for delimited data support works incorrectly for
  VSAM
  2. Setting zedcompression during runtime causes inaccessibility
  to connect back to the server
  3. S0C3 abend in COIMSDBD doing IMS Discovery
  4. IN00 changes - DSCLIENTMAXTOTALSTG 128GB to 16 GB,
  VSAMOPENRLS must default to NO and SHARESUBPOOLZERO must default
  to YES
  5. Change default setting of CHAR to VARCHAR conversion in SQL
  Engine (SQLENGCHARTOVARCHAR)
  6. ABEND S0C4 at HLVCLAPI+1130 on a DS Client API call
  7. HLV server on startup shows SYSTEM ABEND X'0C4' AT
  COTRSQDT+X'0000008E' RETRY AT X'13B03B92' ERRORID 0 when DIAG
  traps are set
  8. DS Client fails to limit non-entitled callers to 100 rows
  9. LUW DB2 Stored Procedure Call returning Parameters as
  DATE,TIME, and/or TIMESTAMP are returned to Server in native
  CCSID (1208 aka ASCII)
  10. Abend S0C4 in HLV$650E+0416 when processing SMF records from
  log streams or the in-memory API.
  11. Problems mapping a Db2 accelerated table
  12. IBM Application Discovery integration - Based on SQL Server
  access via HIS DRDA
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader    *
  *                 Server for z/OS                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. VTB rules for delimited data         *
  *                      support works incorrectly for VSAM      *
  *                      2. Setting zedcompression during        *
  *                      runtime causes inaccessibility to       *
  *                      connect back to the server              *
  *                      3. S0C3 abend in COIMSDBD doing IMS     *
  *                      Discovery                               *
  *                      4. IN00 changes - DSCLIENTMAXTOTALSTG   *
  *                      128GB to 16 GB, VSAMOPENRLS must        *
  *                      default to NO and SHARESUBPOOLZERO      *
  *                      must defaul to YES                      *
  *                      5. Change default setting of CHAR to    *
  *                      VARCHAR conversion in SQL               *
  *                      Engine (SQLENGCHARTOVARCHAR)            *
  *                      6. ABEND S0C4 at HLVCLAPI+1130 on a     *
  *                      DS Client API call                      *
  *                      7. HLV server on startup shows SYSTEM   *
  *                      ABEND X'0C4' AT COTRSQDT+X'0000008E'    *
  *                      RETRY AT X'13B03B92' ERRORID 0 when     *
  *                      DIAG traps are set                      *
  *                      8. DS Client fails to limit             *
  *                      non-entitled callers to 100 rows        *
  *                      9. LUW DB2 Stored Procedure Call        *
  *                      returning Parameters as DATE,TIME,      *
  *                      and/or TIMESTAMP are returned to        *
  *                      Server in native CCSID                  *
  *                      (1208 aka ASCII)                        *
  *                      10. Abend S0C4 in HLV$650E+0416 when    *
  *                      processing SMF records from log         *
  *                      streams or the in-memory API.           *
  *                      11. Problems mapping a Db2 accelerated  *
  *                      table                                   *
  *                      12. IBM Application Discovery           *
  *                      integration - Based on SQL Server       *
  *                      access via HIS DRDA                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem
  

Problem conclusion

• Apply the PTF for problem resolution
  

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:

  UI56011

Modules/Macros

•    HALE210J HLV$N3@0 HLV$N3@1 HLV$N3@2 HLV$N3@3
  HLV$N3@4 HLV$N3@5 HLV$73@E HLV$73@M HLV#ARCN HLVCADAL HLVCBIMG
  HLVCCAPR HLVCCAPS HLVCCLOS HLVCCMAL HLVCCMSL HLVCCNEV HLVCCONN
  HLVCCREV HLVCCUDA HLVCCULG HLVCDDUS HLVCDISC HLVCDSAL HLVCDSHM
  HLVCD2CL HLVCESCN HLVCFMDA HLVCFMHT HLVCFTBU HLVCGSIO HLVCGTCM
  HLVCIDCL HLVCIMAC HLVCIMCL HLVCIOFU HLVCISBR HLVCISCL HLVCLGEX
  HLVCMQIO HLVCMRFU HLVCPDRU HLVCPIIN HLVCPMRC HLVCPROC HLVCPRPA
  HLVCPRPK HLVCPRSE HLVCRECV HLVCRQIF HLVCRXSC HLVCSCRU HLVCSDBD
  HLVCSEND HLVCSERL HLVCSQCM HLVCSQDT HLVCSQOP HLVCSSR1 HLVCSVCL
  HLVCSWEV HLVCTGOP HLVCTIVE HLVCTPOP HLVCTRAC HLVCTRDA HLVCTRHO
  HLVSYSLG HLVSYSL2
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI56011

     UP18/05/29 P F805

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.