IBM Support

PI71628: SUPPORT DYNAMIC RULE FOR SMF VIEW SQL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Support dynamic rule for SMF View SQL
    
    Other symptoms:
    +IRX0018I Error running DABAIN00 line 475: THEN expected
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: - Support dynamic rule for SMF VIEW SQL *
    *                      - SMF 14 and 15 maps updated for field  *
    *                        SMFJFCB1 which contains mixed data    *
    *                        types.                                *
    *                      - SMF_1100P_PERFORMANCE Invalid data    *
    *                        returned for PHSTART.                 *
    *                      - SMF_10100_QWAC had fields with        *
    *                        negative values.                      *
    *                      - When loading SMF 110 records, some    *
    *                        fields were incorrectly translated.   *
    *                      - Updates to existing SMF maps (60)     *
    *                      - New SMF maps:                         *
    *                        Record Type: 6                        *
    *                        Record Type: 17                       *
    *                        Record Type: 18                       *
    *                        Record Type: 23                       *
    *                        Record Type: 26                       *
    *                        Record Type: 32                       *
    *                        Record Type: 42 (Subtype 1, 4, 11)    *
    *                        Record Type: 61                       *
    *                        Record Type: 62                       *
    *                        Record Type: 63                       *
    *                        Record Type: 64                       *
    *                        Record Type: 65                       *
    *                        Record Type: 66                       *
    *                        Record Type: 71                       *
    *                        Record Type: 88 (Subtype 1, 11)       *
    *                        Record Type: 113 (Subtype 1, 2)       *
    *                        Record Type: 115                      *
    *                          (Subtype 1, 2, 231, 215)            *
    *                        Record Type: 116 (Subtype 1, 2, 10)   *
    *                        Record Type: 118                      *
    *                          (Subtype 1, 2, 3, 4, 5, 20, 21, 70, *
    *                           71, 72, 73, 74, 75)                *
    *                        Record Type: 119                      *
    *                          (Subtype 1, 2, 3, 4, 5, 6, 7, 8,    *
    *                           10, 20, 21, 22, 23, 24, 32, 33,    *
    *                           34, 35, 36, 37, 41, 42, 43, 44,    *
    *                           48, 49, 50, 51, 52, 70, 71, 72,    *
    *                           73, 74, 75, 76, 77, 78, 79, 80)    *
    *                        Record Type: 120                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI71628

  • Reported component name

    QMF DATA SERVIC

  • Reported component ID

    566872103

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-11-01

  • Closed date

    2017-04-25

  • Last modified date

    2017-06-27

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

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

    UI46739

