63

What Application Developers need to know about SQL in DB2 for z/OS?

Date: 
Monday, 15 June, 2015 - 14:15 - 15:15
Program: 
z/OS Track
Speaker: 
Denis Tronin
Speaker: 
Philippe Dubost
Applications often rely on a Database to manipulate data, typically using SQL statements. DB2 for z/OS is one of those databases; one of the most robust, reliable and secure for that matter. However, Application Developers need to keep in mind that DB2 for z/OS has its SQL specificities. For instance, the SQL available in DB2 for z/OS is compliant with SQL:2003 standard. What does it exactly mean? What IBM is doing to raise the level of the DB2 SQL to later standards? How does this affect Application Developers – ever heard of APPLCOMPAT? What are the new SQL capabilities introduced in DB2 over the years? Is there something new in this area when using DB2 10 or DB2 11?
In this session, you will learn about :
  • Incompatible SQL changes in DB2 for z/OS
  • How to address incompatible SQL changes  
  • New SQL capabilities in DB2 for z/OS

Break

Date: 
Monday, 15 June, 2015 - 13:15 - 14:15
Program: 
z/OS Track

Performance and Availability in DB2 11

Date: 
Monday, 15 June, 2015 - 11:45 - 13:15
Program: 
z/OS Track
Speaker: 
Susan Lawson
With every new release of DB2 we look to see what features will allow us to improve the performance of our existing applications and the availability of our data. We also begin to plan to utilize new feature in our development efforts. This presentation takes a look at the features in DB2 11 that will both improve our performance and provide us with maximum data availability.
  • Discuss overall improvements and migration goals in DB2 11
  • Discuss features for improved application and database performance
  • Discuss features for improved data availability
  • Discuss implementation and expectations of these new features

Break

Date: 
Monday, 15 June, 2015 - 11:30 - 11:45
Program: 
z/OS Track

Fast Track to Optimal DB2 for z/OS Performance

Date: 
Monday, 15 June, 2015 - 10:30 - 11:30
Program: 
z/OS Track
Speaker: 
Namik Hrle

Tuning DB2 application to achieve optimal DB2 performance does not need to be a complex exercise. A large majority of problems can be easily solved and the only challenge is connecting the problem symptom with its underlying causes. This presentation offers you a simple methodology to answer the challenge. It starts by a straightforward way to identifying activities in which problem transaction spends time and follows by concrete, targeted corrective actions. Numerous ready to use hints and tips are included to maximize the presentation's practical value.

The DB2 11 catalog – something new, something old, something changed

Date: 
Monday, 15 June, 2015 - 09:30 - 10:30
Program: 
z/OS Track
Speaker: 
Steen Rasmussen

Every new release of DB2 introduces changes to the DB2 repository – AKA The catalog or DSNDB06. Digesting the catalog changes can be the quickest method to adopt what the new release is about, schema changes, new object types and attributes, new Bind parameters and deprecated components. This session will provide a detailed overview of the catalog changes between DB2 10 and DB2 11 and the associated schema changes.

Introduction

Date: 
Monday, 15 June, 2015 - 09:00 - 09:30
Program: 
z/OS Track

Networking Event

Date: 
Sunday, 14 June, 2015 - 20:00 - 23:30
Program: 
CA Day

Q & A

Date: 
Sunday, 14 June, 2015 - 19:30 - 20:00
Program: 
CA Day

What is CA MSM/E?

Date: 
Sunday, 14 June, 2015 - 18:45 - 19:30
Program: 
CA Day
Speaker: 
Maddalena Tosoni
CA Mainframe Software Manager (MSM) was the main pillar of CA’s Mainframe 2.0 strategy launched in 2009. Six years on and 500 customers later, we are at a turning point in the history of MSM. 
Join Maddalena Tosoni (CA CSM/MSM Product Manager) in an open discussion about the Roadmap and  the future Strategy of one of the most loved CA Mainframe products to date.
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