Loading…

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

DB2 [clear filter]
Sunday, June 17
 

13:00

Modernize RPG Applications
This Workshop will show you how modern programming practices and tools can transform your old monolithic RPG applications into a modern, highly modularized form that will position your business for the future. Rather than just throw hours of theory at you, this seminar takes a sample application and follows it through the process of converting from RPG/400 or basic RPG IV to full usage of RPG IV and ILE features, modularizing the code, adding DB2 UDB features and preparing applications for use with a graphical or browser-based interface.AgendaModernizationThe right toolsThe Sample ApplicationMaking use of RPG IVMaking Use of the Database(Triggers and Referential Integrity)Real RPG - SubproceduresMaking Use of ILESubprocedures in Service ProgramsBeefing Up With SQLExternalizing

Speakers
avatar for Paul Tuohy

Paul Tuohy

ComCon and System i Developer
Paul Tuohy, IBM Champion and author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is a prominent consultant/trainer/educators for application modernization and development technologies on the IBM Midrange. He currently holds positions as... Read More →


Sunday June 17, 2018 13:00 - 17:00
Orchidea A

13:00

Creating and Consuming JSON with SQL
Abstract: JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON. With Release 7.3 TR 3 a bunch of scalar and aggregate functions were integrated into SQL, for generating JSON objects, arrays and for combining JSON components into complete documents. The JSON_TABLE tables function for consuming JSON data was already introduced with Release 7.3 TR 1. With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out. Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL http-functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed within a SELECT-Statement.Learning Objectives:Get an introduction into JSON basics. Learn how JSON object and arrays can be generated, concatenated or nested and composed into JSON documents. Discover how JSON documents located in either the IFS or a column of a table or JSON answers returned by web services can be parsed with the JSON_TABLE table function, converted into a relational representation and data specifically selected. You"ll also get an overview over the new http-functions and how to use them for getting access to web services.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Sunday June 17, 2018 13:00 - 17:00
Orchidea B

13:00

Experience Db2 Web Query First Hand!
You've heard about it, maybe you've even seen it before. But this constantly evolving product has moved from Query/400 modernization into powerful data discovery, data warehousing, and even integration with Watson. Come get some experience with Db2 Web Query for i - then feel the POWER!

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →


Sunday June 17, 2018 13:00 - 17:00
Gerbera B
 
Monday, June 18
 

09:45

Five Easy Steps to get a Quick Start with Db2 Web Query
You've heard about Db2 Web query but challenged with how to get started with this robust Business Intelligence software that you probably already own. In this session, we'll discuss the new EZ-Install package, and all that includes, and provide hints and tips to getting FAST value to ease your data gathering pains!

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →


Monday June 18, 2018 09:45 - 10:45
Gerbera A+B

09:45

Group By, Having and Multi-dimensional Grouping
Agenda: An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate functions allows to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value. The GROUP BY clause may be widely known and used, but the HAVING clause which goes hand in hand with the GROUP BY is often a mystery. There may be other secrets waiting for being revealed "¦ or did you know you can create all kinds of sub-totals and grand-total with an SQL GROUP BY?Lerning Objectives:In this session you"ll learn the basic use of the GROUP BY and HAVING clauses as well as the use of multiple aggregate functions. You"ll also discover how NULL values can affect the result returned by aggregate functions. It will be demonstrated how easily all kinds of sub-totals and grand-totals can be built. You"ll also learn how to use the CASE clause for building pivot tables.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Monday June 18, 2018 09:45 - 10:45
Orchidea A

11:00

IBM i Latest & Greatest 7.3, 7.2 & TRs
Come hear an overview of the capabilities of the currently available releases of IBM i. From major enhancements to Db2 to major security enhancements; from key advances in open source to new storage options; from performance analysis to being able to answer business questions with integrated SQL analytics, the most recent releases and Technology Refreshes have tremendous integrated power. This is a double-length session.

Speakers
avatar for Steve Will

Steve Will

Chief Architect - IBM i, IBM
Steve has worked on the IBM i operating system and its predecessors since the initial development of the AS/400. Since 2007, he has been the IBM i Chief Architect, responsible for the strategy of the operating system and the plan for future releases.


Monday June 18, 2018 11:00 - 12:00
Promenada

11:00

Handling the Weird Stuff in RPG Programs
In this session, Paul offers a practical guide to handling some of the more esoteric problems in RPG programs (whether using native I/O and Embedded SQL) such asMessaging in a multi client environmentTrigger FailuresNullsConstraint ViolationsCommitment ControlAnd other bits and pieces...

Speakers
avatar for Paul Tuohy

Paul Tuohy

ComCon and System i Developer
Paul Tuohy, IBM Champion and author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is a prominent consultant/trainer/educators for application modernization and development technologies on the IBM Midrange. He currently holds positions as... Read More →


Monday June 18, 2018 11:00 - 12:00
Orchidea A

11:00

