74

OMG! Experience is a Hard Teacher – Lessons Learned that You Should Know!

Date: 
Thursday, 15 June, 2017 - 09:00 - 16:00
Program: 
LUW Track
Speaker: 
Melanie Stopfer
In the past few years, there have been times that DB2 has tested customers before they could learn the lesson.  Come to this presentation and let me teach you the lessons learned so you are ready for your next DB2 LUW “pop” quiz.  By learning from others mistakes, you can learn how to make things right.
Objective 1: Utilizing product enhancements and features that make your life easier.
Objective 2: Tips and Techniques to get the most from DB2 Utilities.
Objective 3: Getting more out of your error messages by decoding the secrets.
Objective 4: Monitoring, tuning and more!
Objective 5: Many more lessons learned will be discussed

Panel Discussion

Date: 
Wednesday, 14 June, 2017 - 13:15
Program: 
LUW Track

Power of db2pd - Monitor and Troubleshoot Your World

Date: 
Wednesday, 14 June, 2017 - 12:30 - 13:15
Program: 
LUW Track
Speaker: 
Melanie Stopfer

The db2pd command is a powerful tool for monitoring and administering DB2 Linux, UNIX and Windows databases and instances. You can use this tool to keep track of transactions, table spaces, table statistics, dynamic SQL, configuration settings and much, much more.<br />Melanie will compare using SQL statements versus db2pd commands for troubleshooting, problem determination, performance tuning, environment analysis and more. 

Materialized Query Tables - Deep Dive

Date: 
Wednesday, 14 June, 2017 - 11:30 - 12:30
Program: 
LUW Track
Speaker: 
Melanie Stopfer

Materialized Query Tables (MQTs) are widely used to significantly speed up the response time of decision support queries. A MQT is a table whose definition is based on the result of a query and whose data is in the form of precomputed results. Learn how to deploy MQTs. Through examples, learn steps necessary to create, maintain and use MQTs. MQT maintenance and trade-offs associated with various approaches will be analyzed. Learn about MQT matching, which is the process DB2 uses to transparently answer queries against base tables using precomputed query results stored in MQTs. Advanced uses and the benefits of MQTs with advanced query optimization techniques will be discussed. 

Break

Date: 
Wednesday, 14 June, 2017 - 11:00 - 11:30
Program: 
LUW Track

Using In-Database Analytics with DB2 and dashDB

Date: 
Wednesday, 14 June, 2017 - 10:00 - 11:00
Program: 
LUW Track
Speaker: 
Mark Murnane

DB2 and dashDB offer several features for applications to push down predefined or user-defined analytics functions into the database engine. Such push down provides better performance and data governance characteristics than traditional approaches. This session explains how to use in-database analytics features such as clustering and regression algorithms, user-defined aggregate functions, in-database scoring with SAS and SPSS, as well as data analysis and visualization with R. 

DB2, the foundation of IBM's data platform strategy

Date: 
Wednesday, 14 June, 2017 - 09:00 - 10:00
Program: 
LUW Track
Speaker: 
Les King

Latest news on IBM's overall Hybrid data platform strategy and the Watson Data Platform approach.  This will include high level updates on the dashDB family, BigInsights with BigSQL, Spark, DB2 and the next generation appliance.

Central Archival of DB2 diagnostic logs

Date: 
Tuesday, 13 June, 2017 - 16:00 - 17:00
Program: 
LUW Track
Speaker: 
Roland Schock

How do you manage DB2 logging in a bigger environment? Collect the logfiles of all instances in a central location and do a offline analysis with big data methods.

DB2 Memory Management -- Have You Lost Your Memory?

Date: 
Tuesday, 13 June, 2017 - 15:00 - 16:00
Program: 
LUW Track
Speaker: 
Melanie Stopfer

Dig into the nuts and bolts of Memory Management.  Melanie will describe the details of management of instance-level memory, database-level shared memory and application memory for DB2 databases. Automated Memory Management using Self Tuning Memory Manager will also be addressed. The configuration and use of each memory heap will be described. The monitoring of memory usage using SQL statements, db2mtrk and db2pd command reports will be presented.

Do it Right! Upgrade to DB2 LUW V11.x

Date: 
Tuesday, 13 June, 2017 - 14:00 - 15:00
Program: 
LUW Track
Speaker: 
Melanie Stopfer

Are you responsible for upgrading your database to DB2 LUW 11? Take advantage of the new DB2 great functionality. Unlock the secrets. If you need a detailed step-by-step approach to implement the newest version of DB2 LUW 11, come learn about often overlooked but very important best practices to understand before and after upgrading. Satisfy your ever increasing demands to analyze business data quickly and get insights into your data.

Syndicate content  

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023