PI94503: VARIOUS QMF DATA SERVICE FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Runtime setup of zedcompression causes inaccessibility of
  sqlengine:
  REGISTER EXECUTED FOR AREA...RC=16 RE=00000304
  VTB rules for delimited data support works incorrectly for VSAM
  ABEND S0C4 at CQDCLAPI+1130 on a DS Client API call
  Change default setting of CHAR to VARCHAR conversion in SQL
  Engine
  (SQLENGCHARTOVARCHAR)
  IDMS VT create error: IG IDMSGC - ERROR LOCATING FIELD DBKEY IN
  FLDI
  ARRAY
  SRB SYSTEM ABEND X'0C3' AT sdctbdfl/HLVSQLBN on bringing up HLV
  server
  with nested occurs in maps
  SRB SYSTEM ABEND X'0C9' AT COCMTVRD+X'00000D50'
  IAMPRINT file in use validation error when mapping IAM Files
  from Data
  Studio
  COTRSQDT - The SQL String Translation routine has a bug when
  Target
  Conversion Buffer is less than 256 bytes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND S0C4 at CQDCLAPI+1130 on a DS     *
  *                      Client API call                         *
  *                                                              *
  *                      COTRSQDT - The SQL String Translation   *
  *                      routine has a bug when Target           *
  *                      Conversion Buffer is less than 256      *
  *                      bytes                                   *
  *                                                              *
  *                      Change default setting of CHAR to       *
  *                      VARCHAR conversion in SQL Engine (      *
  *                      SQLENGCHARTOVARCHAR)                    *
  *                                                              *
  *                      IAMPRINT file in use validation error   *
  *                      when mapping IAM Files from Data Studio *
  *                                                              *
  *                      IDMS VT create error: IG IDMSGC - ERROR *
  *                      LOCATING FIELD DBKEY IN FLDI ARRAY      *
  *                                                              *
  *                      Runtime setup of zedcompression causes  *
  *                      inaccessibility of sqlengine: REGISTER  *
  *                      EXECUTED FOR AREA...RC=16 RE=00000304   *
  *                                                              *
  *                      S0C3 abend in COIMSDBD doing IMS        *
  *                      Discovery                               *
  *                                                              *
  *                      SRB SYSTEM ABEND X'0C3' AT sdctbdfl/    *
  *                      HLVSQLBN on bringing up HLV server with *
  *                      nested occurs in maps                   *
  *                                                              *
  *                      SRB SYSTEM ABEND X'0C9' AT COCMTVRD+    *
  *                      X'00000D50'                             *
  *                                                              *
  *                      Storage overlay and abends 0C3 and 0C4  *
  *                      when retrieving multiple generations of *
  *                      a GDG and one or more is archived to    *
  *                      tape                                    *
  *                                                              *
  *                      VTB rules for delimited data support    *
  *                      works incorrectly for VSAM              *
  *                                                              *
  *                      When using VPD on single volume tape,   *
  *                      failed with ABEND S0C3 DAIOSU/OPDAIO31+ *
  *                      X'00001F9C'                             *
  *                                                              *
  *                      LUW DB2 Stored Procedure Call returning *
  *                      Parameters as DATE,TIME, and/or         *
  *                      TIMESTAMP are returned to Server in     *
  *                      native CCSID (1208 aka ASCII)           *
  *                                                              *
  *                      SELECT on SMF GDG gives error Begin     *
  *                      failed for 'SMFDATA', IORC 8, RC        *
  *                      798720, Error Code 0X3, Info Code 0     *
  *                                                              *
  *                      Abend S0C4 in AZK$650E+0416 when        *
  *                      processing SMF records from log streams *
  *                      or the in-memory API.                   *
  *                                                              *
  *                      IBM Application Discovery integration - *
  *                      Based on SQL Server access via HIS DRDA *
  *                                                              *
  *                      SRB SYSTEM ABEND X'0C3' AT DAIOVPGT/    *
  *                      OPDAIO31+X'0001182E'                    *
  *                                                              *
  *                      ABEND S080 rsnc 6B000121 and            *
  *                      termination at EOM while processing     *
  *                      compressed SMF logstream                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

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:

  UI56995

Modules/Macros

