Highlights in Speedgain for DB2 V5.2 Revised Zoom Page Speedgain Indexes Module improvements Support for DPF Refined filter option in the Speedgain Client Speedgain SQL Workbench improvements UI revise for more comfort and usability Enhanced support for Virtual Indexes Create and manage Virtual Indexes during access path analyzes Generate a benefit analyzes for virtual and real indexes of an access plan Bulk DDL generation for multiple virtual indexes of a single access plan Export and Import of access plans Improved HADR Monitoring DB2 v11.5 support read more –ITGAIN Speedgain V5.2 whats new

What's new – Overview andHighlights in Speedgain for DB2 V5.1 Data Retention (former: maintenance) Smaller footprint for old data (store performance data of 2 years with same resources as 30 days as of version 5.0) Level of detail configurable by age of data (full resolution last 7 days, five minutes resolution last month, 30 minutes resolution last 6 month, 60 minutes resolution last 2 years, purge older data) Base for long term trends, reports, references and comparison Reference Lining Define reference days (like best Monday report generation, last month end calculation) Add metrics of reference day to current seen metrics Easy compare of e.g. today to last weeks Monday Enhanced Reporting More included default ITGAIN reports New UI Elements to improve usability Enhanced reporting facility to improve speed and concurrency read more –ITGAIN Speedgain V5.1 whats new

permanent benchmarks on database server? Impossible? No, not with the End2End Monitoring within Speedgain for Db2 – see it liveat@idugdb2 EMEA 2018 – booth 12. More details onhttps://bit.ly/spg4db2#ibm #db2 @SpeedgainforDb2 #IDUGDb2. Also the new DataStage Produkcts: JobBulider for DataStage and the Framework for DataStage to get the right ETL Automation. see more onhttps://bit.ly/automation4ETL And get info how to use outr mainframe tools – online infohttps://bit.ly/mainframeoptimization See you at idug EMEA 2018 – booth 12

The first 3 trials within the EU over the entire period of 60 days, which we can accompany, will receive an Apple Watch Series 3 GPS. Within this time you will of course have full and free product support.This promotion is valid (start of the test phase) until 31 October 2018 and does not apply to existing customers. Speedgain for Db2 has developed considerably over time. Compared to other monitor solutions on the market, it offers a much wider range of functions. Experienced database administrators confirm that with Speedgain for Db2 they can find and fix bottlenecks faster and with less effort. Here’s a quote: Markus Fraune Database Administrator (Managed Service): “My first task in the morning is to look at Speedgain for Db2 and with just a few clicks I know all the essential metrics of the monitored database systems and what was going on on my systems that night. In addition, I already have alarms in my mailbox for serious problems and am therefore optimally prepared”. You always know the status of the monitored database systems. If key figures get worse, they see this immediately and can react early before it becomes a serious problem. Here is a selection of main functions which you will not or not like this find in other well-known Db2 monitoring solutions: Historical Monitoring Data Operating System Monitoring (Linux, AIX, Windows) Data Collection via UDF on the database Drill down approach – with a few clicks to the problem – it doesn’t get any better performance. Clear and understandable presentation of performance metrics. Chart based overviews with historical trends By drill down into the presentation of the detailed metrics in tabular form SQL Workload Comparison Integrated SQL workload set analysis Individual time windows with additionally definable filter conditions Check current workload against reference workloads DB2 Explain and Index Advisor SQL Workbench integrated Modern explain tree style Extensive table statistics Support via Db2 Index Advisor Build-in rules based Design Advisor Versatile reporting Extensible report function with the JasperReports library Assistance with custom report customization and integration Report archive in the own performance database Product support is provided directly by the development experts. We are looking forward to your feedback! More about Speedgain for Db2 –look here.

How?Defined job templates generate jobs and sequences for loading the DWH into the core layer. What do the supplied templates contain?All necessary modules of an ETL framework: Primary Key Lookup/Surrogate Key Generation, Harmonization, Historization,… The features are: Use of customer or ITGAIN assets Mapping document – automatically readable Framework – reusable modules Job Templates – defined and standardized Generation of jobs and sequences Mapping of 1:1 mappings Conversions according to DataStage Transformersyntax Higher value functions: customer-specific transformations Support for state-of-the-art modeling: particularly suitable for Data Vault, 3NF anchor Integration of design artifacts into Information Governance Catalog possible Your benefit is: Quality: Structured design and development process Standardized job processes Transparent traceable ETL processes Identical solutions for recurring ETL tasks Efficiency/Speed Very short development times in projects Fast familiarization with existing processes Reduced test effort due to quality-tested standard components Costs Lower development costs Reduced maintenance costs Interested?Try it out and request a trial license!

Identify – explain – break down Markus Fraune Database Administrator (Managed Service): „My first task in the morning is to look at Speedgain for Db2 and with a few clicks I know all the essential metrics of the monitored database systems and what was happening on my systems during the night. In addition, I already have alerts in my mailbox for serious problems and am therefore optimally prepared.“ Did you already know? The ITGAIN Performance Monitor Speedgain for Db2 offers more features out of the box than any other Db2 Performance Monitor. Here is a selection of the functions: Historical Monitoring Data Operating System Monitoring (Linux, AIX, Windows) Data Collection via UDF on the database Drill down approach – with a few clicks to the problem – it doesn’t get any better performance. Clear and understandable presentation of performance metrics. Chart based overviews with historical trends By drill down into the presentation of the detailed metrics in tabular form SQL Workload Comparison Integrated SQL workload set analysis Individual time windows with additionally definable filter conditions Check current workload against reference workloads DB2 Explain and Index Advisor SQL Workbench integrated Modern Explain tree style Extensive table statistics Support via Db2 Index Advisor Build-in rules based Design Advisor Versatile reporting Extensible report function with the JasperReports library Assistance with custom report customization and integration Report archive in the own performance database Product support is provided directly by the development experts. Convince yourself! Here you can apply for a non-binding test position: Get a trial license here. If you have any questions or are interested in an on-site or web presentation, please do not hesitate to contact us: Contact use here.

The JobBuilder integrates into an existing release and defect process. Jobs can be generated in each phase, but they can also be corrected manually. To change the specification and for defect treatments, use the following procedure with the JobBuilder: 1. Edit job template 2. Generate sample job 3. Test the template modification 4. Start the re-generation for all jobs based on the modified template 5. Wait 100 minutes and more than 100 jobs are updated 6. Test Deploy the re-generated jobs in production We will show you and convince you in 15 minutes – request a web session at more.about@itgain.de

Maximize your realization of ETL processes by more than 100%. Or do you still build your jobs in DataStage manually? From the idea to the product, from the adversities of our experience with projects with and around DataStage, it was obvious to improve something. Therefore we develop the fastest JobBuilder for DataStage. And also the corresponding framework. The result is metadata-driven generation of jobs and sequences. Creating, migrating and customizing hundreds of jobs takes just five minutes. A small insight can be found on our website athttps://www.itgain-is.de/en/etl-automation/ Interested? Try it? Gladly! Technical advice at +49 (0) 511 5151 3700 or via e-mail more.about(at)itgain(dot)de

1–5 October 2017 | Lisbon, Portugal ITGAIN Booth # 7 – we are looking forward to your visit :-)