Is your DATA Secure? Better make sure with RCAC!
Is your data really secure? Object level security would be one thing, if implemented. user exits are providing locks at command levels, but not at the object level Do you really want to prevent access or at least mask personal identifiable information? This session will cover the 7.2 Row and Column Level Access Control and a solution that can help you monitor over 1000 security attributes with simple dashboards and drill downs to pinpoint exposures.

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →


Monday June 18, 2018 11:00 - 12:00
Gerbera A+B

13:00

SQL Views for Dummies
SQL views provide the modern user interface to obtain system level information traditionally available via OUTFILE and API support.
Attend this session and learn how easy it is to use a SQL view. SQL views provide the administrator of the system easy access to lots of system configuration and management information.
This session will provide a list of available SQL views and their purpose as well as examples of how to use them. I will explain how the examples work and you'll leave with the skills necessary to be a better and more system administrator.

This is not an introduction to SQL class, but rather an explanation of why you need to add SQL to your toolset and a quick-start guide showing you how to become a better systems administrator or security officer.
http://ibm.biz/Db2foriServices

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday June 18, 2018 13:00 - 14:00
Irys

13:00

Application Modernization Database
Today, when we talk about application modernization, most think about having to reface their application and going mobile. New technologies will be used to change the layout and programs will be rewritten. "¦ but what will a nice design be worth if the base, i.e. the underlying database is still in your grandfather"s style, grown over the years with lots of redundancies? In this workshop you will learn why to go from DDS to SQL, what are the benefits of SQL over DDS. Techniques for converting and redesigning your existing grown over the time database into a modern normalized database will be shown. For guaranteeing data integrity and security business logic and security rules should be moved into the database.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Monday June 18, 2018 13:00 - 14:00
Orchidea A

14:15

Modernization Strategies for IBM i
Application modernization can mean different things to different people. Ask ten people and you will get ten different answers. One thing they all have in common, though, is the big question: How can I deliver modern applications to our business? IBM i Product Offering manager, Alison Butterill, discusses some of the different modernization options available, taking a holistic look at language, infrastructure, tools, database, and methodology. With many options available, it is possible to start small and build over time, taking advantage of exciting, new, and diverse technologies and opportunities without having to start over!

Speakers
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →


Monday June 18, 2018 14:15 - 15:15
Orchidea B

15:45

RPG Talks To Watson
One of the key questions is - how easy is it to integrate Watson into my existing RPG applications?In this session we look at some of the way that RPG can connect with Watson (using the translation API) - and just how simple it is.As well as looking at different methodologies, we will also discuss the advantages, and disadvantages, of the different approaches.

Speakers
avatar for Paul Tuohy

Paul Tuohy

ComCon and System i Developer
Paul Tuohy, IBM Champion and author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is a prominent consultant/trainer/educators for application modernization and development technologies on the IBM Midrange. He currently holds positions as... Read More →


Monday June 18, 2018 15:45 - 16:45
Orchidea A
 
Tuesday, June 19
 

08:00

Performance Optimization of your SQL Statements
Agenda: SQL becomes more and more the standard for accessing data in physical files or SQL tables. Contrary to native I/O where the programmer specifies a physical or logical file that is to be used, in SQL it is the Query Optimizer who decides whether an index is used or whether the complete table/file is read. Long running queries are a nuisance, but what is the reason why an SQL statement performs badly? Is there a way to affect the query optimizers decisions?Before using any analysis tool, it is important to know what steps must be performed when executing a SQL statement. How work the query optimizer and the statistics manager together? What is the difference between a full and pseudo open? "¦ and much more. Visual Explain is the core of the analysis tools provided in Access Client Solutions (ACS), it provides information about a single SQL statement. Visual Explain is at first the graphical representation of the access plan, but includes a lot of detailed information about the SQL statement, such as about the advised indexes or which is most time consuming step. Learning Objectives:Before using Visual Explain, you"ll learn several details about the Query Optimizer, about the Statistics Manager and how you can affect the query optimizer"s decisions.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Tuesday June 19, 2018 08:00 - 09:00
Orchidea A

09:15

Access Client Solutions (ACS) for Programmers
Access Client Solutions is a powerful tool for programmers. ACS replaces and enhances much of the functionality originally supplied by Navigatorfor i.This session discusses how ACS can be used by programmers; includingSystem Configuration5250 EmulatorSSH TerminalIntegrated File SystemPrinter OutputSchemasRun SQL ScriptsSQL Performance Center

Speakers
avatar for Paul Tuohy

Paul Tuohy

ComCon and System i Developer
Paul Tuohy, IBM Champion and author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is a prominent consultant/trainer/educators for application modernization and development technologies on the IBM Midrange. He currently holds positions as... Read More →


Tuesday June 19, 2018 09:15 - 10:15
Orchidea A

10:30