•    CQDCADAL CQDCBIMG CQDCCAPR CQDCCAPS CQDCCKST
  CQDCCLOS CQDCCMAL CQDCCMSL CQDCCONN CQDCCREV CQDCCRSB CQDCCRSS
  CQDCCUDA CQDCCULG CQDCDDUS CQDCDISC CQDCDSAL CQDCDSHM CQDCDSOP
  CQDCDSRD CQDCD2CL CQDCESCN CQDCFMDA CQDCFMHT CQDCFTBU CQDCGSIO
  CQDCGTCM CQDCGTSR CQDCIDCL CQDCIMAC CQDCIMCL CQDCIOFU CQDCISCL
  CQDCLGEX CQDCMQIO CQDCMRFU CQDCMSCG CQDCMSMQ CQDCOWSS CQDCPDRU
  CQDCPIIN CQDCPMRC CQDCPROC CQDCPRPA CQDCPRPK CQDCPRSE CQDCREOW
  CQDCRLOW CQDCRQIF CQDCRXSC CQDCSCOW CQDCSCRU CQDCSDBD CQDCSERL
  CQDCSNRC CQDCSQCM CQDCSQDT CQDCSQOP CQDCSSR1 CQDCSVCL CQDCSWEV
  CQDCTGOP CQDCTIVE CQDCTRAC CQDCTRDA CQDCTRDC CQDCTRHO CQDCTSAL
  CQDCTVAL CQDCTZOP CQDCUSPW CQDCVPAL CQDCVPCL CQDCVPGT CQDCVPPT
  CQDCVUPW CQDCWUID CQDCXMCV CQDCXMEN CQDCXMEV CQDCXMND CQDCXMUP
  CQDCXQEV CQDCZEDC CQDCZFIO CQDDSNRL CQDGDGS1 CQDIADTB CQDIADVW
  CQDIAMPD CQDIAMPS CQDMDLDU CQDMDTBL CQDOACDA CQDOADEX CQDOAOPR
  CQDOAPDR CQDOAUCK CQDOAUMG CQDOBJ   CQDOBRID CQDOBRIM CQDOBRIS
  CQDOBRMA CQDOBRSQ CQDOBRSR CQDOBRTV CQDOBRXM CQDOCIEC CQDOCITP
  CQDOCKLM CQDOCLUP CQDOCOSE CQDOCOSF CQDOCOSO CQDOCPTP CQDOCURE
  CQDOCXA0 CQDODARU CQDODATP CQDODBTP CQDODEIP CQDODEMG CQDODMMG
  CQDOENFU CQDOHLDR CQDOHOPA CQDOIMTP CQDOINAE CQDOINAO CQDOINAS
  CQDOINBR CQDOINEF CQDOINSC CQDOINSM CQDOINSQ CQDOINWM CQDOINXM
  CQDOIO31 CQDOLINK CQDOMABR CQDOMAEF CQDOMAIN CQDOMALG CQDOMAOT
  CQDOMAPI CQDOMART CQDOMAXM CQDOMBIS CQDOMBTP CQDOMGPR CQDOOTMG
  CQDOPAEX CQDOPCK  CQDOPFU  CQDOPHSO CQDOPHSR CQDOPHTP CQDOPML
  CQDOPMM  CQDOPMS  CQDOPPA  CQDOPPT  CQDOPST  CQDOPVT  CQDOSCFU
  CQDOSCTK CQDOSMMH CQDOSVTP CQDOTBEV CQDOTPIN CQDOVPMG CQDOWSRV
  CQDOWWPR CQDOWWTP CQDOXMMG CQDOZCEX CQDOZSTP CQDOZTRM CQDO2DSA
  CQDO31AD CQDO31AN CQDO31BD CQDO31BN CQDO31CD CQDO31CN CQDO319D
  CQDO319N CQDPB    CQDRAATB CQDRAAVW CQDRAMPD CQDRAMPS CQDSIN00
  CQDSMFT1 CQDSQLAD CQDSQLAN CQDSQLBD CQDSQLBN CQDSQLCD CQDSQLCN
  CQDSQL9D CQDSQL9N CQDSQ2AD CQDSQ2AN CQDSQ2BD CQDSQ2BN CQDSQ2CD
  CQDSQ2CN CQDSQ29D CQDSQ29N CQDSYSLG CQDSYSL2 CQDVPDS1 HQDCC10J
  

Fix information

• Fixed component name

  QMF DATA SERVIC

• Fixed component ID

  566872103

Applicable component levels

• RC10 PSY UI56995

     UP18/07/04 P F807

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.