79

Get Cozy with Db2 for z/OS REST Services

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Wednesday, 13 June, 2018 - 10:00 - 11:00
Program: 
z/OS Track
Speaker: 
Denis Tronin

Db2 RESTful API support has been introduced in release 11 of Db2 for z/OS and has strengthen Db2 position in the new mobile application era. This presentation will equip the audience with a good understanding of REST APIs in general as well as how to deal with them in Db2: administrators will learn how to create and maintain the services while developers will get familiar the Db2 specifics.

BUILT-IN Functions - I didn't know Db2 could do THAT!

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Wednesday, 13 June, 2018 - 09:00 - 10:00
Program: 
z/OS Track
Speaker: 
Steve Thomas
Were you aware than Db2 for z/OS now supports more than twice as many SQL BUILT-IN functions as it did 20 years ago? The World has moved on significantly from the basic Functions such as SUM, COUNT and AVG which were all that were available when many of us first learnt SQL. There are now well over 200 Functions supported providing a huge range of powerful features. As well as the basic data manipulation and Mathematical Functions you would expect there are advanced analytical capabilities, sophisticated array management and aggregation features, XML, Security and more, all provided out of the box. Unfortunately many users have not kept up to date with advances and we find Programmers still coding requirements manually in whatever language they are using when the Database itself could be doing much more of the heavy lifting. This session will review the current capabilities of the native BUILT-IN functions provided by Db2 for z/OS and will highlight some of the more useful ones. It will be valuable whether you’re a new Application Programmer or an experienced DBA looking for an update on SQL capabilities.

Mainframe as a Service: Sample a Buffet of IBM zOS Platform Excellence

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 16:30 - 17:00
Program: 
z/OS Track
Speaker: 
Tom Juhl

Let us share CA Technologies “Brightside” vision for how mainframe as a service could help break silos through a unified, enterprise grade toolset deployed mobile to mainframe. We will discuss how a menu of IBM z Systems® services can be intelligently configured and provisioned to deliver at scale delight for the entire IT team

DSNUTILU for fun and profit

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 15:45 - 16:30
Program: 
z/OS Track
Speaker: 
Emil Kotrč
Db2 for z/OS comes with a set of Stored Procedures that can help application developers to perform various administrative tasks. The main benefits of these procedures are their ease of use via the SQL CALL statement and the simplification of processes. One example of the supplied stored procedures is DSNUTILU, which allows Db2 utility operations from the application programs.
In this presentation we will show how to use DSNUTILU, we will discuss possible real life scenarios, and the benefits and drawbacks of its usage in local and remote application programs.
Objectives:
1. An overview of Db2 supplied stored procedures.
2. Description of DSNUTILU and examples of possible use cases.
3. Discussion of DSNUTILU benefits and drawbacks.

Beginning with Java and Java Stored Procedures in Db2 for z/OS

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 15:00 - 15:45
Program: 
z/OS Track
Speaker: 
Jan Marek
Java is not a new technology; Java Stored Procedures were introduced to Db2 for z/OS in version 7. With the recent z13, z14 and their Java improvements, the use of this technology might be extended. Let’s review the concept of Java Stored Procedures in Db2 for z/OS in this presentation, discuss how to write them and introduce the latest enhancements of Java on mainframe.   
Objectives:
• Recent enhancements of Java technology on mainframes 
• Major benefits of Java Stored Procedures 
• Overview of an environment 
• Writing and deploying Java Stored Procedures
• Common problems, performance and security considerations

Db2 for z/OS XML, JSON, and Spatial use cases in web/mobile environment

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 14:00 - 15:00
Program: 
z/OS Track
Speaker: 
Jane Man

Mobile/Web applications are becoming critical to enterprise success with requirement of managing data in database. Digital data that are location based can leverage DB2 spatial support. Mobile data that are transferred in 2 most commonly formats: JSON or XML, can use DB2 JSON and XML features. The coexistence of both relational data and flexible schema data in DB2 allow rapid delivery of applications while leverage existing DB2 qualities of services. 

Break

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 13:00 - 14:00
Program: 
z/OS Track

Db2 Analytics Accelerator V7 Technical Deep Dive

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 12:00 - 13:00
Program: 
z/OS Track
Speaker: 
Eberhard Hechler

This presentation describes various integration scenarios of the Db2 Analytics Accelerator. This includes integration best practices to use the Accelerator with Big SQL on the Hortonworks HDP platform, enabling SQL on Hadoop with Db2 for z/OS underpinned with the Accelerator as a federated data source. Furthermore, we describe the integration of the Accelerator with Machine Learning (ML) for z/OS and Data Science Experience (DSX) Local, and the benefit it represents for specific use cases. This session provides feedback and concrete scenarios from client engagements

Break

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 11:45 - 12:00
Program: 
z/OS Track

Feedback and Profiles - is it a dream?

Seminar: 
European SQLAdria Seminar – Šibenik 2018
Date: 
Tuesday, 12 June, 2018 - 10:45 - 11:45
Program: 
z/OS Track
Speaker: 
Steve Thomas

This already exists and is actually one written by Steen Rasmussen and used with his permission although I will update it. It covers RUNSTATS profiles and the new SYSSTATFEEDBACK options provided by SQL where the Optimizer can tell you what Statistics are missing which might have allowed it to choose a better access path

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