58

Rebind best practices

Date: 
Wednesday, 28 May, 2014 - 08:30 - 09:15
Program: 
z/OS Track
Speaker: 
Cristian Molaro

DB2 LUW - keeping your server in good condition

Date: 
Thursday, 29 May, 2014 - 09:00 - 16:00
Program: 
LUW Track
Speaker: 
Klaas Brant

This one day seminar is a number of best practices in many areas. It is a great resource for experienced DBA’s how question themselves if they are doing the right thing.
Topics:
- Configuring your server
- Fix packs and upgrades
- Table space and bufferpool strategy
- Security and audit
- Collecting performance data / tuning
- Runstats and Reorg
- Your recovery strategy

DB2 10.5 for LUW with BLU Acceleration and New Features

Date: 
Thursday, 29 May, 2014 - 09:00 - 16:00
Program: 
LUW Track
Speaker: 
Melanie Stopfer

This one-day class is designed to describe the major technical features and enhancements provided by DB2 for Linux, UNIX and Windows database 10.5 software. A key feature of DB2 LUW 10.5 is new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration. Additional new features in DB2 LUW 10.5 will also be covered.
After completing this class, you should be able to:
• Implement column-organized table support for a new or existing DB2 database
• Describe how the column dictionaries used to provide extreme compression of column-organized tables are built and utilized
• Explain the impact of setting the DB2 registry variable DB2_WORKLOAD to ANALYTICS
• List the seven ‘big ideas’ that work together to provide DB2 BLU acceleration
• Describe the different storage used for column-organized table compared to row-organized tables
• Explain how DB2 uses a synopsis table to support data skipping with column-organized tables
• Monitor a DB2 database or application that uses column-organized tables
• Use db2convert or ADMIN_MOVE_TABLE to convert row-organized tables to column-organized tables
• Explain the support for large row sizes with DB2 10.5
• Use DB2 Version 10.5 create an index that contains an expression-based key
• Monitor DB2 10.5 databases and instances using SQL table functions MON_GET_DATABASE and MON_GET_INSTANCE
• Recovery enhancements will also be discussed.

DB2 for z/OS Memory Management Masterclass

Date: 
Thursday, 29 May, 2014 - 09:00 - 16:00
Program: 
z/OS Track
Speaker: 
Julian Stuhler

This class will consist of a comprehensive look at the architecture, management and performance tuning issues associated with DB2 for z/OS system storage, and is aimed at DB2 for z/OS Systems Programmers and DBAs wishing to enhance their knowledge of DB2 memory management and tuning in V9, V10 and beyond.
Attendees will leave with a good understanding of how to monitor and tune critical storage areas including Bufferpools, the EDM Pool, the Dynamic Statement Cache and the Coupling Facility. Both Virtual and Real Storage tuning will be covered in-depth and at the end we’ll peek into the near future with a look at how DB2 11 and zEC12 hardware improvements will impact DB2 memory management.

DB2 10 for z/OS - In Depth

Date: 
Thursday, 29 May, 2014 - 09:00 - 16:00
Program: 
z/OS Track
Speaker: 
Phil Grainger

More automated install
Catalog restructure (to UTS)
Deprecation of Plans with DBRMs, old plan_table formats, DB2 Private Protocol, classic partitioned table spaces
 
Performance
Out of the box up to 10% cpu savings
Hash access to data
Include columns in indexes
In-line LOBs
Dynamic statement cache improvements
Dynamis SQL stability and the access path repository
 
Availability
On-line schema evolution and deferred alter
Data "as of" last commit
Reorg Aux table improvements
Recover backout
Security
Row and column level access control
Finer administrator privileges
Administrator privileges without data access
New audit abilities
 
Productivity
Immediate compression
LISTDEF partition range support
REORG SHRLEVEL CHANGE enhancements
Temporal data
SQL PL improvements
Moving sum and average
 
XML
XML schema validation in z/OS
Multi versioning of XML data
XML update, insert and delete
XML schema as column modifier
CHECK DATA for XML
 
And much MUCH more

DB2 for z/OS: Practical performance

Date: 
Thursday, 29 May, 2014 - 09:00 - 16:00
Program: 
z/OS Track
Speaker: 
Cristian Molaro
DB2 performance is key in application success, user satisfaction and cost savings. This session is a pragmatic guide to DB2 for z/OS performance. It covers exploiting DB2 accounting and statistics traces for health checking and problem resolution on DB2 10 and DB2 11 for z/OS. It focuses on providing the understanding required to allow you to get performance results. It is the result of hands-on experiences, teaching and writing about DB2 for z/OS performance for many years. 
 
Topics include: 
•Where should I start? 
•Effective use of the statistics and accounting traces 
•Health checking DB2 
•Exploiting the performance tools at hand 
•Dynamic SQL 
•Monitoring real storage 
•I/O performance 
•Typical performance quick wins 
•Surviving big amounts of Data 
•Long Term Monitoring 
•Building an effective alerting system 
•What is new in DB2 11?

STMM good or bad?

Date: 
Wednesday, 28 May, 2014 - 10:15 - 11:00
Program: 
LUW Track
Speaker: 
Cristian Molaro

Is it wise to turn on STMM?  Why not? How does it work and what are its limitations? Instead of looking at it as on/off we look at a hybrid solution

Best Practices for Temporal Data Management in DB2

Date: 
Wednesday, 28 May, 2014 - 09:00 - 10:00
Program: 
LUW Track
Speaker: 
Melanie Stopfer

With the comprehensive features for temporal data management in DB2, database administrators and application developers face numerous choices in database and application design. They also encounter new situations for the maintenance of database objects and historic data. 

This session describes best practices for designing temporal databases, managing temporal database objects, and developing temporal applications. The guidelines also cover topics such as temporal data modeling, schema design, temporal performance, and tips for coding efficient temporal queries and temporal updates.

DB2 Workload manager

Date: 
Tuesday, 27 May, 2014 - 16:00 - 17:00
Program: 
LUW Track
Speaker: 
Cristian Molaro

DB2 Workload Manager (WLM) is not very popular. Maybe because most people don’t know what it can do or how to use it. We will discuss it features and how it can be implemented

What is new in HADR

Date: 
Tuesday, 27 May, 2014 - 15:00 - 16:00
Program: 
LUW Track
Speaker: 
Melanie Stopfer

The HADR feature in DB2 LUW is very popular. IBM has added some new features in 10.1. We will discuss what is possible and what is wise. We also have a look at how it impacts licensing.

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