My EPV Introduction EPV products provide hundreds of

My EPV

Introduction • EPV products provide hundreds of reports out of the box, but sometimes specific reports are requested by our users • EPV architects decide whether these requests are of general interest or not • In the first case, new reports are added to EPV products, in the latter requests are dropped 2

1 st EPV customers FAQ • Is there a way within EPV to design user reports? • The answer is yes • The answer is My. EPV 3

Description and Goal My. EPV is an out-of-the-box solution that allows you to create customized HTML pages from your EPV databases or other sources Its goal is to provide an easy and practical way to create HTML reports very quickly in order to identify and solve system performance issues and create management reports needed by the organization 4

Input • • EPV for z/OS databases EPV for Db 2 databases EPV for WMQ databases EPV for z/LINUX databases EPV z. Parser databases USER databases created with EPV Virtually all the data tied to EPV concepts And more … 5

Exploiting EPV technology My. EPV reports will be published in the EPV standard layout with all EPV functions available, thus filling the gaps with what we provide, and what you really need My. EPV reports are integrated in the EPV standard products menu My. EPV submenu is automatically built based on the structure and reports you create 6

Exploiting EPV technology 7

Architecture My. EPV is based on a set of ready-made templates which can be easily customized and adapted to design an unlimited number of customer specific reports and publish them on the EPV intranet web site To run My. EPV you can execute line commands or schedule a. bat or. sh file which includes all the calls, one for each template, to the My. EPV program My. EPV can run on Windows, z. Linux, Linux or Unix 8

Report examples – Step 1 9

Report examples – Step 1 <WHERE_SQL> transactname = 'R 124' </WHERE_SQL> <GROUPBY_SQL> epvdate, transactname </GROUPBY_SQL> <ORDERBY_SQL> epvdate DESC </ORDERBY_SQL> <TABLE_COLUMNS> <COLUMN> <NAME> epvdate </NAME> </COLUMN> <NAME> transactname </NAME> </COLUMN> <NAME> ctrans </NAME> <FORMULA> sum(ctrans) </FORMULA> </COLUMN> </TABLE_COLUMNS> 10

Report examples – Step 2 11

Report examples – Step 2 <WHERE_SQL> transactname = 'R 013' or transactname = 'R 016' or transactname = 'R 087' or transactname = 'R 088' or transactname = 'R 091' or transactname = 'R 092' or transactname = 'R 099' or transactname = 'R 124' </WHERE_SQL> <TABLE_COLUMNS> <COLUMN> <NAME> epvdate </NAME> </COLUMN> </TABLE_COLUMNS> 12

Report examples – Step 2 <TRANSPOSED_COLUMN> <NAME> transactname </NAME> </COLUMN> </TRANSPOSED_COLUMN> <TRANSPOSE_STAT_COLUMNS> <COLUMN> <NAME> ctrans </NAME> <FORMULA> sum(ctrans) </FORMULA> </COLUMN> </TRANSPOSE_STAT_COLUMNS> 13

Report examples – Step 3 14

Report examples – Step 3 <TRANSPOSE_STAT_COLUMNS> <COLUMN> <NAME> ctrans </NAME> <FORMULA> sum(ctrans) </FORMULA> </COLUMN> <NAME> avgcpu </NAME> <FORMULA> sum(totcputm) / sum(ctrans) </FORMULA> </COLUMN> <NAME> avgelap </NAME> <FORMULA> sum(totelap) / sum(ctrans) </FORMULA> </COLUMN> </TRANSPOSE_STAT_COLUMNS> 15

Report examples – Step 4 16

Report examples – Step 4 <COMBO_COLUMN> $TRANSPOSE_STAT_COLUMNS </COMBO_COLUMN> 17

Report examples – Step 5 18

Report examples – Step 5 19

Report examples – Step 5 <TABLE_COLUMNS> <COLUMN> <NAME> epvdate </NAME> <LABEL> Date </LABEL> </COLUMN> </TABLE_COLUMNS> <TRANSPOSED_COLUMN> <HEADER> <HDRLABEL> Transaction Name </HDRLABEL> <COLUMN> <NAME> transactname </NAME> </COLUMN> </HEADER> </TRANSPOSED_COLUMN> 20

Report examples – Step 5 <TRANSPOSE_STAT_COLUMNS> <COLUMN> <NAME> ctrans </NAME> <FORMULA> sum(ctrans) </FORMULA> <LABEL> Executions </LABEL> </COLUMN> <NAME> avgcpu </NAME> <FORMULA> sum(totcputm) / sum(ctrans) </FORMULA> <LABEL> Average_CPU_Time </LABEL> </COLUMN> <NAME> avgelap </NAME> <FORMULA> sum(totelap) / sum(ctrans) </FORMULA> <LABEL> Average_Elapsed_Time </LABEL> <ALERT> >0. 5: y, >1: r </ALERT> </COLUMN> 21 </TRANSPOSE_STAT_COLUMNS>

Report examples – Step 6 22

Report examples – Step 6 <TABLE_COLUMNS> <COLUMN> <NAME> epvdate </NAME> <LINK> Y </LINK> <LABEL> Date </LABEL> </COLUMN> </TABLE_COLUMNS> <TRANSPOSED_COLUMN> <HEADER> <HDRLABEL> Transaction Name </HDRLABEL> <COLUMN> <NAME> transactname </NAME> <LINK> Y </LINK> </COLUMN> </HEADER> </TRANSPOSED_COLUMN> 23

Report examples – Step 7 24

Report examples – Step 7 <MAIN_PAGE> N </MAIN_PAGE> <HTML_MAIN_FILENAME> CICS_R_APPL_TREND </HTML_MAIN_FILENAME> <HTML_TBLTITLE> Throughput by Day </HTML_TBLTITLE> <PAGE_REPEAT_COLUMN> epvdate </PAGE_REPEAT_COLUMN> 25

Report examples – Step 8 26

What can you do with it ? – Automate manual reports 27

What can you do with it ? – Automate manual reports – Service Levels reporting 28

What can you do with it ? – Automate manual reports – Service Levels reporting – Cost Accounting 29

The limit is your imagination… 30

My. EPV major advantages • It runs outside of the mainframe on any Windows, z. Linux, Linux or Unix system • Only basic SQL language skills are required • No HTML development programming skills required • All the reports are in standard, navigable HTML static pages; only a browser is required • All the reports can be exported to MS Excel with just a mouse click • Report production can be automated and tied to EPV batch processes 31

My. EPV pre-requisites • Valid EPV for z/OS or EPV for z/OS SAS based license and maintenance • EPV for z/OS customers also need My. SQL or SQL Server 32

My. EPV pricing Licensing • My. EPV license is based on a onetime fee • Licensing is based on the number of systems licensed for EPV for z/OS and is not based on the power of the machine or the power used • The first year’s maintenance is included, but in subsequent years customers have only to pay the maintenance fee • The maintenance fee includes all releases and new versions of the product 33

Contacts Support: • epv. support@epvtech. com Info: • epv. info@epvtech. com Partners: • laura. seror@epvtech. com Marketing and Sales: • mark. cohen@epvtech. com • danilo. gipponi@epvtech. com • fabio. ottaviani@epvtech. com Local partner: • To be added by each partner 34

35