Exploiting Free Tools - By Example
Are you tired of constantly exporting and importing data for foreign applications running on Windows or Unix/Linux servers? Do you wish there was an easy way to keep more applications on IBM i?Over the years, Jon has introduced many RPGers to some of the many great free tools that can make it easier to develop new applications and to help to make make their IBM i programming lives easier. In this session Jon will present live demonstrations of the tools that people have told him that they find to be the most useful additions to their tool kits. For example:- Help Desk software- Generation of test data- Tools to build web sites and wikis- Tools for building fast modern applications quickly

Speakers
avatar for Jon Paris

Jon Paris

Chief cook and bottle washer, Partner400
Jon's IBM midrange career started when he fell in love with the System/38 while working as a consultant. This love affair ultimately led him to joining IBM.In 1987, Jon was hired by the IBM Toronto Laboratory to work on the S/36 and S/38 COBOL compilers. Subsequently Jon became involved... Read More →


Tuesday June 19, 2018 10:30 - 11:30
Orchidea A

12:30

Advanced IBM i SQL performance where you get no help from the Index Advisor
When you are working with SQL and query tuning, are you sometimes missing more index recommendations from the DB Optimizer? The indexes advises in IBM i version 7.1/7.2/7.3 are good and covers large parts of the queries, but the index recommendations are not perfect, so this presentation gives you insight to SQL performance analysis, where the Index advisor do not help you. The presentation shows practical examples from different customer scenarios.

Speakers
avatar for Morten Buur Rasmussen

Morten Buur Rasmussen

Power performance specialist, IBM Lab Services Europe
Morten Buur Rasmussen is a performance Specialist at IBM Lab Services Europe.Morten has 32 years of experience in the computing field. He started working with the S/38 and AS/400 in 1988 as programmer.Before joining the Lab Services, he worked for IBM Denmark and several European... Read More →


Tuesday June 19, 2018 12:30 - 13:30
Gerbera A+B

13:45

Embedded SQL in RPG - Beyond the Basics
You have been using embedded SQL in RPG. You have mastered the syntax, tried a few selects, declared a cursor, performed an update - you may even have tried some dynamic SQL!Time to take it to the next stage and see what you can do with embedded SQL - beyond the basicsTopics covered in this session include:-Discussion of the key points in writing powerful embedded SQLControlling CRTSQLRPGISQLCA and SQLCODE considerationsGetting data without SELECT - GET DIAGNOSTICS and VALUES INTOTalking to Watson with Embedded SQLMaking use of Scalar FunctionsMastering Multi Row FetchHandling NULLDates, Times and Timestamps

Speakers
avatar for Paul Tuohy

Paul Tuohy

ComCon and System i Developer
Paul Tuohy, IBM Champion and author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is a prominent consultant/trainer/educators for application modernization and development technologies on the IBM Midrange. He currently holds positions as... Read More →


Tuesday June 19, 2018 13:45 - 14:45
Orchidea A

15:15

Using Guardium V10 to track database activity on Db2 for i
Governance of the data center is a heavy burden. The data that resides on Db2 for i has great value, and as such needs to be closely guarded.
This session will be a deep dive into the IBM i and Db2 for i specific capabilities that are included in the IBM Security Guardium product. The Database Activity Monitor (DAM) for Db2 for i will be demonstrated. The architecture and FAQ will be covered. The session will also include information about Vulnerability Assessment (VA) and more.

Relevant resources:
https://ibm.biz/GuardiumDAMonIBMi
https://ibm.biz/GuardiumAndDb2fori-education
https://ibm.biz/GuardiumOniServiceabilityGuide
http://www.ibm.com/developerworks/ibmi/library/i-infosphere_guardium_Db2/index.html
www.ibm.com/developerworks/library/se-guardium-v10/index.html

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Tuesday June 19, 2018 15:15 - 16:15
Gerbera A+B

16:30

Common Observations and Pitfalls in the IBM i
There are typical performance pitfalls that IBM Lab Services consultants find during many performance assessments. Some of the most important areas will be covered during the presentation. The main focus will be around the Power8 observations and experience, but also other areas are covered. Please be aware this is an advanced presentation.

Speakers
avatar for Morten Buur Rasmussen

Morten Buur Rasmussen

Power performance specialist, IBM Lab Services Europe
Morten Buur Rasmussen is a performance Specialist at IBM Lab Services Europe.Morten has 32 years of experience in the computing field. He started working with the S/38 and AS/400 in 1988 as programmer.Before joining the Lab Services, he worked for IBM Denmark and several European... Read More →


Tuesday June 19, 2018 16:30 - 17:30
Gerbera A+B
 
Wednesday, June 20
 

10:45

My Database Tools are better then yours. ACS & DB a perfect match!
With the demise of the iAccess for Windows and it not being supported on Windows 10, we needed to come with new interfaces and tools to help the database engineer (DBE) do their job. This session will introduce the brand new Run SQL Scripts interface, show a number of live Demos as well as other tools centric to the success of the DB Engineer.
The session will also include and explanation and demonstration of all the database tooling that has been added to this java-based tool.

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →
avatar for Tim Rowe

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys... Read More →


Wednesday June 20, 2018 10:45 - 11:45
Frezia