Modules/Macros

  •    CQD$F91E CQD$F91M CQD$GDBD CQD$GE00 CQD$GE01
    CQD$GF00 CQD$GF01 CQD$HA00 CQD$HE0A CQD$HE0B CQD$HE0C CQD$HE0D
    CQD$HE0E CQD$HE0F CQD$HE0G CQD$HE0H CQD$HE0I CQD$HE00 CQD$HE01
    CQD$HE02 CQD$HE03 CQD$HE04 CQD$HE05 CQD$HE06 CQD$HE07 CQD$HE08
    CQD$HE09 CQD$H100 CQD$H101 CQD$H200 CQD$H201 CQD$IAA0 CQD$IAA1
    CQD$IAB1 CQD$IAL0 CQD$IAL1 CQD$IAL2 CQD$IAL3 CQD$IAM0 CQD$IAM1
    CQD$IAO0 CQD$IAO1 CQD$IAO2 CQD$IAO3 CQD$IA10 CQD$IA11 CQD$IA12
    CQD$IA40 CQD$IA41 CQD$IA42 CQD$IA43 CQD$IA50 CQD$IA51 CQD$IA52
    CQD$IA60 CQD$IA61 CQD$JC00 CQD$JD00 CQD$JE00 CQD$JE01 CQD$KA10
    CQD$KA11 CQD$KA12 CQD$KA20 CQD$KA21 CQD$KA22 CQD$KA23 CQD$KA4A
    CQD$KA40 CQD$KA41 CQD$KA42 CQD$KA43 CQD$KA44 CQD$KA45 CQD$KA46
    CQD$KA47 CQD$KA48 CQD$KA49 CQD$KC10 CQD$KC11 CQD$KC12 CQD$KC13
    CQD$KFC0 CQD$KFC1 CQD$KFC2 CQD$K000 CQD$K100 CQD$K200 CQD$K610
    CQD$K611 CQD$K612 CQD$K613 CQD$K614 CQD$K615 CQD$K616 CQD$K710
    CQD$K711 CQD$K712 CQD$K830 CQD$K831 CQD$K832 CQD$K833 CQD$K834
    CQD$K835 CQD$K836 CQD$K837 CQD$L8B0 CQD$L8B1 CQD$L810 CQD$L811
    CQD$L812 CQD$L813 CQD$L910 CQD$L911 CQD$L912 CQD$L913 CQD$L914
    CQD$MEE0 CQD$MEH0 CQD$MEP0 CQD$MEP1 CQD$ME10 CQD$ME11 CQD$M40A
    CQD$M40B CQD$M40C CQD$M40D CQD$M400 CQD$M401 CQD$M402 CQD$M403
    CQD$M404 CQD$M405 CQD$M406 CQD$M407 CQD$M408 CQD$M409 CQD$M50A
    CQD$M50B CQD$M50C CQD$M50D CQD$M500 CQD$M501 CQD$M502 CQD$M503
    CQD$M504 CQD$M505 CQD$M506 CQD$M507 CQD$M508 CQD$M509 CQD$M510
    CQD$M511 CQD$M512 CQD$M513 CQD$M514 CQD$M515 CQD$N110 CQD$N120
    CQD$N4A0 CQD$N4A1 CQD$N6@0 CQD$N810 CQD$N811 CQD$N812 CQD$N813
    CQD$N830 CQD$N831 CQD$N832 CQD$N850 CQD$N851 CQD$N852 CQD$N860
    CQD$N861 CQD$N862 CQD$N870 CQD$N871 CQD$N880 CQD$N881 CQD$N890
    CQD$N891 CQD$N892 CQD$N893 CQD$N894 CQD$PDBD CQD$V910 CQD$Y0#E
    CQD$Y0#M CQD$Y0@E CQD$Y0@M CQD$Y0AE CQD$Y0AM CQD$Y0KE CQD$Y0KM
    CQD$Y0LE CQD$Y0LM CQD$Y0ME CQD$Y0MM CQD$Y0NE CQD$Y0NM CQD$Y0OE
    CQD$Y0OM CQD$Y0WE CQD$Y0WM CQD$Y0XE CQD$Y0XM CQD$Y0YE CQD$Y0YM
    CQD$Y0ZE CQD$Y0ZM CQD$Y01E CQD$Y01M CQD$Y02E CQD$Y02M CQD$Y03E
    CQD$Y03M CQD$Y04E CQD$Y04M CQD$Y05E CQD$Y05M CQD$Y06E CQD$Y06M
    CQD$Y07E CQD$Y07M CQD$Y08E CQD$Y08M CQD$Y1$E CQD$Y1$M CQD$Y1#E
    CQD$Y1#M CQD$Y1@E CQD$Y1@M CQD$Y1AE CQD$Y1AM CQD$Y1BE CQD$Y1BM
    CQD$Y1CE CQD$Y1CM CQD$Y1DE CQD$Y1DM CQD$Y1VE CQD$Y1VM CQD$Y1WE
    CQD$Y1WM CQD$Y1XE CQD$Y1XM CQD$Y1YE CQD$Y1YM CQD$Y1ZE CQD$Y1ZM
    CQD$Y12E CQD$Y12M CQD$Y13E CQD$Y13M CQD$Y14E CQD$Y14M CQD$Y15E
    CQD$Y15M CQD$Y19E CQD$Y19M CQD$Y20E CQD$Y20M CQD$Y21E CQD$Y21M
    CQD$Y22E CQD$Y22M CQD$Z0#0 CQD$Z0@0 CQD$Z0A0 CQD$Z0K0 CQD$Z0L0
    CQD$Z0M0 CQD$Z0N0 CQD$Z0OA CQD$Z0OB CQD$Z0OC CQD$Z0OD CQD$Z0OE
    CQD$Z0OF CQD$Z0OG CQD$Z0OH CQD$Z0OI CQD$Z0OJ CQD$Z0OK CQD$Z0OL
    CQD$Z0ON CQD$Z0OO CQD$Z0OP CQD$Z0OQ CQD$Z0OR CQD$Z0OS CQD$Z0O0
    CQD$Z0O1 CQD$Z0O2 CQD$Z0O3 CQD$Z0O4 CQD$Z0O5 CQD$Z0O6 CQD$Z0O7
    CQD$Z0O8 CQD$Z0O9 CQD$Z0W0 CQD$Z0X0 CQD$Z0Y0 CQD$Z0Z0 CQD$Z010
    CQD$Z011 CQD$Z020 CQD$Z030 CQD$Z04A CQD$Z04B CQD$Z04C CQD$Z040
    CQD$Z041 CQD$Z042 CQD$Z043 CQD$Z044 CQD$Z045 CQD$Z046 CQD$Z047
    CQD$Z048 CQD$Z049 CQD$Z050 CQD$Z060 CQD$Z061 CQD$Z062 CQD$Z070
    CQD$Z071 CQD$Z072 CQD$Z080 CQD$Z1$0 CQD$Z1#0 CQD$Z1@0 CQD$Z1A0
    CQD$Z1B0 CQD$Z1B1 CQD$Z1C0 CQD$Z1D0 CQD$Z1D1 CQD$Z1V0 CQD$Z1W0
    CQD$Z1X0 CQD$Z1Y0 CQD$Z1Z0 CQD$Z120 CQD$Z121 CQD$Z122 CQD$Z130
    CQD$Z131 CQD$Z140 CQD$Z141 CQD$Z150 CQD$Z151 CQD$Z190 CQD$Z191
    CQD$Z192 CQD$Z200 CQD$Z210 CQD$Z220 CQD$0E0E CQD$0E0M CQD$0F0E
    CQD$0F0M CQD$1A0E CQD$1A0M CQD$1E0E CQD$1E0M CQD$110E CQD$110M
    CQD$120E CQD$120M CQD$2AAE CQD$2AAM CQD$2ABE CQD$2ABM CQD$2ALE
    CQD$2ALM CQD$2AME CQD$2AMM CQD$2AOE CQD$2AOM CQD$2A1E CQD$2A1M
    CQD$2A2E CQD$2A2M CQD$2A4E CQD$2A4M CQD$2A5E CQD$2A5M CQD$2A6E
    CQD$2A6M CQD$3C0E CQD$3C0M CQD$3D0E CQD$3D0M CQD$3E0E CQD$3E0M
    CQD$4A1E CQD$4A1M CQD$4A2E CQD$4A2M CQD$4A4E CQD$4A4M CQD$4C1E
    CQD$4C1M CQD$4FCE CQD$4FCM CQD$400E CQD$400M CQD$410E CQD$410M
    CQD$420E CQD$420M CQD$461E CQD$461M CQD$471E CQD$471M CQD$483E
    CQD$483M CQD$58BE CQD$58BM CQD$581E CQD$581M CQD$591E CQD$591M
    CQD$6EDE CQD$6EDM CQD$6EPE CQD$6EPM CQD$640E CQD$640M CQD$650E
    CQD$650M CQD$651E CQD$651M CQD$66HE CQD$66HM CQD$711E CQD$711M
    CQD$712E CQD$712M CQD$74AE CQD$74AM CQD$781E CQD$781M CQD$783E
    CQD$783M CQD$785E CQD$785M CQD$786E CQD$786M CQD$787E CQD$787M
    CQD$788E CQD$788M CQD$789E CQD$789M CQD#ARCN CQD#BCOM CQD#BDIR
    CQD#BRGN CQD#CPOL CQD#DBDI CQD#DBRC CQD#FSCD CQD#GMSG CQD#IDEF
    CQD#IMSR CQD#JESI CQD#MSG0 CQD#ODIR CQD#ORGN CQD#RACB CQD#TRAC
    CQD#XACB CQDCCMAL CQDCCMSL CQDCCUHL CQDCDRCK CQDCDSFR CQDCDSOP
    CQDCDSRD CQDCFIIC CQDCGSIO CQDCGTIF CQDCIDCL CQDCINIC CQDCMRFU
    CQDCMTCL CQDCOPDM CQDCPRSE CQDCSDBD CQDCSVCL CQDCS1HD CQDCTGOP
    CQDCTSAL CQDCTSOP CQDCTSRD CQDCTVCL CQDCTVOP CQDCTVRD CQDCTVTK
    CQDCVPAL CQDCVPCL CQDCVPEV CQDCXMEN CQDCXMND CQDDBRCT CQDDYNAL
    CQDFDBRC CQDFDJCL CQDFDMDA CQDGNMP1 CQDIMSA1 CQDIMSB1 CQDIMSC1
    CQDIMSDB CQDIMSD1 CQDIMSE1 CQDIMSOF CQDIMS91 CQDLTENU CQDMGENU
    CQDMODST CQDOACDA CQDOAPDR CQDOBOFU CQDOBOSU CQDOBRID CQDOBRTV
    CQDOBRXM CQDOCOSE CQDOCOSK CQDODARU CQDOHOPA CQDOHTRU CQDOINAS
    CQDOIO31 CQDOLIAD CQDOLIAN CQDOLIBD CQDOLIBN CQDOLINK CQDOLI9D
    CQDOLI9N CQDOMASM CQDOPCSX CQDOPMS  CQDOPPA  CQDOPST  CQDOPVT
    CQDORXDM CQDOSGMG CQDOSLOG CQDOSVTP CQDOTBRU CQDOVPMG CQDPB
    CQDSEQIN CQDSEQOU CQDSIN00 CQDSMFT1 CQDSQLAD CQDSQLAN CQDSQLBD
    CQDSQLBN CQDSQL9D CQDSQL9N CQDSQ2AD CQDSQ2AN CQDSQ2BD CQDSQ2BN
    CQDSQ29D CQDSQ29N CQD1PROC HQDCC10J
    

Fix information

  • Fixed component name

    QMF DATA SERVIC

  • Fixed component ID

    566872103

Applicable component levels

  • RC10 PSY UI46739

       UP17/04/29 P F704

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