CMG 2007 MXG Vendor Session December 5, 2007 San Diego, California
• I. WPS Technical Notes • • 1. Current Status of MXG testing WPS 2. Run time comparisons 3. Revisions to SAS Clone Article 4. Summary • II. Major enhancements in 25. 11 since 24. • III. MXG 25. 11 is very close to final 25.
1. Current status of MXG testing under WPS Betas in November, 2007. a. MXG QA compile-only (dummy INFILEs) TYPExxx and TYPSxxxx members This exercised the MXG DATA-step Code for compile errors, and created DOCVER to compare the contents of WPS-built datasets (variables, LENGTHs, LABELs, FORMATs). Steps 1 thru 36 of the QAJOBXX were tested. -Default BUILDPDB with 480 MB SMF File -Tailored BUILDPDB with IMACEXCL with 480 MB SMF File -TYPETPMX with small file - verified 72 position FORMATs worked. -TYPENTSM with test file - verified open-system-style MXG code. b. WPS Betas were often updated daily, and as errors were encountered in MXG tests on z/OS and Windows/XP, a new Beta was generated which did correct each error that could be fixed short-term. The current Beta tested was World Programming System 2. 02 (02. 00. 08458) of Nov 27.
c. MXG Version 25. 11 is required for testing under WPS; its updates eliminate the need for user modifications to MXG Software, and new WPS-specific members (CONFIGW 2, MXGWPSV 2, JCLINSTW, AUTOEXEW) were added. d. Facilities used by MXG Software not yet in WPS for z/OS: INFILE CCHHR option - needed only for TYPEEREP (EREP, SYS 1. LOGREQ) VIEWS - for CPU & I/O performance, used in VMXGSUM. invoked over 60 time in QA BUILDPDB, and in all ASUMxxxx and TRNDxxxx members. Eliminates a full pass of the input data. PROC CONTENTS - minor, does not report High Block Used size. e. Facilities used by MXG Software not yet in WPS for z/OS and Windows: INFILE with ftp access method - performance slower, more disk space SAS/GRAPH, SAS/STAT, SAS/ETS, etc. Currently WPS supports the Base DATA Step Support and a few PROCs, including PRINT, MEANS, CONTENTS, GPLOT, GCHART, with more planned. f. Output differences - minor PROC MEANS printed output - some values printed with one digit more resolution by WPS. - no error in output values spot checked - prevents automated output comparisons
g. Untested - most due to complexity or time to set up multiple inputs: WPS Workbench – Interactive Human Interface – VERY different Uses Eclipse Significant Learning Curve DATA Libraries on TAPE WEEKBLDT, MNTHBLD special TAPE format to DISK, DISP=MOD, etc. TESTTRND, TESTANAL - requires extensive test data ANALxxxx - requires test data ASUMxxxx - except ASUMJOBS, ASUM 70 PR were tested. UTILxxxx - specialized utilities for MXG Tech Support Internal SORT - on z/OS, internal SAS SORT may be required when BY list variables aren’t in first 4096. NFS Files - not tested. Broken VBS files - not tested.
h. Migration issues - see WPS Migration Instructions: On z/OS, copy all archived SAS Data Libraries on DASD (including HSM migrated) to tape (Sequential) format with the SAS System first. WPS can read SAS Data Libraries in SEQUENTIAL format on tape or DASD. WPS cannot read DASD format SAS Data Libraries i. Customer reports: Several MXG customers have been running their BUILDPDB on z/OS. Early tests had to make source-level-changes to a few MXG members. Most had relatively simple BUILDPDBs with minimal tailoring.
j. MXG Support Position for testing of WPS Release: MXG 25. 11 and WPS 2. 2 or later are required. Your current MXG Software License Agreement states: Merrill agrees to provide continuous product support for MXG in the following areas: When error conditions (i. e. , the SAS® execution of MXG code produces either a return code or an ABEND) are the results of errors in MXG Code, they will be corrected. If you encounter an error testing MXG under WPS: You should report the error to WPS Technical Support for initial investigation. If WPS support believes the error is an MXG problem, they can contact MXG, or may choose to refer you to MXG Support may then request you to send data to MXG: - the raw data file that caused the error - your site's USERID. SOURCLIB (tailoring) source library(s) If the error can be replicated under the SAS System, it will be corrected per our license terms.
2. Run time comparisons: BUILDPDB, ASUMJOBS, ASUM 70 PR with 448 MB SMF File z/OS Comparison CPU TCB minutes Elapsed minutes ------ Compressed --------Work Size PDB Size CICSTRAN Size SAS: 3. 88 5. 20 209 MB 55 MB 59 MB WPS: 10. 67 18. 50 233 MB 59 MB 67 MB Windows/XP Comparison SAS: 1. 20 2. 18 Note 1 65 MB 63 MB WPS: 1. 93 2. 71 Note 1 78 MB 70 MB z/OS tests were executed on IBM 2094 CPU Model S 08, SU_SEC=9708. Windows tests were executed on Intel Duo Core T 5500 @ 1. 66 GHz. Note 1: Neither WPS nor SAS provide a way to track maximum work space on ASCII
3. Revisions to SAS Clones article in MXG Technical Newsletter FIFTY: WPS is no longer vapour-ware. The company has bent over backwards to provide corrections. Performance of WPS, when written in JAVA, was so poor (run times were at least ten times worse than the current Beta) that the product no longer uses JAVA, so it cannot exploit ZAAP engines. Items listed in sub-paragraphs i, iii. , and iv. have all been addressed to my satisfaction, with the exception of the items that are listed above in this note. Pricing has been significantly reduced from those original IBM prices. As an example, an MXG site in the USA was quoted an IBM price for a 21 Value Unit system (about 1000 MIPS) of $42, 000 first year and $8, 400 for renewals. WPS can be licensed through IBM or through World Programming; their home page is at http: //www. teamwpc. co. uk
4. Summary: Most of MXG has compiled successfully under WPS on both z/OS and Windows/XP. BUILDPDB has compiled and processed SMF data on both z/OS and Windows/XP. A lot of MXG still needs to be tested with data. WPS is still in development. WPS will roll this Beta into a GA release of WPS 2. 2 this week. WPS on z/OS requires thrice the CPU and Elapsed Run Time of SAS. WPS on Windows/XP CPU and run times are similar to SAS run times. Disk Space required on both platforms are similar. So, it is your choice at this time to test MXG under WPS. And, it's your evaluation of your MXG programs that should determine if you believe that WPS is "Ready for Prime Time" at your site, with your current CPU and run times and the MXG programs that you utilize.
5. QA Steps successfully compiled and executed with dummy input. STEP 3. CREATE FORMAT LIBRARY STEP 4. RUN TESSNT STEP 5. RUN TESSIBM STEP 6. RUN TESSIBM 1 STEP 7. RUN TESSIBM 2 STEP 8. RUN TESSIBM 3 STEP 9. RUN TESSUSER STEP 10. RUN TESSUSR 1 STEP 11. RUN TESSOTHR STEP 12. RUN TYPSCMHM STEP 13. RUN BUILDPD 3+ASUMS STEP 14. RUN BUILDPDB+ASUMS STEP 15. RUN TYPERMFV STEP 16. RUN TYPECMFV+TYPEMVCI STEP 17. RUN TESSHSM STEP 18. RUN TESSFACO
STEP STEP STEP STEP STEP 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. RUN TESSVM RUN TESSCRAY RUN TESSHPCS RUN TESSUNIA RUN TESSUNIK RUN TESSQAPM RUN TESSQACS RUN TESSTUX RUN TESSPW RUN ASUMPRTR RUN TYPEIMS 7 RUN TESSIMSD RUN COPYSTEP RUN TESSTRND - partially completed, not WPS fault. RUN TESSMNTH RERUN TYPE-S FOR NON PROC SORT FOR DATASET LABEL RUN CROSSREF RUN DOCVER - output DOCVER file is identical.
MXG Version 25. 11, dated Dec 6, 2007. In 7014 members 2, 297, 784 lines, creates 4278 datasets, 118, 561 variables. Major enhancements added in MXG 25. 11. TYPE 111 25. 241 TYPE 7072 25. 224 TYPETPMX TYPE 82 TYPEEVTA TYPE 85 TYPE 78 TYPEEVTA TYPERMFV TYPENTSM TYPETNG VMXGSUM UTILEXCL EXITCICS TYPE 110 UPRINDOC TYPE 30 ANALACTP CONFIGW 2 25. 239 25. 257 25. 255 25. 234 25. 236 25. 255 25. 246 25. 253 25. 221 25. 235 25. 248 25. 256 25. 240 25. 226 25. 260 25. 254 25. 252 Support for CICS CTG 7. 1. 0 new SMF 111 record. CPUTYPE tests are replaced with ZARCHMDE tests. This means that with MXG 25. 11 or later, a new IBM CPUTYPE will NOT require a new MXG Version. Support for Thruput Manager SLM and DB 2 data. Support for ISCF HCR 7750 TKE Logging update. Support for Action Software's Event. Action user SMF. New variables in OAM subtype 32 -35 records. Zero obs in TYPE 78 IO with Change 24. 171 if z/OS 1. 7. Support for Action Sofware's Event. Action SMF record. Updates for CPU Segmentation changes. Support for new NTSMF objects for MSSQL. Support for VM Ware VSX Systems in CA NSM records. New Solaris, AIX, and many Red. Hat objects added. New &LNSUMOUT=8 will make all output to length 8. Macro variable &MXGDEBUG revised for IMACEXCL plus! MCTSSCRL now tested vs MCTMNOPN for CICS Compressed. Utility prints NAME and LABEL of all variables. MXG 25. 10, INTRVLTM missing for TYPETASK='OMVS' Sample report summarizes DB 2 Package data to UOW. MXG updates for testing MXG Execution under WPS.
Major enhancements added in MXG 25. 10. TYPE 7072 TYPERMFV ANALDB 2 R TYPE 70 ASUMCELP TIMEBILD 25. 205 25. 204 25. 202 25. 212 25. 209 Support for z/OS 1. 9 up to 54 CPUs per MVS, INCOMPAT CFI Segmentation eliminates RMF III skipped CF data. VARIABLE QBn. TDPIO NOT FOUND error corrected. ZIPACTTM, PCTZIPBY corrected for Dedicated z. IIPs. Duplicate observations in PDB. ASUMCELP eliminated. Optional SYNC 59 timeshifting using TIMETABL. Major enhancements added in MXG 25. 09. IMPORTANT CHANGES: Almost none! UTILEXCL TYPERMFV TYPESRDF READDB 2 ANALDB 2 R RMFINTRV TYPE 89 UTILCSV UTILBLDP TYPE 92 25. 193 25. 191 25. 195 25. 189 25. 199 25. 198 25. 197 25. 196 25. 192 Only UTILEXCL in 25. 08 had an error, but these other fixes/enhancements are now ready for prime time: MXG 25. 08 ONLY: LABEL IMACICU 3 NOT FOUND. Support for RMF Monitor III CFI table enhancements. Support for EMC's SRDF/A user SMF record. New PDBOUT=YES, old PDBOUT= changed, writes to WORK. SMF 70 GIE now reset to 00/15 if SYNC 59=YES is used. SMF 89 HOF, SMF 89 DTO were incorrect due to typo. %UTILCSV creates a CSV (or TAB) Delimited flat file. Large &MACKEEP string caused strange results. New ID=92 ST=14 INPUT EXCEEDED if not a RENAME.
Major enhancements added in MXG 25. 08. IMPORTANT CHANGES: TYPETNG TYPE 7072 ASUM 70 PR TYPEQACS ADOCDB 2 TYPEDB 2 Many Doc 25. 181 25. 176 25. 163 25. 178 25. 172 25. 169 25. 179 Support for CA NSM Red. Hat 4. 01 Linux perf cube. Support for APAR OA 18244, Blocked Workload z/OS 1. 9. Support for Capacity Groups variables in TYPE 70. Capacity Group summarization, PDB. ASUM 70 GC/ASUM 70 GL. AS 400 APAR QAPMDISK with LRECL=456 added new data. Example to process DB 2 datasets to separate DDNAMES. _RDB 2 ACC DB 2 Parallel event "analysis" example. %UPCASE, %LOWCASE, %STR, %BQUOTE, %QUOTE, etc. Use %LET MACxxxx= %STR( text ) ; to pass text. Major enhancements added in MXG 25. 07. CRITICAL CHANGE: TYPE 78 25. 141 APAR OA 21799 for Hiper. PAV, ABEND, SMF 78 HIX invalid. Installing Hyper. PAV can create invalid RMF 78 -3's that cause BUILDPDB to ABEND as it reads RMF 78's. Change 25. 141 will detect bad records and avoid the ABEND, but you will need to install the IBM PTF for the APAR to correct the invalid data values.
IMPORTANT CHANGES/ENHANCEMENTS: Many TYPECIMS TYPE 74 TYPE 89 TYPE 80 A UTILLPDS TYPE 7072 TYPE 42 TYPEVMXA ASUM 70 PR ADOCITRM ADOCDB 2 ANALRMFR TYPERMFV UPCMEMDZ TYPE 71 VMXGINIT 25. 140 25. 139 25. 140 25. 138 25. 137 25. 136 25. 135 25. 153 25. 151 25. 150 25. 149 25. 148 25. 146 25. 145 25. 144 25. 143 Prelim z/OS 1. 9 (fails if 54 -CPs, See Ch 25. 205) Support for IMF Version 4. 3 (INCOMPATIBLE). APAR OA 17070 supports CF Level 15 measurements. Support for APAR OA 20314 new SMF 89 LPN/SMF 89 ZNA. Support for unknown TOKDANAMs, prevents ABEND. Utility to count used/defined PDS Directory Blocks. LCPUCAP/LCPUCAPC Labels include "Hard CAP". MXG 25. 06 only, false INVALID TYPE 42 SUBTYPE 5 error. 180 Error _MPRCAPC not found, DEBUG prints removed. ASUM 70 PR created PCTCPUBY GT 100%, final fix? ASUM 70 PR now supports INTERVAL/CECINTRV=SHIFT. Doc. Maps ITRM dataset names to MXG name. Doc. How to create DB 2 ACCTB/DB 2 ACCTP in separate DDs. ERROR: NO DATASETS TO LOOKUP correction. RMF III dataset ZRBLCP missing obs for many LPARs. ASCII utility to determine memory available to MXG. SWAPrates were set missing if zero, now can be zero. New MXGMISS macro variable changes TYPE 71 SWAPrates.
Major enhancements added in MXG 25. 06. TYPE 30 TYPE 110 EXITCICS TYPEBTE TYPE 80 A TYPEFERT TYPECLAR TYPE 119 TYPESYNC ASUMUOW ASUMHSM IHDRIDMS TYPENMON TYPERACF TYPE 80 A 25. 116 25. 041 25. 107 25. 131 25. 133 25. 130 25. 119 25. 117 25. 121 25. 113 25. 112 25. 110 25. 134 25. 131 MXG 25. 05, negative EXECTM, INTRVLTM, GMTOFF 30 wrong. Support for CICS/TS 3. 2 (INCOMPATIBLE). INFILE Exit for CICS/TS 3. 2 SMF record compression. Support for CA Brightstor Tape Encryption SMF. Support for CRL PUBLISH and SET UID RACFEVNT 52, 79. Support for Williams Data FERRET product user SMF. Support for Clarion Disk Array flat files. SMF 119 from z/OS 1. 8 caused INVALID DATA messages. INVALID ARGUMENT due to incorrect HEX 4/HEX 3 formats. Enhanced to keep each CICS segment response time. HSM Summary enhanced with "HSM COMPLEX" HSMPLEX. CA IDMS Perf. Mon support enhanced with "IHDR" exit. Support for DISKBUSYn for all NMON Disk Monitoring. Support for IRRDBU 00 record types 0560, 0561, 0562. Support for TOP SECRET (INCOMPAT) '90'x, '00'x VRSN.
MXG Version 25. 05, dated Jun 7, 2007. Major enhancements added in MXG 25. 05. TYPEITRF TYPENMON TYPEDB 2 TYPE 30 CONFIGV 9 UTILBLDP 25. 103 25. 104 25. 090 25. 097 25. 089 25. 101 25. 098 Support for IBM OMEGAMON TRF ITRF V 550 and V 560. Full support for NMON, Nigel's Monitor for AIX/unix. Support for PK 37354 SMF 101 Subtype 4 in DB 2 9. Variable THREADTY blank if non-DDF transaction. GMTOFF 30 calculation corrections and problems. MEMLEAVE=10 M SORTBLOCKMODE now set in CONFIGV 9 %UTILBLDP(BUILDPDB=JES 3. . . enhancement.
Major enhancements added in MXG 25. 04. TYPE 21 TYPEXAM TYPENMON SYSLOG TYPENDM DALYTAPE TYPERMFV TYPEDB 2 TYPETMS 5 ANALDB 2 R UTILBLDP VMXGRMFI VMXGUSE FORMATS Doc 25. 083 25. 082 25. 073 25. 070 25. 081 25. 072 25. 079 25. 064 25. 075 25. 084 25. 068 25. 071 25. 065 25. 069 25. 067 25. 063 25. 078 Fix for support for APAR OA 20077 Device Bytes TYPE 21. Support for XAM Release 3. 6, many new data. Support for LPAR and IOADAPTR Nigel's NMON data. Support for SYSLOG file enhanced, all records output. Support for NDM-CD type 'NM' records creates NDMNM. Sample tape reports from STC VTS SMF + MXGTMNT. ZRBLCP dataset had only first LPARs observations. Several QISE variables were wrong. QBGL variables in DB 2 V 8. 1 now supported, were wrong. FILSEQ in TMS. DSNBRECD could be wrong, mult-vol-file. SQL Text QW 0141 TX was not printed, coding error. Products that need deaccumulation now protected. Default list of ASUMxxx to be included, MXGINCL=. Service Class Names can be "wild-carded" Revised to invoke _STY 70; UTILBLDP recommended. Additional SWAP reason codes added to $MG 079 SR. List of MXG-issued USER ABEND values & source member.
Major enhancements added in MXG 25. 03. CONFIGV 8 TYPE 119 TYPE 1415 TYPE 21 TYPEAIXT TYPESAMS TYPETDS TYPECSM TYPSCOCR VMXGDUR TYPEHSM ASUMTAPE ASUMUOW ASUMCEC BLDSMPDB 25. 037 25. 035 25. 047 25. 040 25. 039 25. 055 25. 052 25. 050 25. 034 25. 042 25. 040 25. 054 25. 053 25. 048 SORTEQUALS should NOT have been in CONFIGV 8, V 9 only. Support for SMF 119 for z/OS 1. 8 (INCOMPATIBLE). Support for APAR OA 19502, SMF 14 KET Key Exchange Time Support for APAR OA 20077, uncompress read/write bytes Support for AIX Tapas-C performance data files. Support for SAMS objects 2151, 2226, 2229 and 2231. Support for TDSLink Version 630 ZCOST datasets. Support for Cross. Sysplex. Manager user SMF record. Support for Copy. Cross (now VTF Mainframe 2. 1. 0) SMF. Interval= QUARTER, SEMIANN, ANNUAL now supported. Process HSM with different SMF IDs/different SYSTEMs. Uncompress read/write SMF 21 DBR/DBW kept in ASUMTAPE. QWACSPCP, QWACTRET added to PDB. ASUMUOW for OTE. PDB. ASUMCEC, PCTCPUBY GT 100%, DURATM LT CECINTRV. Corrections to BLDSMPDB, new SORTEDBY= option.
Major enhancements added in MXG 25. 02 was created to protect sites who set the NOSORTEQUALS option (i. e. , changed the SORTEQUALS default). NOSORTEQUALS causes invalid data in ASUM 70 PR-built datasets. CONFIGV 9 25. 028 VMXG 70 PR 25. 028 OPTION NOSORTEQUALS caused errors in ASUM 70 PR. Other New Support and corrections added in MXG 25. 02: ASMTAPEE ANALRMFR TYPE 42 DS TYPE 70 VMXGPRAL UCOMPSOE ANALFIOE 25. 033 25. 032 25. 030 25. 028 25. 026 Support for ASMTAPEE ML-40 assembly under z/OS IRD corrections to RMF reports. TYPE 42 DS had carried-forward IOCOUNT and other IORATEn per-engine I/Os corrected for IRD. Print All utility now compares all datasets in Utility to compare SORTEQUALS and NOSORTEQUALS Divide by zero message protected. 1. 8. vars. LIBs. output
Major enhancements added in MXG 25. 01. The MXG 24. 24 Annual Version is VERY solid, with only these three relatively minor corrections: TYPENTSM 25. 015 TYPE 7072 25. 013 ASUM 70 PR 25. 001 INCOMPAT MXG CHANGE for NTSM WEEKly requires action. PCTMVSBY in PDB. TYPE 70 PR was wrong if IRD was active. NRICFCPU, NRIFLCPU were wrong if you have more than 1. Other New Support and corrections added in MXG 25. 01: TYPEIMS 7 TYPEBVIR TYPE 74 EXITCICS IMACICMR IMACICOB IMACICOM 25. 006 25. 011 25. 025 25. 003 25. 017 25. 008 Support for IMS Version 10 (INCOMPATIBLE) IMS log. Support for TS 7700 SMF records. Support for APAR OA 19453 for 4 -byte LOSTRECS count. NREXPOSR was wrong for Hyper. PAV devices. New "CICS" INFILE EXIT for CICS compressed SMF data. Optional CICS CMRDATA, CMDUDATA/CMDDBCCP reversed. Optional CICS OMDBDB 2 LN now spelled as OMBDB 2 LN. Optional CICS OMMLN now spelled as OMMQLN. Please read CHANGESS for the complete list of major enhancements. See member NEWSLTRS or the Newsletters frame at www. mxg. com for current MXG Technical Notes that used to be in CHANGES.
Скачать презентацию CMG 2007 MXG Vendor Session December 5 2007
6e49368dfec41e684d79f41597d62266.ppt