IBM Support

PM73732: SPREADSHEET INPUT DATA GENERATOR

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Provide SPREADSHEET Input Data GENERATOR for smarter analytics
    of DB2 trace data
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Batch Reporting                          *
    *                 -   Performance Database users               *
    ****************************************************************
    * PROBLEM DESCRIPTION: V510 only:                              *
    *                      Missing support of accelerator metrics  *
    *                      (IBM DB2 ANALYTICS ACCELERATOR) in      *
    *                      Performance Database.                   *
    *                                                              *
    *                      V510 and V511:                          *
    *                      Generic spreadsheet utility needed      *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: V510:                                        *
    *                 Apply this PTF if you want to store          *
    *                 accelerator metrics in the Performance       *
    *                 Database.                                    *
    *                                                              *
    *                 V510 and V511:                               *
    *                 Apply this PTF if you want to create input   *
    *                 data for spreadsheet analysis.               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    V510:
    Provide DDL statements for the creation of accelerator tables
    in the Performance Database.
    
    V510 and V511:
    Provide utility for creation of spreadsheet input data.
    
    PROBLEM CONCLUSION:
    V510:
    Provide DDL statements for the creation of accelerator tables
    in the Performance Database.
    
    V510 and V511:
    Provide utility for creation of spreadsheet input data.
    

Problem conclusion

Temporary fix

Comments

  • V510:
    Provide DDL statements for the creation of accelerator tables
    in the Performance Database.
    
    V510 and V511:
    Provide utility for creation of spreadsheet input data.
    
    KEYWORDS : PERFORMANCE DATABASE ACCELERATOR SPREADSHEET
               GENERATOR
    ×**** PE13/04/15 PTF IN ERROR. SEE APAR PM87043  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PM73732

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    510

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-09-26

  • Closed date

    2012-12-12

  • Last modified date

    2017-06-21

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

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

    UK90267 UK90268

