63

DBA update 10.1 and 10.5

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Thursday, 18 June, 2015 - 09:00 - 16:00
Program: 
LUW Track
Speaker: 
Klaas Brant
Have you recently upgraded to 10.1 or 10.5? Are you planning to do so soon? Then you would like to know all the details of what's new and changed! And there is a lot more to tell then just BLU. This seminar will not only tell you about all the new options but also teaches you the practical use of many new features. After this update you completely up to date with the latest releases AND the many changes in the fix packs. A must for every LUW DBA / Administrator!
 
Topics:
Upgrading to 10.1 and 10.5
What's changed , deprecated and discontinued?
Automatic Storage, Storage Groups and Multi-temperature storage
Row and Column Access Control (RCAC) in practice
HADR enhancements
Compression & encryption enhancements
New DDL options
Dealing with deadlocks & timeouts
What's new with the utilities
Using DB2 as NOSQL (JSON support)
Clients & drivers enhancements
New DB2pd & DB2 Support options
BLU enhancements & future
SQL/PL Enhancements

Introduction DB2 LUW for experienced DBA’s

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Thursday, 18 June, 2015 - 09:00 - 16:00
Program: 
LUW Track
Speaker: 
Cristian Molaro
This seminar is designed to leverage your database and IT skills into the world of DB2 for Linux, Unix, and Windows. Cristian will discuss the basis of how DB2 works, what you need to know to get started as best as possible, and what are the common mistakes to avoid. He will highlight the differences and similarities with other databases, and will show the best ways of getting more information. A pragmatic approach that focuses on helping you to become a proficient DB2 professional in a more efficient way. This presentation covers current DB2 releases
 
Are you a DB2 for z/OS, SQL Server, Oracle experienced user looking for a fast path into DB2? This day has been created for you! Cristian will teach you the major commands and differences with other databases
 
Topics:
 
Introduction to DB2
  • What is DB2 for Linux, Unix, and Windows?
  • DB2 editions & DB2 licensing
  • DB2 LUW vs. DB2 for z/OS
The DB2 architecture
  • Instances and databases
  • Table Spaces
  • Tables, Indexes, and Large Objects
  • DB2 logging
  • Buffer Pools
  • Storage Groups / Automatic Storage
  • Partitioning
  • Compression
  • Table compression
The DB2 working environment
  • DB2 Command Line Processor (plus)
  • IBM Data Studio and other GUI tools
  • Application enablement
  • Default locking settings
  • Working with packages
  • SQLJ and pureSQL
  • Java development considerations
  • Explain
  • The DB2 Advisors
  • SQL for cross-platform development
The DB2 deployment options
  • High Availability (HADR) and PureScale
  • BLU for analytics
  • Interaction with DB2 z/OS and other databases
System topics
  • Installing, updating and upgrading DB2
  • IBM Data Server Clients and Driver Packages
  • Automatic Database Maintenance
  • Using database tools and utilities
  • Backup and recovery at a glance
  • Performance tools at a glance
Security

Panel Discussion

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Wednesday, 17 June, 2015 - 13:00
Program: 
LUW Track

Improving performance without touching the SQL

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Wednesday, 17 June, 2015 - 11:30 - 12:30
Program: 
LUW Track
Speaker: 
Klaas Brant

The majority of the performance problems is caused by bad SQL. How case you test, find and solve some problems without touching the SQL? In this session we will look at DB2BATCH, DB2 Design Advisor, and some performance snapshots to analyze and fix problems.

Break

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Wednesday, 17 June, 2015 - 11:00 - 11:30
Program: 
LUW Track

How compression works

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Wednesday, 17 June, 2015 - 10:00 - 11:00
Program: 
LUW Track
Speaker: 
Klaas Brant

DB2 can compress data. How does it work? Is it needed? To compress or not to compression, that’s the question! Once you know how it works and when it is good for you then you can also identify the cases when not to use it. Next to compression there is encryption. When to use encryption? Should it / Can it be combined with compressions. This sessions discusses the details.

DB2 pureScale explained

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Wednesday, 17 June, 2015 - 09:00 - 10:00
Program: 
LUW Track
Speaker: 
Cristian Molaro
This session discusses the key value features of DB2 pureScale. It will help to understand how this technology works and what are its strengths.
The focus is on describing the functionality, the applicability, and the synergy opportunities of DB2 pureScale.
It also provides with an update on recent improvements and features.

SQL/PL for stored procs and more

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Tuesday, 16 June, 2015 - 16:00 - 17:00
Program: 
LUW Track
Speaker: 
Klaas Brant

Most people know you can build SQL/PL stored procedures. But you can do other things with it as well. You can use it for triggers or UDFs for example. Let’s take a closer look what you can do with it. The open source monitoring... is Cristian’s topic. Attached is the last version of the agenda we got from Zeljen. I have 5 topics (the four I did send + SQL/PL) 

Help, I have a problem!

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Tuesday, 16 June, 2015 - 15:00 - 16:00
Program: 
LUW Track
Speaker: 
Klaas Brant

Under normal conditions DB2 is not too difficult to handle. But there might be a day that DB2 decides that it is time for trouble. Where to find information. Where to start and what tools do we have available. This session will introduce you to: DB2DIAG, DB2PD, DB2DART and INSPECT

New locking options & monitoring deadlocks / timeouts

Seminar: 
European SQLAdria Seminar – Dubrovnik 2015
Date: 
Tuesday, 16 June, 2015 - 14:00 - 15:00
Program: 
LUW Track
Speaker: 
Klaas Brant

DB2 sneaked in a new option which became the default called “currently committed”. What is it and why did it become the default? If I upgraded should I switch it on? Another issue which keeps DBAs busy are deadlocks and timeouts. In this sessions we will review what causes it and who you can start a low overhead event monitor to detect them.

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 2024

VODICE -  10th - 13th June 2024