IBM Support

PH07913: CQD APRIL RELEASE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • * The HLQ.CNTL member CQDDFDIV contains the old help pf
    GLOBALMAX with the value of 5000 instead of 50000
    * DRDARANGE for Oracle does not create usable ranges for MRC
    * SQL View create failed using OR operators
    * IMS JOINS gives - SRB SYSTEM ABEND X'0C3' AT sdioimsr/SDBSQLCN
    * OCCURS DEPENDING ON and missing segment
    * xxxDRATH encryption script does not support JGATE
    
    * MDS doesn't support LEFT OUTER JOIN for SMF data
    * IORC 8, RC 8 with SQLNCODE901 when accessing SMF 30 data
    * intermittent X'0C4' AT sdioseoc/AZKSQLBN processing
      SMF 92 records
    * Issue with field SMF79DAT in SMF 079 subtype 02 and 03
      formatted incorrectly
    * DRDARANGE for Oracle does not create usable ranges for MRC
    * Change MINMEMLIMITVALUE to 0 as the default
    * Server parser issues error when MODBLKS is not coded in IN00
    * 0C4 abend when NETWORKBUFFERSIZE is 96K
    * VPD returns wrong number of rows in DB2 Direct and MQ Series
      with VPIO=1
    * Problem running DRDARANGE
    * Parallelism Fails when ACCEL_LOAD_TASKS > Tape Volumes
    * Unable to create or edit VT for IAM files -
      dataset is not a valid type
    * IN00 changes needed for IAM Map Reduce
    * SMF_04224 using SMF dataset with type 42.24 record gives
      Buffer offset 475 exceeds row length 335,
      terminating table SMF_04224,
      base table SMF_04224, base record number 1489
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The HLQ.CNTL member CQDDFDIV contains   *
    *                      the old help pf GLOBALMAX with the      *
    *                      value of 5000 instead of 50000          *
    *                                                              *
    *                      DRDARANGE for Oracle does not create    *
    *                      usable ranges for MRC                   *
    *                                                              *
    *                      SQL View create failed using OR         *
    *                      operators                               *
    *                                                              *
    *                      IMS JOINS gives - SRB SYSTEM ABEND      *
    *                      X'0C3' AT sdioimsr/SDBSQLCN             *
    *                                                              *
    *                      OCCURS DEPENDING ON and missing segment *
    *                                                              *
    *                      xxxDRATH encryption script does not     *
    *                      support JGATE                           *
    *                                                              *
    *                      MDS doesn't support LEFT OUTER JOIN for *
    *                      SMF data                                *
    *                                                              *
    *                      IORC 8, RC 8 with SQLNCODE901 when      *
    *                      accessing SMF 30 data                   *
    *                                                              *
    *                      Intermittent X'0C4' AT                  *
    *                      sdioseoc/AZKSQLBN processing SMF 92     *
    *                      records                                 *
    *                                                              *
    *                      Issue with field SMF79DAT in SMF 079    *
    *                      subtype 02 and 03 formatted incorrectly *
    *                                                              *
    *                      DRDARANGE for Oracle does not create    *
    *                      usable ranges for MRC                   *
    *                                                              *
    *                      Change MINMEMLIMITVALUE to 0 as the     *
    *                      defualt                                 *
    *                                                              *
    *                      Server parser issues error when MODBLKS *
    *                                                              *
    *                      0C4 abend when NETWORKBUFFERSIZE is 96K *
    *                                                              *
    *                      VPD returns wrong number of rows in DB2 *
    *                      Direct and MQ Series with VPIO=1        *
    *                                                              *
    *                      Problem running DRDARANGE               *
    *                                                              *
    *                      Parallelism Fails when                  *
    *                      ACCEL_LOAD_TASKS > Tape Volumes         *
    *                                                              *
    *                      Unable to create or edit VT for IAM     *
    *                      files - dataset is not a valid type     *
    *                                                              *
    *                      IN00 changes needed for IAM Map Reduce  *
    *                                                              *
    *                      SMF_04224 using SMF dataset with type   *
    *                      42.24 record gives Buffer offset 475    *
    *                      exceeds row length 335, terminating     *
    *                      table SMF_04224, base table             *
    *                      SMF_04224, base record number 1489      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH07913

  • Reported component name

    QMF DATA SERVIC

  • Reported component ID

    566872103

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-29

  • Closed date

    2019-04-16

  • Last modified date

    2019-05-02

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

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

    UI62535

Modules/Macros

  •    CQD$1E0M CQD$2AOM CQD$4F2M CQD$4F3M CQDCATMG
    CQDCCMTC CQDCCPBU CQDCCPNA CQDCCRCB CQDCCUHL CQDCDABU CQDCDBIF
    CQDCDCCB CQDCEVTY CQDCFAPI CQDCFUNC CQDCGBLV CQDCGTCL CQDCGTIF
    CQDCGVVL CQDCHLCL CQDCMQIO CQDCMTCL CQDCOPBO CQDCPTVL CQDCSCHD
    CQDCSQEV CQDCSQTY CQDCS1HD CQDCTPIF CQDCTPOP CQDCTSRD CQDCVDEV
    CQDDRATH CQDEVDFG CQDOACDA CQDOALUE CQDOAOPR CQDOAUCK CQDOBOFU
    CQDOBOSU CQDOBRXM CQDOCMRU CQDOCOSD CQDOCOSH CQDOCOSK CQDODARU
    CQDODD9N CQDODFAD CQDODFAN CQDODFBD CQDODFBN CQDODFCD CQDODFCN
    CQDODF9D CQDODF9N CQDODRTP CQDODTAN CQDODTBN CQDODTCN CQDODT9N
    CQDOFSQL CQDOHOPA CQDOHTRU CQDOINAS CQDOINSQ CQDOITMG CQDOLINK
    CQDOMAOT CQDOMBIS CQDOOTMG CQDOPCSX CQDOPML  CQDOPMM  CQDOPMS
    CQDOPPA  CQDOPPT  CQDOPST  CQDOPVT  CQDOSVTP CQDOTBRU CQDOTPIN
    CQDOVDMG CQDO31AD CQDO31AN CQDO31BD CQDO31BN CQDO31CD CQDO31CN
    CQDO319D CQDO319N CQDO64AD CQDO64AN CQDO64BD CQDO64BN CQDO64CD
    CQDO64CN CQDO649D CQDO649N CQDPB    CQDSIN00 CQDSQLAD CQDSQLAN
    CQDSQLBD CQDSQLBN CQDSQLCD CQDSQLCN CQDSQL9D CQDSQL9N CQDSQ2AD
    CQDSQ2AN CQDSQ2BD CQDSQ2BN CQDSQ2CD CQDSQ2CN CQDSQ29D CQDSQ29N
    CQDSVDFC CQDUDDMV CQDUDDPL CQDUDTAE CQD10001 HQDCC10J
    

Fix information

  • Fixed component name

    QMF DATA SERVIC

  • Fixed component ID

    566872103

Applicable component levels

  • RC10 PSY UI62535

       UP19/04/25 P F904

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":"12.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 July 2020