Modules/Macros

  •    BPOMAB00 BPOMAB01 BPOMAB02 BPOMAXA0 BPOQADTL
    BPOQAEXT BPOQALVP BPOQARDT BPOQCREP BPOQECHP BPOQELVP BPOQESCD
    BPOQFCAT BPOQFCDT BPOQFUGB BPOQFWAT BPOQFWCA BPOQFWGB BPOQIREC
    BPOQIREP BPOQPRNT BPOQRPDT BPOQRPGT BPOQRPST BPOQRUDT BPOQRUGT
    BPOQRUST BPOQSPAT BPOQSPCA BPOQSPGB BPOQSRGB BPOQSUGB BPOQTPFA
    BPOQTPFG BPOQXPFA BPOQXPFG BPOQXSCD BPOQZREC BPOQZREP DGO@BTCH
    DGO@CONV DGO@CRDP DGO@DB   DGO@LLOG DGO@LOAD DGO@MIG1 DGO@MIG2
    DGO@PC1  DGO@PC2  DGO@PC3  DGO@PC4  DGO@SCRD DGO@SP   DGO@SQPA
    DGO@TBL  DGOAACUM DGOABFXC DGOABORD DGOABORE DGOABSDF DGOABSGE
    DGOABSPK DGOABSXC DGOACALC DGOACFXC DGOACMER DGOACOMP DGOACREC
    DGOACSDF DGOACSGE DGOACSPK DGOACSXC DGOADFXC DGOADIST DGOADNOR
    DGOADSDF DGOADSGE DGOADSPK DGOADSXC DGOADYNA DGOAEXIT DGOAEX20
    DGOAFILE DGOAFISA DGOAFLAT DGOAFORM DGOAIREC DGOAIREP DGOALFXC
    DGOALSDF DGOALSGE DGOALSPK DGOALSXC DGOALUMP DGOAMORE DGOAMSGS
    DGOAMTRC DGOAQKEY DGOARCAL DGOAREDB DGOAREDC DGOAREDD DGOAREDG
    DGOAREDI DGOAREDM DGOAREDP DGOAREDR DGOAREDX DGOASAVE DGOATOPR
    DGOATPRC DGOATRAC DGOATREC DGOAUPDB DGOAZMER DGOAZREC DGOBGENL
    DGOBMAIN DGOBMODL DGOBSELL DGOCVYAT DGOCVYDB DGOCVYDE DGOCVYEP
    DGOCVYFO DGOCVYFR DGOCVYFT DGOCVYGN DGOCVYHO DGOCVYID DGOCVYIX
    DGOCVYLA DGOCVYLO DGOCVYLV DGOCVYOW DGOCVYPK DGOCVYPL DGOCVYSQ
    DGOCVYTB DGODIDAT DGODIVAL DGODTERM DGOEC000 DGOEINIT DGOER000
    DGOETERM DGOFECAL DGOFEDAT DGOFEPKG DGOFPCRS DGOFPDAT DGOFPECO
    DGOFPEPC DGOFPE15 DGOFPE35 DGOFPINT DGOFPRIC DGOFPRMC DGOFPRPC
    DGOFPSIC DGOFPVCD DGOFP000 DGOFUCAL DGOFUCA1 DGOFUFAC DGOFUFDI
    DGOICREC DGOIIREC DGOIIREP DGOIPAIR DGOIPBUF DGOIREXT DGOIUNMA
    DGOIZREC DGOIZREP DGOLAEOF DGOLCREC DGOLIREC DGOLIREP DGOLREXT
    DGOLSPSH DGOLZREC DGOLZREP DGOMAIO0 DGOMAXA0 DGOMEDSN DGOMERPL
    DGOMEXA0 DGOMEXA1 DGOMEXA2 DGONFILE DGOPACNV DGOPA830 DGOPA840
    DGOPA920 DGOPMHDR DGOPMICO DGOPMIC1 DGOPSCNV DGOPS830 DGOPS920
    DGORAEXT DGORASCN DGORCREC DGORCREP DGORCRE2 DGORIREC DGORIREP
    DGOROADB DGOROPVR DGORPACC DGORPHVA DGORPIOA DGORPMIN DGORPPAG
    DGORPPAR DGORPRID DGORPSCA DGORPSUS DGORPUDF DGORRCAP DGORRCOM
    DGORRDAT DGORREXI DGORRHIL DGORRHVA DGORRIOA DGORRLOC DGORRMIS
    DGORRSOR DGORRSQL DGORRTHR DGORUACC DGORUIND DGORUSUM DGORUWRK
    DGORZREP DGOSACMG DGOSACUM DGOSACU2 DGOSAPAW DGOSAPTS DGOSA199
    DGOSBGEN DGOSBLKX DGOSBORD DGOSBORE DGOSBXCL DGOSCGEN DGOSCXCL
    DGOSDGEN DGOSDLTD DGOSDXCL DGOSFILE DGOSFMTS DGOSGENS DGOSI199
    DGOSI225 DGOSI369 DGOSLGEN DGOSLXCL DGOSPREP DGOSREDC DGOSREPG
    DGOSREPM DGOSRMGS DGOSSAVE DGOSSPSH DGOSSTDA DGOSSWSR DGOSS199
    DGOSTRAC DGOSUPDB DGOS199R DGOS199T DGOTBPRT DGOTBWKL DGOTCCHK
    DGOTCCOP DGOTCDIV DGOTCLOD DGOTCRCO DGOTCREB DGOTCREO DGOTCREP
    DGOTIREC DGOTIREP DGOTMSGS DGOTPRNT DGOTZREC DGOTZREP DGOVBMG
    DGOVCCP  DGOVCINI DGOVCRDB DGOVDB2C DGOVDB2F DGOVDB2I DGOVDIVU
    DGOVDMSG DGOVDS   DGOVDSIN DGOVDSRC DGOVDSS  DGOVEEDI DGOVEEDR
    DGOVEEDS DGOVEEDT DGOVEE00 DGOVEE01 DGOVEPAI DGOVHMCD DGOVHMDR
    DGOVHMM0 DGOVHMM1 DGOVHMS1 DGOVHMTC DGOVHMTX DGOVHM00 DGOVISI
    DGOVISIT DGOVMB   DGOVMDSP DGOVMIDI DGOVMMXM DGOVMRAP DGOVMSTR
    DGOVMUAE DGOVM001 DGOVM002 DGOVPIG0 DGOVPP0  DGOVPP1  DGOVPP2
    DGOVPP3  DGOVPP4  DGOVPP5  DGOVPUPD DGOVRGM1 DGOVRG01 DGOVRG02
    DGOVRG03 DGOVRG04 DGOVRG10 DGOVRG11 DGOVRG12 DGOVRG13 DGOVRG20
    DGOVRG21 DGOVRG22 DGOVRG23 DGOVRG24 DGOVRG25 DGOVRG26 DGOVRG27
    DGOVRG28 DGOVRG4B DGOVRG4C DGOVRG4X DGOVRPRM DGOVRSFI DGOVRTG1
    DGOVSADK DGOVSCON DGOVSERI DGOVSUBS DGOVTCPD DGOVTCPL DGOVTCPS
    DGOVTCPT DGOVTSEX DGOVUAS0 DGOVUINI DGOVUM00 DGOVUM01 DGOVUM02
    DGOVUSS0 DGOVWDOG DGOVXMSG DGOVZAP  DGOWCREC DGOWFILE DGOWF106
    DGOWF107 DGOW1FIL DGOXCREC DGOXIREC DGOXIREP DGOXZREC DGOXZREP
    DGOYA100 DGOYDPC0 DGOYDPM0 DGOYMAIN DGOYUMSG DGOZBIND DGOZBTCH
    DGOZBTC2 DGOZCONV DGOZCOPY DGOZCRDC DGOZCRDP DGOZCRDS DGOZCRDW
    DGOZDB   DGOZDB2M DGOZDMDB DGOZECB  DGOZFL1  DGOZFL2  DGOZFL3
    DGOZJEND DGOZLLOG DGOZLOAD DGOZMB   DGOZMIG1 DGOZMIG2 DGOZPC1
    DGOZPC2  DGOZPC3  DGOZPC4  DGOZPRSE DGOZSCRD DGOZSP   DGOZSQPA
    DGOZSUB1 DGOZTBL  DGOZUAUT DGOZWFE  DGOZWIE  DGOZWJE  DGOZWSE
    FPE@DB2S FPE@WRPA FPE@WRP2 FPE@WR2C FPECHASY FPECHDMP FPECHDUP
    FPECHECO FPECHE15 FPECHE35 FPECHGVR FPECHNMP FPECHTRN FPECKECO
    FPECMAIN FPECMDAT FPECQECO FPECQE15 FPECQE35 FPECSORT FPECVBOO
    FPECVCIF FPECVCIG FPECVCOL FPECVCRS FPECVDDO FPECVDFT FPECVDIC
    FPECVDTC FPECVDTO FPECVFLC FPECVFRO FPECVGLC FPECVGNT FPECVGOL
    FPECVGSL FPECVICM FPECVINO FPECVKDC FPECVLAO FPECVLIO FPECVLVO
    FPECVMAB FPECVOJS FPECVOPO FPECVORO FPECVPAC FPECVPEX FPECVPIE
    FPECVQMF FPECVRDT FPECVRID FPECVRIN FPECVRMC FPECVRMP FPECVRPL
    FPECVRSP FPECVRTN FPECVRTZ FPECVSPO FPECVSRB FPECVSRD FPECVSST
    FPECVSZB FPECVTOO FPECVTOP FPECVTYO FPECVVCD FPECVVFN FPECVVFO
    FPECVWRK FPEFWENU FPEFWJPN FPEMEXA0 FPEMMAIN FPEPAFBU FPEPAFDF
    FPEPAFGE FPEPAFGP FPEPAFPK FPEPAFXC FPEPASBU FPEPASDF FPEPASGE
    FPEPASGP FPEPASPK FPEPASRF FPEPASXC FPEPCGM  FPEPCIM  FPEPCLM
    FPEPCSHD FPEPCSV  FPEPCSVA FPEPCSVB FPEPCSVJ FPEPCSVP FPEPCSVS
    FPEPPRM  FPEPSBUF FPEPSDDF FPEPSGBP FPEPSGEN FPEPSSET FPEPSXCL
    FPEPTKM  FPEUCBLD FPEUCBPR FPEUCXDL FPEUCXIB FPEUDMPS FPEUFDB2
    FPEUFDSN FPEUFFER FPEUFFE2 FPEUFIOI FPEUFIO2 FPEUFI24 FPEUFOCR
    FPEUFOC2 FPEUFRCA FPEUFTDS FPEUFTS2 FPEUFUIS FPEUFUIT FPEUFUNI
    FPEUFUN2 FPEUFWMG FPEUFWMX FPEUFYDY FPEUFYD2 FPEUFYLD FPEUFYST
    FPEUFYS2 FPEUHUGO FPEUIFCI FPEUIFC2 FPEUMSGS FPEUPRNT FPEUT040
    FPEVDBXT FPEVDB2C FPEVDB2I FPEVDB2S FPEVDB22 FPEVDB23 FPEVDB24
    FPEVDPM0 FPEVDSM0 FPEVFTM  FPEVMSGI FPEVMST1 FPEVMST2 FPEVM000
    FPEVRAC  FPEVRACF FPEVRDS1 FPEVSERV FPEVTMEM FPEVWRPA FPEVWRP2
    FPEVWR2C FPEVZMAI FPEVZRAC FPEZCRD  FPEZPMS  HABFXC   HABSDF
    HABSGE   HABSPK   HABSXC   HACFXC   HACSDF   HACSGE   HACSPK
    HACSXC   HADFXC   HADSDF   HADSGE   HADSPK   HADSXC   HKDB510J
    HKDB511J HSBGEN   HSBXCL   HSCGEN   HSCXCL   HSDGEN   HSDXCL
    KDB510J  KDB511J  KO2INCAP KO2PRCAP KO2PUPDM KO2PUVLS TDKBIFI
    TDKUCBPR TDKUMSGT TDKVSSIM
    

Publications Referenced
GH12692300GH12696500SH12692701SH12696900SH12692102
SH12696300SH12692200SH12696400  

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R510 PSY UK90267

       UP12/12/15 P F212

  • R511 PSY UK90268

       UP12/12/14 P F212

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 June 2017