Data3 HK 2017: Full Schedule

TACK ALLA SOM KOM TILL HÖSTKONFERENSEN 2017!

Talarna lägger upp sessionerna själva och vi har påminnt dem om att göra det.
Saknar ni någon kontakta gärna talarna direkt själva eller maila styrelsen.

12:00 CEST

CONFERENCE WELCOME DESK OPEN

Sunday October 15, 2017 12:00 - 13:00 CEST
Konferenslobby

General

13:00 CEST

Develop your first Bluemix app

Join us in this hands-on session for learning the fundamentals of building and deploying your application in the cloud with IBM Bluemix. See how to leverage the full capabilities of the Bluemix catalog and utilize the micro services available.

We will explore the possibilities to connect a backend systems of record, such as a database on IBM Power, with the cloud integration in Bluemix. The cloud integration service exposes REST APIs to be used by applications in hybrid architectures.

IBM Bluemix is a cloud platform as a service developed by IBM. It supports several programming languages (Java, Node.js, Go, PHP, Python, Ruby to mention a few) and services as well as integrated DevOps to build, run, deploy and manage applications on the cloud. Bluemix is based on Cloud Foundry open technology and runs on SoftLayer infrastructure. If you're a developer, you now have a hand in creating the future. Bluemix offers you what you need to push your ideas into the present. Bluemix provides data storage and integration services to develop and deploy hybrid IT architectures — with components in both cloud and non-cloud environments. Enabling secure connectivity among apps and data sources on-premises or in the cloud, Bluemix-hosted apps have access to cloud infrastructure that supports enterprise requirements such as scalability, performance, availability, and security.

Prerequisite “In order for the workshop to run as smoothly as possible, register for a free account on Bluemix a couple of days before the actual date for the workshop. Go to https://console.ng.bluemix.net/ and click the button “Create a free account” to register for a 30 days free trial on Bluemix public cloud. During the workshop we expect you to bring your own laptop with an internet connection (there will be guest wifi at the conference) to access the cloud platform at bluemix.net.”

Speakers

Johan Rodin

Technical Sales Specialist - IBM Cloud, IBM

Johan Rodin is Technical Sales specialist within IBM Cloud in Sweden and the Nordics. With more than twenty years of experience in the software industry, Johan is combining his deep knowledge in computer system architectures with an understanding of the challenges today's businesses... Read More →

Sunday October 15, 2017 13:00 - 17:00 CEST
Solliden

Sunday Deep Dive

13:00 CEST

Hands-on with open source technologies: Git, Orion, Bluemix and Python!

Come to this session for a hands-on introduction to some of technologies used in the open source world today. Play with the Orion IDE, integrate it with git, and deploy an application to Bluemix. Finish off the session by learning Python programming for IBM i!

Delegates should:

Install Chrome (if Windows)
Acquire a GitHub.com account
IBM Bluemix account at https://console.ng.bluemix.net/

Speakers

Jesse Gorzinski

Business Architect, IBM

Jesse Gorzinski works for the IBM i development lab in Rochester, MN. He is a Senior Business Architect and Senior Technical Staff Member (STSM) responsible for open source technologies on the platform. Jesse, who was doing RPG programming at the age of 18, is an expert on application... Read More →

GitOrion pdf

Bluemix discussion pdf

Handout pdf

Sunday October 15, 2017 13:00 - 17:00 CEST
Prins Eugenes Salong

Sunday Deep Dive

13:00 CEST

IBM PowerVM VIOS Planning and Best Practices, Install and Configuration, Configure your virtual networking, Managing and Monitoring

A successful VIOS implementation starts with proper planning and a few practices that have proven to be successful for many organizations. This session will help you plan for a successful implementation of VIOS, avoid common pitfalls, and simplify the tasks associated with configuring VIOS.

Learning Objectives:
Learn about VIOS configuration options and determine how to select the Power System configurations that meet your requirements. Learn about Virtual SCSI and NPIV storage connection options and identify the best option for your environment. Learn best practices for optimizing storage performance on IBM i LPARs hosted by VIOS. Understand the key design considerations for creating a highly available virtualized network.
Installing VIOS can be done successfully in a few simple steps. In this session, you will receive a step by step guide for installing VIOS and making it available to host your IBM i, AIX, and Linux partitions on Power Systems. This session will also cover easy way to configure disk and tape solutions on VIOS and client partitions like IBM i. Using the HMC browser, you can perform most of the configuration steps without touching the AIX-like command line interface. If you don’t have AIX skills and want to setup VIOS without getting hurt, this session is for you!

Learning Objectives:
Learn how to use the HMC’s browser interface to install VIOS. Learn how to protect the load source disk and configure VIOS on your network. Learn how to use the Virtual Storage Management function on the HMC to configure Virtual SCSI and NPIV storage on VIOS and client partitions. Understand basic Storage Area Network (SAN) concepts needed when virtualization SAN storage Learn how easy it is to add storage to existing applications or provide storage to new applications using VIOS and IBM storage technologies. Learn how to define a client LPAR like IBM i so it can be hosted by VIOS.

This session covers the easy way to configure networking solutions on VIOS and client partitions like IBM i. Using the HMC browser, you can perform most of the configuration steps without touching the AIX-like command line interface. If you don’t have AIX skills and want to setup VIOS without getting hurt, this session is for you!

Learning Objectives:
Learn how to use the Virtual Network Management function on the HMC to configure virtual ethernet networks on VIOS and client partitions. Understand options for sharing networking resources and configuring highly available network solutions. Learn how easy it is to provide network connections to new applications without adding hardware.

As you transition in to the virtual world for systems and storage, you will be utilizing different interfaces into different components. Depending on your job or organizational structure you may not be supporting everything in your IT systems, but it helps to have an idea of what might be available for the different components. This session will introduce tools and techniques to gather information from various devices within your environment.

Learning Objectives:
Understand the tools used to monitor VIOS Be able to generate diagnostic information for VIOS

Speakers

Gary Konicek

IT Specialist, IBM Corporation

Gary Konicek is an IT Specialist with IBM Lab Services and Training. Based in Rochester, Minnesota, he has guided customers in their IT decisions throughout the evolution of the IBM Power Systems hardware and Power Systems software. Gary has held various I/T positions in software... Read More →

VIOS deep dive zip

Sunday October 15, 2017 13:00 - 17:00 CEST
Waldemarsudde

Sunday Deep Dive

13:00 CEST

iDoctor for IBM i Deep Dive

iDoctor gives you a good graphical understanding about your performance data, mainly when you are looking at Collection Services data and Job Watcher data.
Wait accounting will be reviewed, so you understand how IBM i can make it possible to collect performance data used for deep diving into partition and your applications.
You will also see examples of iDoctor and Job Watcher where you can get deeper information about jobs/threads that can help you solve performance problems.

Speakers

Morten Buur Rasmussen

Power Performance Specialist, IBM

Morten Buur Rasmussen is a performance Specialist at IBM Technology Services. Morten has 38 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 →

2017 10 15 Common Sweden iDoctor Deep Dive pdf

Sunday October 15, 2017 13:00 - 17:00 CEST
Stadshuset

Sunday Deep Dive

13:00 CEST

Let's Learn Linux! The Lab

Linux, AIX, UNIX – we hear about them everywhere these days. But what does it all mean? Linux skills are important to everyone working in the technology field. The days of running everything on just one platform are behind us, so it’s important to be familiar with Linux. But you probably don’t have a spare Linux server sitting around, just waiting for you tinker with, right? Well, you don’t need one! Can you replace Windows with Linux? Even if you can, should you? What are the advantages and disadvantages? How do you get, install, and use Linux? Is it really all free? What can you do with a Linux command line, and is it really as powerful as you’ve heard? Attend this session to learn the answers to these questions and much more. See step by step instructions for safely installing Linux on your PC while still running Windows or Mac OS! We’ll cover a number of powerful commands that can be executed from a Linux environment on your PC, within Windows 10, your X86 servers, or even on your IBM i!

Learning Objectives:
After participating in this session, attendees should have the skills to: - Identify the best way to get started with a Linux environment - Install and set up Linux on their personal PC in a safe way - Use a Linux desktop for productivity and learning - Apply skills learned to a production server environment - Take full advantage of the power of the Linux command line in multiple environments, even on your IBM i!

Speakers

Steve Wolk

CTO, PC Richard & Son

Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

Let's Learn Linux! The Lab Steven Wolk pdf

Sunday October 15, 2017 13:00 - 17:00 CEST
Saltsjöqvarn

Sunday Deep Dive

13:00 CEST

RDi hands on Debugging

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →

RDi debugging workshop pdf

Sunday October 15, 2017 13:00 - 17:00 CEST
Seglora

Sunday Deep Dive

13:00 CEST

SQL Programming Language

Abstract: SQL is much more than a query language. Besides querying and manipulating data in
database objects and generating those database objects, SQL also provides all kinds of
commands and constructs, for writing and executing programs. With the SQL Programming
Language, Stored Procedures, Triggers and User Defined (Table) Functions can be written,
without knowing anything else than SQL commands!
Learning Objectives:
This workshop will give you an introduction into the SQL Programming Language. The
procedure and function create options and controls are explained. You’ll learn how to
structure the source code within the routine body, how to define variables and cursors, what
control statements are available, how to read data row by row in a loop, how to receive and
return parameter values and result sets and how to handle errors. Besides the pure coding
you’ll get also a short introduction into the development tools.
Audience: Managers, programmers, database administrators and even (SQL) Query users who want to
enhance their SQL knowledge.
Level: Average

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Data3 Höstkonferensen 2017 Birgitta Hauser Workshop SQL Programming pdf

Data3 Höstkonferensen 2017 Birgitta Hauser Workshop SQL Programming sql

Sunday October 15, 2017 13:00 - 17:00 CEST
Skansen

Sunday Deep Dive

17:00 CEST

Ask the Experts

Moderators

Torbjorn Appehl

Vice President, Common Europe

IBM Champion for Power since 2016, love the IBM i platform since my very first contact with it in 1997. Today I am the CEO for Load System in Sweden. An IBM business partner with focus on IBM Power, IBM Storage, IBM Z and LinuxONE. Also Vice President for Common Europe.

Trevor Perry

Storyteller | Instigator | Agitator, The Extraordinary Company L.L.C.

Trevor Perry is a technologist by trade and a motivational speaker by passion. His keynote speeches and breakout sessions are in demand across the globe at technology conferences and events. He is an Australian of Irish heritage who lives in America, and spent time faking an English... Read More →

Speakers

Alison Butterill

WW Product Manager for IBM i, 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 →

Jesse Gorzinski

Business Architect, IBM

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Gary Konicek

IT Specialist, IBM Corporation

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 →

Morten Buur Rasmussen

Power Performance Specialist, IBM

Sunday October 15, 2017 17:00 - 18:00 CEST
Seglora

General

18:30 CEST

Dinner Sunday Evening (Included in conference fee)

Sunday October 15, 2017 18:30 - 20:30 CEST
Restaurangen

General

08:00 CEST

CONFERENCE WELCOME DESK OPEN

Monday October 16, 2017 08:00 - 09:00 CEST
Konferenslobby

General

09:00 CEST

Opening Session - Welcome and Key Note Speakers

Monday October 16, 2017 09:00 - 10:45 CEST
Seglora

General

10:45 CEST

Break with Coffee/Tea and sandwich

Monday October 16, 2017 10:45 - 11:15 CEST
Konferenslobby

General

11:15 CEST

Create or Replace … DDS Files with DDL Objects

With the latest releases and technology refreshes the SQL data definition language (DDL) for creating and maintaining database objects was enormously enhanced. DDS on the other hand is stabilized. But still a lot of applications even those with a modern graphical interface and where the latest goodies of the programming language are used in the source code are based on DDS described files. The excuse DDL enhancements cannot be used, because of the DDS description and the native I/O access of these files, does not count any more. With Reverse Engineering, the SQL code for DDS described objects can be retrieved. CREATE OR REPLACE statements allow DDS described files to be converted into SQL defined database objects, while the programs that use these files can stay untouched. With the CREATE OR REPLACE TABLE statement, files with fields based on field reference tables can be managed.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Data3 Höstkonferensen 2017 Birgitta Hauser Create Or Replace Table pdf

Data3 Höstkonferensen 2017 Birgitta Hauser Create or Replace Table sql

Monday October 16, 2017 11:15 - 12:00 CEST
Skansen

Application Development

11:15 CEST

From STRPDM to RDi

So you keep hearing about this great tool RDi (Rational Developer i) but are somewhat intimidated by the prospect of learning it? This session is a primer on RDi basics, including new terminology, connecting to the IBM i, filters, and getting productive with its features, with a large focus on source code editing. The rich graphical environment far exceeds what PDM and SEU can do, and you will be glad you spent the time learning how to harness its power. The more you use this tool, the more you will want to use it. This session includes a live demonstration of the tool.

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

From STRPDM to RDi pdf

Monday October 16, 2017 11:15 - 12:00 CEST
Seglora

Application Development

11:15 CEST

Title

Description

Monday October 16, 2017 11:15 - 12:00 CEST
Saltsjöqvarn

Application Development

11:15 CEST

Executive - Round table discussion with Jonas Ullberg

Jonas shares information on what is going on around IBM Power in Europe

Speakers

Jonas Ullberg

Vice President IBM Power - Global Channel Sales, IBM

Monday October 16, 2017 11:15 - 12:00 CEST
Stadshuset

Executive

11:15 CEST

Hidden Gems of IBM i

The IBM i team has been delivering new function two times per year since 2010. New releases and technology refreshes deliver a broad range of function and sometimes the smallest line items can be easily missed. Scott, Dawn and Alison have reviewed the past releases/refreshes and have assembled some of their favourite hidden gems; things that you might have missed but should know.

Speakers

Alison Butterill

WW Product Manager for IBM i, IBM

Hidden Gems pdf

Monday October 16, 2017 11:15 - 12:00 CEST
Prins Eugenes Salong

Infrastructure

11:15 CEST

IBM Power (9) Update

Framtid för PowerSystems, Ekosystemet runt PowerSystems samt diverse skvaller och anekdoter gällande nästa lansering

Speakers

Jesper Bergh

Technical Specialist, IBM

Monday October 16, 2017 11:15 - 12:00 CEST
Waldemarsudde

IT Architecture Methodology Test

11:15 CEST

Overview of Open Source on IBM i

Are you interested in running Open Source on IBM i? This could mean compiling your own utilities, trying a new open-source language, or using some of the other tools that were shipped in the 5733OPS offering. If so, come to this session and hear the latest updates on the IBM deliveries. Also, learn about the IBM i open source community and how you can participate in this exciting frontier!

Learning Objectives:

1. Learn about the latest 5733OPS offerings
2. Learn about the IBM i open source community
3. Discover ways to actively participate in open source!

Speakers

Jesse Gorzinski

Business Architect, IBM

OSS final pdf

Monday October 16, 2017 11:15 - 12:00 CEST
Mannagrynskvarnen

Open Source Linux

11:15 CEST

Practical customer examples where iDoctor helps solving the performance problems

This presentation gives you some practical examples where you see how you can use iDoctor and Collection Service Investigator to show performance data so you will be able to understand and solve performance problems. You will also see examples of iDoctor and Job Watcher where you can get deeper information about jobs/threads that can help you solve performance problems.

Speakers

Morten Buur Rasmussen

Power Performance Specialist, IBM

2017 10 16 Common Sweden iDoctor Pratical examples pdf

Monday October 16, 2017 11:15 - 12:00 CEST
Soliden

Systems Management

12:15 CEST

Intro to IBM i

Whether you are new or experienced with IBM i, this session will cover the basics of the platform. A short history review, a long futures review, combined with an intense definition of IBM i and its components will ensure you leave this session knowing exactly how IBM i fits into the world of technology and business. Many questions about IBM i will be answered, these being just a few: Should you work on IBM i? Should you become a developer on IBM i? Should your company invest in IBM i? Where do you get IBM i resources? How do you learn IBM i? What does IBM think about IBM i - from an outsiders perspective?

Speakers

Trevor Perry

Storyteller | Instigator | Agitator, The Extraordinary Company L.L.C.

Monday October 16, 2017 12:15 - 13:00 CEST
Saltsjöqvarn

Application Development

12:15 CEST

RPG Full Free Form

Varför fritt format? Vad är fritt format? Hur tar man sig dit?
Att överleva i RPG-världen!

Speakers

Karl Persaker

Innehavare, Åke Olsson IT Konsult

Systemutveckling, standards, verktyg, modernisering, SQL, RPG i fritt format, RDI, S/36 environment (sic!)

RPG fullt fritt format pdf

Monday October 16, 2017 12:15 - 13:00 CEST
Seglora

Application Development

12:15 CEST

SQL Easy as MAGIC!

Do you use SQL? Do you use it to its full capabilities? SQL is an amazingly powerful tool, but can seem overwhelming at first. In fact, it can sometimes seem like magic! Come join us for a session on SQL that begins with the basics and builds into very useful techniques you can use every day. Using magic to help explain some key concepts will make this session entertaining as well as educational. Discover how to use SQL not only for data definition and data manipulation, but also as a wonderful ad-hoc query tool. Save time writing reports and get the answers your business needs in seconds. Learn how to easily execute an SQL statement on your PC that will pull data from your IBM i into an Excel spreadsheet! We will cover other practical examples, such as easily processing a job log for the information you need.

Learning Objectives:
After participating in this session, attendees should have the skills and tools to: - Use SQL to perform both simple and sophisticated ad-hoc queries - Create and modify database files using SQL - Modify your data quickly and easily without writing any RPG code - Set up your own PC to pull data from your IBM i to Excel using SQL

Speakers

Steve Wolk

CTO, PC Richard & Son

SQL Easy as Magic Steven Wolk pdf

Monday October 16, 2017 12:15 - 13:00 CEST
Skansen

Application Development

12:15 CEST

Executive - Round table discussion with Alison Butterill

Speakers

Alison Butterill

WW Product Manager for IBM i, IBM

Monday October 16, 2017 12:15 - 13:00 CEST
Stadshuset

Executive

12:15 CEST

Vässa din IBM Power-miljö med Flash-lagring

Många IBM i, AIX och PowerLinux-miljöer använder bara en liten del av tillgänglig processor- och primärminneskapacitet – dagen Power-servrar är helt enkelt så kraftfulla, att traditionella system inte kan utnyttja kraften som finns tillgänglig.Samtidigt upplevs långa svarstider i framförallt batch-orienterade applikationer och avancerade sökningar, och detta beror ofta på att väntetider vid läsning och skrivning på disk (I/O) utgör största delen av svarstiden.Med modern Flash-lagring (ibland benämnt SSD) kan system- och applikationsprestanda förbättras dramatiskt, genom att framför allt sökningar och läsning av data går flera hundra gånger snabbare än med traditionell, roterande hårddisk. Flash-lagring har de senaste åren sjunkit kraftigt i pris, och kan till en mycket rimlig kostnad ge avsevärda prestandaförbättringar både i realtidsmiljöer och i batch-körningar.Här diskuterar vi de olika alternativ som finns, presenterar ett par ”business case” och berättar om praktiska erfarenheter med IBM:s flash-lagringssystem i Power-miljöer.

Speakers

Gunnar Elmgren

Technician, Pulsen

Data3 flash pptx

Monday October 16, 2017 12:15 - 13:00 CEST
Prins Eugenes Salong

Infrastructure

12:15 CEST

Is Open Source Strategic for i?

You may have noticed that IBM has been embracing open source technologies lately. Why has it been such a strong force in the IBM roadmap? Because open source technologies can bring a lot of business value to the enterprise! In this session, discover why open source can be strategic and address some of the primary concerns in the marketplace.

Speakers

Jesse Gorzinski

Business Architect, IBM

Is OSS Strategic pdf

Monday October 16, 2017 12:15 - 13:00 CEST
Waldemarsudde

IT Architecture Methodology Test

12:15 CEST

Single sign-on implementation and deployment best practices

The IBM i single sign-on (SSO) support has been around for many years. More and more companies leverage the SSO support to provide more convenience to users, but also to lower administration cost and improve security. This session starts with a brief overview of the current SSO support. It will then show based on a few typical environments how to plan and perform the SSO deployment to a mass of workstations and how to automate typical administration tasks.

Speakers

Thomas Barlen

Senior Managing Consultant, IBM

IT consultant architecting and implementing security solutions mainly in the IBM i and AIX area. I am also a frequent speaker at technical conferences. Specialties: Cryptography, Single Signon, Security assessments, Access Control concepts and implementation, IBM i networking, IBM... Read More →

SSOImplBestPracticesTBarlen pdf

Monday October 16, 2017 12:15 - 13:00 CEST
Mannagrynskvarnen

Systems Management

13:00 CEST

Walking lunch in Exhibition Area

Monday October 16, 2017 13:00 - 14:00 CEST
Konferenslobby

General

14:00 CEST

Application Modernization Jumpstart

Modernize, modernize, it’s a word you hear more and more about. With the colossal shifting demands on today’s application developers, how do you keep up? And what exactly is a modern application developer anyway? For starters, it’s someone who can speak to today’s technologies. And not necessarily with expertise in every area, but certainly at least know what exists. Join us for a rapid fire discussion on the many tools and technologies that every developer should know about. It’s all about 21st century career survival.

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

Application Developer Jumpstart pdf

Monday October 16, 2017 14:00 - 14:45 CEST
Seglora

Application Development

14:00 CEST

noSQL - mongoDB and JSON support in Db2

What is noSQL and why is JSON so important for modern applications? Why is IBM is investing loads of money and time to bring JSON native into Db2? JSON is taking over the the job of XML and and is now the most used data interchange format on the internet - Why? it is easy to comprehend for web developers and easy to produce by backend developers - and now the tooling is getting better. Can you do it on IBMi ? Sure you can!

Speakers

Niels Liisberg

Chief architecht, System & Method A/s

Open source, Microservices, RPG with IceBreak, noxDB and vsCode, Java, node.js and DB2 on storides

JSON in DB2 txt

2017 10 Data3 noSQL pptx

Monday October 16, 2017 14:00 - 14:45 CEST
Saltsjöqvarn

Application Development

14:00 CEST

What’s new in Db2 for i 7.3

This session will include an exploration of the latest DB2 for i capabilities. DB2 for i includes data-centric, analytic, security and performance improvements that can be used without disrupting application infrastructures. As an integrated database, many of these technologies can be deployed with minimal investment. Learn about some of the new features in DB2 for i 7.3 and how you can take advantage of them!

Speakers

Doug Mack

Consultant LAB Services, IBM

What's New for DB2 for i pdf

Monday October 16, 2017 14:00 - 14:45 CEST
Skansen

Application Development

14:00 CEST

Title

Monday October 16, 2017 14:00 - 14:45 CEST
Stadshuset

Executive

14:00 CEST

Introduction to PowerVC

PowerVC is IBM's virtualization and rapid provisioning solution for Power Systems and is the primary tool used to build and manage a private cloud. PowerVC is built on the open stack tool set. PowerVC can be a powerful tool to quickly create temporary test environments or to deploy and manage permanent servers. This session will cover the architecture, capabilities and best practices based on our experience from client implementations.

Speakers

Gary Konicek

IT Specialist, IBM Corporation

Introduction to PowerVC v1 pdf

Monday October 16, 2017 14:00 - 14:45 CEST
Prins Eugenes Salong

Infrastructure

14:00 CEST

I huvudet på en IT Arkitekt

Det finns många olika roller inom IT. IT Arkitekt är en och vad gör en sån?
Jag kommer att berätta vad jag gör och har gjort för att se till att lösningar på IBM i och Power blir kostnadseffektiva, framtidssäkra och täcker verksamhetens behov. Allt detta i en värld full av modesvängningar och buzz words.

Speakers

Mats Lidström

CPO, IBM i Cheif Architect, Apper

I have been working with IBM i (and it predecessors) since 1987 as a Programmer, Designer, Head of development, CIO and Architect. I have been part of a number of national and international projects throughout the years. Since 2018 I work for Apper and are helping customers to take... Read More →

HK2017 I Huvudet på en IT Arkitet pdf

Monday October 16, 2017 14:00 - 14:45 CEST
Waldemarsudde

IT Architecture Methodology Test

14:00 CEST

Bluemix - The Digital Innovation Platform

The Bluemix cloud platform is not just about creating new apps or migrating existing ones, on-prem or off-prem implementations, or offering IaaS and PaaS cloud services. It's designed to bring all of these aspects together to help you solve your real, complex business problems in the cloud.
In this session you will get an overview of the cloud platform and the benefits it offers. IBM Bluemix supports several programming languages (Java, Node.js, Go, PHP, Python, Ruby to mention a few) and services as well as integrated DevOps to build, run, deploy and manage applications on the cloud. Bluemix is based on Cloud Foundry open technology and runs on SoftLayer infrastructure. If you're a developer, you now have a hand in creating the future. Bluemix offers you what you need to push your ideas into the present. Bluemix provides data storage and integration services to develop and deploy hybrid IT architectures — with components in both cloud and non-cloud environments. Enabling secure connectivity among apps and data sources on-premises or in the cloud, Bluemix-hosted apps have access to cloud infrastructure that supports enterprise requirements such as scalability, performance, availability, and security.

Speakers

Johan Rodin

Technical Sales Specialist - IBM Cloud, IBM

BluemixData3 2017 pdf

Monday October 16, 2017 14:00 - 14:45 CEST
Mannagrynskvarnen

Open Source Linux

14:00 CEST

Everything you need to know about IBM i Access Client Solutions

IBM i Access Client Solutions is the newest member of the IBM i Access Product Family, and it is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. Familiarity with IBM i Access Client Solutions is very important as this is the future of the IBM i Access Family software on workstation operating systems. Come to this session to learn everything you need in order to understand and embrace this new solution!

Speakers

Jesse Gorzinski

Business Architect, IBM

ACS Everything you need to know pdf

Monday October 16, 2017 14:00 - 14:45 CEST
Soliden

Systems Management

15:00 CEST

Logical files, indexes and viewes - Don't get confused

Abstract: Long time ago, database objects were defined only with DDS (Data Description
Specifications). Data access occurred with native I/O through DDS described (keyed)
physical and logical files. But native I/O is only used in conjunction with RPG and COBOL.
DDS is only known on the IBM i and furthermore stabilized since a few releases. The rest of
the world uses SQL which also has become the strategical product for IBM for accessing and
database data and creating database objects. While DDS provides only a single type of
logical files, with SQL we are faced with two different types, respectively indexes and views.
As far as good! But … Do we really need to move completely to SQL? What is the difference
between these types of logical files? Which type of logical file has to be used in what
situation? … And finally what about native I/O?
Learning Objectives:
In this session the differences between the logical file types are explained. You’ll learn how
to move business logic into the database by generating SQL views. It will be explained why
SQL needs first and foremost access paths, either in SQL indexes or keyed logical files.
You’ll discover that even though an SQL index cannot be specified in an SQL statement, an
SQL index can be used in conjunction with native I/O like any DDS described keyed logical
file.
Audience: IBM i developers, database administrators and everybody who has to access data located in
tables or physical files. This session is also important for companies and the appropriate
responsible persons who plan to modernize their applications and database.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Data3 Höstkonferensen 2017 Birgitta Hauser Logical Files Views Indexes pdf

Data3 Höstkonferensen 2017 Birgitta Hauser Logical Files Views Indexes sql

Monday October 16, 2017 15:00 - 15:45 CEST
Skansen

Application Development

15:00 CEST

The ABCs of RDi Shortcuts

There’s the long way and then there’s the short way of doing stuff. RDi, with its full collection of
shortcuts easily speeds up your source code development. This session is a live demonstration
of the what, wheres, whys and hows of the most popular shortcuts. Just using a few of them can
really make a difference. Use them all? No contest. We will even discuss how to create your
own to really ramp up your development.

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

RDi Shortcuts pdf

Monday October 16, 2017 15:00 - 15:45 CEST
Seglora

Application Development

15:00 CEST

What will you do with your IBM i in 2017?

Over the last year, Trevor, in his role as FrescheThinker has been gathering answers to the question “What are your top initiatives for your IBM i applications this year?”. Detail of the responses will be reviewed in this session, along with roadmap suggestions from the FrescheThinking team, using their years of strategy, development, modernization, and transformation experience.
Bring your own answer to what you will do with your IBM i - along with your questions, and Trevor will lead this interactive session in uncovering some direction and strategy for your business and I.T. challenges.

Speakers

Trevor Perry

Storyteller | Instigator | Agitator, The Extraordinary Company L.L.C.

Monday October 16, 2017 15:00 - 15:45 CEST
Saltsjöqvarn

Application Development

15:00 CEST

Executive - Round table discussion with Doug Mack (Bussiness Analytics)

WebQuery replaced Query/400 a long time ago. Doug Mack gives you inspiration what you can do with this tool

Speakers

Doug Mack

Consultant LAB Services, IBM

Monday October 16, 2017 15:00 - 15:45 CEST
Stadshuset

Executive

15:00 CEST

Implementing IBM i in a Private Cloud Using PowerVC

A private cloud provides many benefits including rapid deployment of servers while maintaining control over access and data. PowerVC can be a powerful tool to quickly create temporary test environments or deploy and manage permanent servers. We will walk through the steps used to build, capture, and deploy a IBM i server image. Cloud-init is the post deployment process that is used to customize a newly deployed instance. After the build and capture of the basic image we will cover the steps required to customize cloud-init so that it will call IBM i CL Programs after the successful deploy of an image. The session will end with a demo of the capture and deploy of an existing IBM i server.

Speakers

Gary Konicek

IT Specialist, IBM Corporation

Implementing IBM i in a Private Cloud using PowerVC v1 pdf

Monday October 16, 2017 15:00 - 15:45 CEST
Prins Eugenes Salong

Infrastructure

15:00 CEST

Modern utveckling av kravprocessen

Vikten av att ha koll på sin kravprocess
Hur mäter och utvärderar man sin kravprocess – hur skapar man en lärande organisation kring kravprocessen
Hur får man in nya influenser från vetenskap till verklighet
Hur man sätter krav för ett långsiktigt perspektiv (affärsutveckling)
Hur man ger en samlad bild över kvaliteten på företagets kravprocess
Resultatet av samverkan mellan praktiker och forskning - QTEMA och Blekinge Tekniska Högskola
Direkta tips och in-put förbättringar som organisationen kan göra i sin kravprocess för snabba förbättringar

Speakers

Anita Roll

VD, QTEMA

Anita Roll är föredragshållare och grundare av krav/testbolaget QTEMA som hon har drivit i snart 30 år. Hon har en unik erfarenhet av hur krav och kvalitetssäkring utvecklats över 3 decennier. Att kvalitetssäkra verksamheter och processer är därför områden som hon specialiserat... Read More →

Presentation Data 3 pdf

Monday October 16, 2017 15:00 - 15:45 CEST
Waldemarsudde

IT Architecture Methodology Test

15:00 CEST

Session

Monday October 16, 2017 15:00 - 15:45 CEST
Mannagrynskvarnen

Open Source Linux

15:00 CEST

IFS - Beyond 'wrklnk '/*' - Typ.. Tips och trick runt IFSen

Speakers

Andrew Smith

IBM i Infrastructure Specialist, Scania (GB) Limited

I am responsible for the IBM Power Platform in use at Scania Södertälje consisting of both IBM i and AIX LPARs running to keep us up and running for both After Market and R&D systems.Pretty much anything IBM related is fine to have a "chinwag"Outside of work I am a keen and avid... Read More →

Data3HK2017 IFS pdf

Monday October 16, 2017 15:00 - 15:45 CEST
Soliden

Systems Management

15:45 CEST

Break with Coffee/Tea and cake

Monday October 16, 2017 15:45 - 16:15 CEST
Konferenslobby

General

16:15 CEST

ALM and DevOps, why is it crucial to your business

Based on Cyril experience gathered over the years, he will be providing a summary of why most companies must adopt ALM and DevOps and will be sharing Best Practices gathered from the field

Speakers

Cyril Chaar

Senior Account Executive, Rocket Software

Cyril first started to work with Aldon in 2001 as a Sales Executive in Europe. When Rocket Software acquired Aldon in 2011, he later moved to a role where he would mentor the European teams sharing his project experience with over 200 customers using Rocket Aldon ALM in Europe. Today... Read More →

Monday October 16, 2017 16:15 - 16:35 CEST
Waldemarsudde

Exhibitor

16:15 CEST

Exhibitor

Monday October 16, 2017 16:15 - 16:35 CEST
Prins Eugenes Salong

Exhibitor

16:15 CEST

Exhibitor

Monday October 16, 2017 16:15 - 16:35 CEST
Mannagrynskvarnen

Exhibitor

16:15 CEST

Field Encryption – Easy and simple way to secure your IBM sensitive data

With beginning of V7R1 IBM i added Security on database level to protect of accessing or changing specified data.

Learn how easy you can use this new functions without being an expert in programming and changing your legacy application.

Speakers

Stephan Leisse

Solutions Architect, precisely GmbH

Stephan Leisse has nearly 30 years experience in the AS/400 - iSeries - IBM i world as a Freelance Contractor and Employed Consultant. Currently he works as a Solutions Architect for syncsort (formerly Vision Solutions) in Duesseldorf, responsible for Presales of all HA/DR and Security... Read More →

Field Encryption – Easy and simple way to secure your IBM sensitive data DATA3 2017 pdf

Monday October 16, 2017 16:15 - 16:35 CEST
Mannagrynskvarnen

Exhibitor

16:15 CEST

I år är fokus på GDPR och förberedelse till GDPR

Kom till SOSY’s session och få en kort introduktion och update på SOSY’s lösningsområder.

I år är fokus på GDPR och förberedelse till GDPR. Dette gäller både:

- säkerhet - användare, remote access osv.,

- testdata, som enligt GDPR måste vara anonymiserade,

- automatisering av dokumentation på arbetsprocesserna. Se till att revisorerna blir nöjda!

Till att börja med erbjuder vi ett kostnadsfritt Security Scan, som analyserar eran säkerhet.

Vi har också ett ”GDPR Readiness Assessment”. HelpSystems kommer och berättar om detta.

Dessutom så är datareplikering i realtid, systemövervakning på alla Power plattformar, IBM i prestanda och software change management andra områder som SOSY kan hjälpa med.

Speakers

Donnie MacColl

Director of EMEA Technical Services, HelpSystems

Donnie MacColl is Director of EMEA Technical Services. He has worked for more than 20 years in the IT industry, initially specializing in the management of IBM i systems in manufacturing and logistics companies, and later in his career developing expertise in network and enterprise... Read More →

Helle Mering

General Manager, SOSY

Need to improve SECURITY on your IBM i? TEST your ERP? MOVE data? MANAGE SOURCE during development? Improve PERFORMANCE? MONITOR your applications? Check up on DATA QUALITY?

Monday October 16, 2017 16:15 - 16:35 CEST
Skansen

Exhibitor

16:15 CEST

Jenkin, GitHub and Arcad works together for continuous integration on IBM i

Speakers

Michel Mouchon

CTO, ARCAD Software

Monday October 16, 2017 16:15 - 16:35 CEST
Prins Eugenes Salong

Exhibitor

16:15 CEST

Power as a service

Speakers

Christer Hermansson

RG19Load

Power-as-s-service iSecurity-as-service IBMi teknikkonsulter

RG19 LOAD Foretagspresentation Data3 pptx

Monday October 16, 2017 16:15 - 16:35 CEST
Stadshuset

Exhibitor

16:45 CEST

Apper Systems

Monday October 16, 2017 16:45 - 17:05 CEST
Prins Eugenes Salong

Exhibitor

16:45 CEST

Exhibitor

Monday October 16, 2017 16:45 - 17:05 CEST
Seglora

Exhibitor

16:45 CEST

Exhibitor

Monday October 16, 2017 16:45 - 17:05 CEST
Skansen

Exhibitor

16:45 CEST

Exhibitor

Monday October 16, 2017 16:45 - 17:05 CEST
Seglora

Exhibitor

16:45 CEST

Exhibitor

Monday October 16, 2017 16:45 - 17:05 CEST
Soliden

Exhibitor

16:45 CEST

Exhibitor

Monday October 16, 2017 16:45 - 17:05 CEST
Prins Eugenes Salong

Exhibitor

16:45 CEST

Fresche Solutions - Green Screen Modernization and X-Analysis.

Fresche Solutions supported by BCD Nordic show how easy it is to Modernize Green Screen Applications and to use X-Analysis for developing, change management and reversing engineering documentation on IBM i.

Speakers

Olav Christensen

CEO at BCD Nordic, BCD Nordic

BCD Nordic was founded in 1991 as an IT-consulting company working with the AS/400, then the iSeries, and now the IBM i.BCD Nordic has been the exclusive agent for Business Computer Designs in the Nordic region of Europe since 1992.Through the years BCD Nordic has also gained a broad... Read More →

Paul Hodgkingson

EMEA Channels at Fresche, Fresche Solutions

Monday October 16, 2017 16:45 - 17:05 CEST
Waldemarsudde

Exhibitor

16:45 CEST

Real-time Database Replication / Anonymization

Real-time Database Replication
Extracting, transforming and loading data into different databases has never been easier.
Through just 1 graphical interface you build, manage and monitor your database replication.
Replicate from and to Microsoft SQL, Oracle, Netezza, DB2, MySQL, Postgres.
Stop with handbuild scripts, intensive (nightly) batch jobs and time-consuming modifications to your solutions and start using one application to manage all your different database replications.
Easy to understand, also for those not working with databases on a daily basis.
Anonymization
Upcoming regulations like the GDPR act, coming effective May 2018, demand companies to take sufficient measures to make sure personal data is safe.
One of the most effective action to take is to ‘Anonymize’ the personal data when it is processed outside the primary production environment.
Using our Anonymizing solution makes it possible to replicate your data and anonymize it while replicating.
One of the strong key features is that our Anonymization solution fully maintains the data type structure (IBAN, Credit Card and social security numbers etc) of the anonymized fields and therefore the data can still be used for testing and analyzing.
Visit the presentation and discover how SmartData and Anonymization helps you to comply with the new GDPR act!

Speakers

Mirco Cayetano Rottschäfer

IT Consultant, QSL Northern Europe B.V.

Mirco started his career as a manager in the retail industry and was for many years active in the company Schuitema (400 stores). As interim manager, he was flown to supermarkets where things right were to be held. In 2010, he chose the entrepreneurship and ran for five years, two... Read More →

Monday October 16, 2017 16:45 - 17:05 CEST
Mannagrynskvarnen

Exhibitor

17:10 CEST

Exhibitor

Monday October 16, 2017 17:10 - 17:30 CEST
Skansen

Exhibitor

17:10 CEST

Exhibitor

Monday October 16, 2017 17:10 - 17:30 CEST
Seglora

Exhibitor

17:10 CEST

Exhibitor

Monday October 16, 2017 17:10 - 17:30 CEST
Mannagrynskvarnen

Exhibitor

17:10 CEST

Exhibitor

Monday October 16, 2017 17:10 - 17:30 CEST
Prins Eugenes Salong

Exhibitor

17:10 CEST

Exhibitor

Monday October 16, 2017 17:10 - 17:30 CEST
Waldemarsudde

Exhibitor

17:10 CEST

Exhibitor

Monday October 16, 2017 17:10 - 17:30 CEST
Soliden

Exhibitor

17:10 CEST

Har era egenutvecklade IBM i system blivit en säkerhetsrisk?

Pulsen och Apper visar hur systemen kan framtidssäkras med en ny helhetslösning.

Monday October 16, 2017 17:10 - 17:35 CEST
Prins Eugenes Salong

Exhibitor

17:30 CEST

Vendor Solution Area

Monday October 16, 2017 17:30 - 19:00 CEST
Konferenslobby

General

19:00 CEST

Dinner

Monday October 16, 2017 19:00 - 23:00 CEST
Gyllene salen

General

08:00 CEST

Command Jeopardy Steven Wolk pdf

Tuesday October 17, 2017 08:00 - 08:45 CEST
Seglora

Application Development

08:00 CEST

Tuesday October 17, 2017 08:00 - 08:45 CEST
Skansen

Application Development

08:00 CEST

Water Cooler Topics - I'll Show You Mine If You Show Me Yours

With our industry changing so fast you never know what’s current and what’s not. This session will discuss a variety of topics, all relevant to our community as IT professionals. But you won’t just sit there passively. Like any water cooler discussion, you’ll be asked to participate with your own opinions on current topics. You can expect the actual topics to be very timely and career-worthy, so the next time you’re at your own water cooler you’ll sound like a pro!

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

Water cooler topics pdf

Tuesday October 17, 2017 08:00 - 08:45 CEST
Saltsjöqvarn

Application Development

08:00 CEST

Tuesday October 17, 2017 08:00 - 08:45 CEST
Prins Eugenes Salong

Infrastructure

08:00 CEST

Tuesday October 17, 2017 08:00 - 08:45 CEST
Waldemarsudde

IT Architecture Methodology Test

08:00 CEST

Tuesday October 17, 2017 08:00 - 08:45 CEST
Mannagrynskvarnen

Linux Open Source

08:00 CEST

Tuesday October 17, 2017 08:00 - 08:45 CEST
Soliden

Systems Management

08:45 CEST

CONFERENCE WELCOME DESK OPEN

Tuesday October 17, 2017 08:45 - 09:00 CEST
Konferenslobby

General

09:00 CEST

Key Note - IBM i and Watson

Did you know that Watson and IBM i can work together ? This session will review what is Watson and its importance in your business. We will then dive into the technology that allows you to connect your IBM i data to Watson. There are a number of different options and we will be discussing each as we tour connecting IBM i and Watson.

Speakers

Alison Butterill

WW Product Manager for IBM i, IBM

Jesse Gorzinski

Business Architect, IBM

Doug Mack

Consultant LAB Services, IBM

Tuesday October 17, 2017 09:00 - 09:45 CEST
Seglora

General

10:00 CEST

Node.js - Javascript as a host language on IBMi

The internet word i leaning towards the us of JavaScript server side. Node.js is THE player and has a huge community around it - brining loads of cool opens source stuff to market. It is easy to kick-start a project in node.js and it is fun. Can you do it on IBMi ? Sure you can!

Speakers

Niels Liisberg

Chief architecht, System & Method A/s

Open source, Microservices, RPG with IceBreak, noxDB and vsCode, Java, node.js and DB2 on storides

2017 10 Data3 NodeJS pptx

nodeJs txt

SampleCode zip

Tuesday October 17, 2017 10:00 - 10:45 CEST
Saltsjöqvarn

Application Development

10:00 CEST

REST Web Services for Everyday RPG and SQL Consumption

A web service extends your applications in a way that no traditional programming can. They
allow you to get real time information for almost any requirement. We’ll discuss what web
services are, how they function and how you can begin using them on your own system. Get
step-by-step instructions on the entire Web service process from receiving an XML document to
successfully parsing its information to a display or database file. See working RPG code of an
XML parsing program and watch how we consume a RESTful web service. Updates include i7.1
SQL enhancements which make consuming web services a snap. This session includes source
code to get started using dynamic Web services today!

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

REST Web Services pdf

Tuesday October 17, 2017 10:00 - 10:45 CEST
Seglora

Application Development

10:00 CEST

SQL Functions

To be added

Speakers

Sven Jansson

DBE, Handelsbanken

Tuesday October 17, 2017 10:00 - 10:45 CEST
Skansen

Application Development

10:00 CEST

Navigating the World of IBM i Software licensing

IBM i is a very robust product. It includes DB2 for i, WebSphere Application Server and more than 45 more components and program products. What makes a CBU an attractive option? What about licensing for Live Partition Mobility? It is important to understand the different terms and conditions as licenses are moved between systems or moved in your enterprise. This session will help navigate the world of IBM i software terms and conditions.

Speakers

Alison Butterill

WW Product Manager for IBM i, IBM

IBM i Licensing Handout pdf

Tuesday October 17, 2017 10:00 - 10:45 CEST
Waldemarsudde

IT Architecture Methodology Test

10:00 CEST

Hur jag fick igång Minecraft på IBM i - Kul och inspirerande vad man kan göra med PASE

Speakers

Andrew Smith

IBM i Infrastructure Specialist, Scania (GB) Limited

Running Minecraft on IBM i pdf

Data3HK2017 Minecraft pdf

Tuesday October 17, 2017 10:00 - 10:45 CEST
Mannagrynskvarnen

Open Source Linux

10:00 CEST

What's new in IBM Support

Jonas will talk about the lates changes in IBM Support that will and can help you with management of your IT environment.

Speakers

Jonas Engvall

Software Services Lead, IBM Sverige

IBM Technology Support Services, all aspects of Service and Support of IBM and non-IBM products :-)

Whats new in IBM support Data3 HK 2017 10 17 pdf

Tuesday October 17, 2017 10:00 - 10:45 CEST
Soliden

Systems Management

10:45 CEST

Break with Coffee/Tea and sandwich

Tuesday October 17, 2017 10:45 - 11:15 CEST
Konferenslobby

General

11:15 CEST

Accelerate Your Excel!

Are you intimidated by spreadsheets? Do you use Excel for the basics, but know you could be so much more productive with it if only you knew how? Do you cringe when other business people within your company ask for data in spreadsheet form? Excel is a wonderful tool, especially when paired with the IBM i! It's incredibly powerful, and can save you lots of time. This session will begin with the basics and then progress through more advanced Excel topics such as functions, pivot tables, and array formulas. Using real life examples, you'll see how these new skills will help you in your career. Finally, we'll review powerful methods of pulling data from your IBM i directly into Excel spreadsheets! You'll even leave with sample code you can leverage within Excel to give you one click access to run an SQL statement from your desktop and have the results returned in a spreadsheet.

Learning Objectives:
Learning Objectives: After participating in this session, attendees should have the skills and techniques to: - Understand the benefits of using Excel - Use spreadsheets to improve your own productivity as well as that of your company - Pull data from your IBM i directly into a spreadsheet in a variety of ways

Speakers

Steve Wolk

CTO, PC Richard & Son

Accelerate your Excel Steven Wolk pdf

Tuesday October 17, 2017 11:15 - 12:00 CEST
Seglora

Application Development

11:15 CEST

Cool Things You Can Do with DB2 Web Query for i

Analyze Query/400 definitions. Plot data points on geographical maps. Build a data warehouse or mart. Connect to Watson. Build visualizations over system utilization information. Assess compliance with security standards. We'll cover some of the new things in DB2 Web Query including the new EZ-Install package to get up and running in minutes.

Speakers

Doug Mack

Consultant LAB Services, IBM

cool things you can do with Db2 Web Query pdf

Tuesday October 17, 2017 11:15 - 12:00 CEST
Skansen

Application Development

11:15 CEST

Let's Join Together - Joining SQL Table and ViewsRepeat

Accessing data with SQL becomes more and more important. For resolving a single request data located in multiple tables must be filtered, accumulated and/or merged together. In this way we need to focus our attention on consolidating data split over multiple tables. SQL provides different methods for joining tables and views together, such as inner, outer, exception, cross and full join. A table or view even can be joined with itself or with the result of a different select statement. The result returned from multiple select statements can be merged and even accumulated in a single SQL statement.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Data3 Höstkonferensen 2017 Birgitta Hauser SQL Joins pdf

Data3 Höstkonferensen 2017 Birgitta Hauser SQL Joins sql

Tuesday October 17, 2017 11:15 - 12:00 CEST
Mannagrynskvarnen

Application Development

11:15 CEST

Security

Att skydda sin information är så mycket mer än brandväggar, lösenord, behörigheter, mm.
Hur kan jag gå tillväga för att skydda min information på bästa sätt? Vilka steg måste jag ta?
Kan mitt IBM i system drabbas av Ransomware? Hur kan jag skydda mig?

Speakers

Lars-Olov Spångberg

Svenska Handelsbanken

Lars Olov Spångberg har arbetat med IBM i plattformen och dess förgångare i mer än 35 år, 27 av dessa år på IBM. Lars Olov är medförfattare till 5 olika redbooks, alla med inriktning på säkerhet. Sedan 2007 är Lars Olov anställd på Handelsbankens IT-säkerhetsavde... Read More →

Sakerhet IBM i pdf

Tuesday October 17, 2017 11:15 - 12:00 CEST
Prins Eugenes Salong

Infrastructure

11:15 CEST

Preparing your Power IBM i for GDPR

EU’s new General Data Protection Regulation - GDPR - will enter into force 25.05.2018.
If you are not compliant, your risk fines of EUR 20 mio or 4% of your global turnover (whichever amount is higher)!!
In this session you will learn about:

· What does the GDPR imply?
· What can you do to prepare your IBM i for GDPR?
· Is you IBM i environment secure enough for the GDPR?

o Do you have control over your users: Their authorities, what are they doing etc.
o Why do you need to worry about the IFS?

· What compliance aspects are needed in your reporting to the auditors?
· Test data: what does it take to ensure they comply with GDPR?

Come to our session and get tips on how to prepare your Power IBM i for GDPR.

Speakers

Donnie MacColl

Director of EMEA Technical Services, HelpSystems

Helle Mering

General Manager, SOSY

Need to improve SECURITY on your IBM i? TEST your ERP? MOVE data? MANAGE SOURCE during development? Improve PERFORMANCE? MONITOR your applications? Check up on DATA QUALITY?

Donnie MacColl GDPR IBM pdf

Tuesday October 17, 2017 11:15 - 12:00 CEST
Waldemarsudde

IT Architecture Methodology Test

11:15 CEST

10 signs that you have a Powerful relation

We all want good relations with our loved ones. This session will help you read the signs of your PowerVM setup - are we good or is there maybe a hiccup that needs our attention? 10 deep dives will give you a better understanding of your VIO servers!

Speakers

Fredrik Laurin

IBM

D3 10 signs that you have a Powerful relation pdf

Tuesday October 17, 2017 11:15 - 12:00 CEST
Saltsjöqvarn

Systems Management

11:15 CEST

A practical approach to IBM i SQL performance

When you are working with SQL and query tuning, you should know the free tools provided like
the Visual Explain, where you can view SQL information from the Plan Cache and from the DB
Monitor trace.
What is a good approach to viewing the data. Where can you possible get some easy wins in
making your performance better.

Speakers

Morten Buur Rasmussen

Power Performance Specialist, IBM

2017 10 17 Common Sweden A practical approach to IBM i SQL performance pdf

Tuesday October 17, 2017 11:15 - 12:00 CEST
Soliden

Systems Management

12:15 CEST

Group By, Having and multi-dimensional Grouping

Abstract: 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-totals with SQL?
Learning 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.
Audience: Programmers, Database Administrators and Engineers who quite often need to run queries
or built reports that include sub-totals and grand totals. Everybody who is interested in what
can be done with an SQL SELECT statement.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Data3 Höstkonferensen 2017 Birgitta Hauser Group By Having Mulit dimensional Grouping1 pdf

Data3 Höstkonferensen 2017 Birgitta hauser Group By Having Multi dimensional Grouping sql

Tuesday October 17, 2017 12:15 - 13:00 CEST
Skansen

Application Development

12:15 CEST

Microservices on IBM i

The new kid on the block for enterprise development and deployment is microservices. Why is microservices changing the game of server side application and why is microservices gaining so much attention from huge companies like Netflix, Facebook and twitter? the answer is time to market, stability and scalability. Can you do it on IBMi ? Sure you can!

Speakers

Niels Liisberg

Chief architecht, System & Method A/s

Open source, Microservices, RPG with IceBreak, noxDB and vsCode, Java, node.js and DB2 on storides

2017 10 Data3 Microservices pptx

Microservices Data 3 txt

products js

msExtjs js

Tuesday October 17, 2017 12:15 - 13:00 CEST
Saltsjöqvarn

Application Development

12:15 CEST

RPG! It’s Alive with New Treasures!

“New” RPG free form enhancements? Well sure, but that’s’ so 7.1. Time marches on and so
do the enhancements. It is living, vibrant and evolving, keeping pace and meeting the
requirements and needs of TODAY’s programming community. If you haven’t been keeping up
you are missing out on new treasures that will not only improve the readability of your code but
also the reliability. Long live RPG!

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

RPG Alive with New Treasures pdf

Tuesday October 17, 2017 12:15 - 13:00 CEST
Seglora

Application Development

12:15 CEST

Brush up your IBM i security knowledge with the latest IBM i security enhancements

Brush up your IBM i security knowledge with the latest IBM i security enhancements
Nowadays data theft is not a question of "if" anymore. It is a question of "when" it will happen. Every company is affected, no matter what size.
This session introduces the most recent IBM i security enhancements in areas such IBM i base security, network security, database security,
auditing, etc. that can help you to properly protect your valuable business data. Many of the presented features and services are not well known if at all.
At the end of the session you will know what features are available to more or less transparently protect critical and sensitive data without impacting
the business applications.

Speakers

Thomas Barlen

Senior Managing Consultant, IBM

IBMiSecurityLatestEnhancements TBarlen pdf

Tuesday October 17, 2017 12:15 - 13:00 CEST
Prins Eugenes Salong

Infrastructure

12:15 CEST

Executive - Women in IT: It's All About Your Brand

Whether you are starting your career or have been working in IT for some time, there are some tricks of the trade to establishing and maintaining a strong brand image. How do you set and establish who you are in the work environment. Alison has more than 30 years working with a variety of women in many roles. She will share some of her thoughts based on her experiences and gathered from talking to other women in IT.

Speakers

Alison Butterill

WW Product Manager for IBM i, IBM

Tuesday October 17, 2017 12:15 - 13:00 CEST
Stadshuset

Inspirational

12:15 CEST

Standards

Varför vi behöver standards. Regler vi påverkas av utan att ens veta om dem! Hur man utmanar regler och standards.
Faran med informella regler, riter och traditioner! Att skapa en hållbar process för systemutveckling.

Speakers

Karl Persaker

Innehavare, Åke Olsson IT Konsult

Systemutveckling, standards, verktyg, modernisering, SQL, RPG i fritt format, RDI, S/36 environment (sic!)

Standards pdf

Tuesday October 17, 2017 12:15 - 13:00 CEST
Waldemarsudde

IT Architecture Methodology Test

12:15 CEST

Tools for getting started with open source

A lot has been happening in the world of open source on IBM i! Are you ready to join this exciting adventure? This session will help you get started. We will go over some fundamental concepts and introduce you to some of the tools that can be used for editing files, debugging, doing version control, etc.

Speakers

Jesse Gorzinski

Business Architect, IBM

Tools For Open Source on IBM i (1) pdf

Tuesday October 17, 2017 12:15 - 13:00 CEST
Soliden

Open Source

12:15 CEST

Taking control of your Power environment

Do you need a degree in rocket science to take control of your Power environment? Or is it a bit simpler than that? Topics like management, capacity, and security will be discussed with real life examples.

Speakers

Fredrik Laurin

IBM

D3 Taking control of your Power environment pdf

Tuesday October 17, 2017 12:15 - 13:00 CEST
Mannagrynskvarnen

Systems Management

13:00 CEST

Walking Lunch in Exhibition Area

Tuesday October 17, 2017 13:00 - 14:00 CEST
Konferenslobby

General

14:00 CEST

Command Jeporardy

The IBM i operating system includes hundreds of commands that we use every day. Everything you type on a command line is a command! But did you know that you can create commands of your very own? Commands that can save you valuable time? Commands that can be used as building blocks to make program development more efficient? Come to this session to learn how - and to have some fun! We'll start with the basics for those who've never created a command, and then proceed through more advanced topics such as validation using DEP & QUAL, error handling, help text in panel groups, and more. We'll look at a number of useful examples of custom commands, and you'll even leave with free source code you can use as is, or leverage as a starting point for your own commands. We'll reinforce the concepts we learn by playing Command Jeopardy... for prizes! Learn some great techniques, have some fun, and maybe leave with a prize!

Speakers

Steve Wolk

CTO, PC Richard & Son

Tuesday October 17, 2017 14:00 - 14:45 CEST
Mannagrynskvarnen

Application Development

14:00 CEST

Generate XML Documents with SQL (SQL and XML – Part 1)

With Release 7.1 XML support is included into SQL and the database DB2 for i. Well-formed XML documents can be stored in columns defined with the new XML data type. Multiple scalar and aggregate functions are introduced for generating elements, attributes with or without name spaces and even complete XML documents solely with SQL. In composition with embedded SQL those XML documents can be created and directly written into the IFS with only a few statements. The focus of this session is to generate XML documents and write them either in SQL tables or directly into the IFS.

Learning Objectives:
Get an introduction into XML basics. Learn how XML elements and attributes can be generated, concatenated or nested and composed into XML documents. Those XML documents are either stored in a column in a SQL table or directly within the IFS. This session 170052.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Data3 Höstkonferensen 2017 Birgitta Hauser Generate XML Documents pdf

Data3 Höstkonferensen 2017 Birgitta Hauser Generate XML Documents sql

Tuesday October 17, 2017 14:00 - 14:45 CEST
Seglora

Application Development

14:00 CEST

Stop Building Extracts! Automate Data Preparation

Speakers

Doug Mack

Consultant LAB Services, IBM

Stop Building Extracts Untangling Data for Analytics and Reporting Systems pdf

Tuesday October 17, 2017 14:00 - 14:45 CEST
Skansen

Application Development

14:00 CEST

Session

Tuesday October 17, 2017 14:00 - 14:45 CEST
Stadshuset

Executive

14:00 CEST

The top security risks auditors complain about and how to tackle them

The top security risks auditors complain about and how to tackle them
There are typical security risks that Lab Services consultants find in almost every security assessment. Several of these findings are also risks that auditors complain about. It is not always obvious what security mechanisms and features can be used to address the identified risks. This session lists the most important issues and common misconceptions and shows how to address them based on feasible best practices.

Speakers

Thomas Barlen

Senior Managing Consultant, IBM

TopSecurityRisksTBarlen pdf

Tuesday October 17, 2017 14:00 - 14:45 CEST
Prins Eugenes Salong

Infrastructure

14:00 CEST

How to close Your backup window

Does Your IBM i system need to be available 7/24?
Do You need to ensure all Your critical data is backed up more frequently, with good quality?
Is it Your worst nightmare to lose everything in the system after the last backup?
No time to perform full system and data backups before/after installing upgrades?
We have good news for You – come and learn how to completely eliminate all downtime for backups,
and how to get even full system backups as often as You need – without any system or application disruption!

Speakers

Gunnar Elmgren

Technician, Pulsen

Data3 backupwindow pptx

Tuesday October 17, 2017 14:00 - 14:45 CEST
Waldemarsudde

Systems Management

14:00 CEST

Manage PTF's and monitor your systems with Administration Runtime Expert

Are you interested in checking on your system's overall health and well-being? How about attributes required for your applications to run smoothly? Disk utilization? PTF currency? Come to this session to learn about how Administration Runtime Expert (ARE) can help you accomplish all of these tasks!

Learning Objectives:
1. Revisit the overall system access/management strategy 2. Learn about ARE and how it works 3. Discuss various uses for ARE including PTF management.

Speakers

Jesse Gorzinski

Business Architect, IBM

PTF Mgmt pdf

Tuesday October 17, 2017 14:00 - 14:45 CEST
Soliden

Systems Management

15:00 CEST

Consume XML Documents and Web Services with SQL (SQL and XML – Part2)

Abstract: The XML support included in SQL and DB2 for i with Release 7.1 does not only allow XML
documents to be generated, but also allow XML documents to be consumed. Annotated XML
Document Decomposition is a SQL stored procedures that shreds XML documents based on
registered XML schemas directly into database tables. With the XMLTABLE table function
XML documents can be parsed, converted into a relational representation and data picked
specifically out. Additional scalar functions allow SQL to directly access XML documents
located within the IFS (Integrated File System) or in source physical file members. Last but
not least new SQL functions for getting access to web services are introduced. In
composition with the XMLTABLE function the XML answers returned by web services can be
consumed. The focus of this session is parsing XML documents located in either SQL tables
or within the IFS or returned by web services.
Learning Objectives:
Learn how well-formed XML documents located in either the IFS or an XML column can be
parsed with the XMLTABLE 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.
Audience: Developers and Users who are experienced in SQL Queries and need to process XML
documents located in either SQL tables or the IFS or look for an easy way to access web
services or simply want to enhance their SQL know-how.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Data3 Höstkonferensen 2017 Birgitta Hauser Consume XML Documents pdf

Data3 Höstkonferensen 2017 Birgitta Hauser Consume XML Documents sql

Tuesday October 17, 2017 15:00 - 15:45 CEST
Skansen

Application Development

15:00 CEST

LIVE: IWS Web Services från A till Ö

En live-genomgång hur man skapar Web Services för ett befintligt RPG-program skrivet i FREE RPG. Allt från att skapa Web Sevice Servern, Web Services:en samt att testa den mha SoapUI.

Speakers

Mats Lidström

CPO, IBM i Cheif Architect, Apper

IWS Introduktion Steg 1 pdf

IWS Introduktion Steg 2 pdf

Tuesday October 17, 2017 15:00 - 15:45 CEST
Saltsjöqvarn

Application Development

15:00 CEST

The Less Frequent RDi FAQs - More Stuff to Know

RDi is a game changer and continues to improve how developers are maintaining and developing their applications everywhere. And with the breadth of functionality there is almost never enough time to answer all of the questions at our sessions. Here we will go through some of the most challenging and obscure questions and provide live demonstration to answer them. Let’s learn together how RDi can further your productivity in ways you never thought possible.

Speakers

Charles Guarino

CEO & IBM Champion, Central Park Data Systems

RDi FAQs pdf

Tuesday October 17, 2017 15:00 - 15:45 CEST
Seglora

Application Development

15:00 CEST

Session

Tuesday October 17, 2017 15:00 - 15:45 CEST
Stadshuset

Executive

15:00 CEST

Doing the right things right

With time and resources as a limiting factor, how do you ensure that you are doing the right things right? Because there is no bigger waste than doing the wrong things, even if you do them right! And if you also must keep the deadline due to legal or marketing demands – how do you ensure this? The key is using powerful tools like Continuous Improvement, Agile, and Visibility!

Speakers

Fredrik Laurin

IBM

D3 Doing the right things right pdf

Tuesday October 17, 2017 15:00 - 15:45 CEST
Waldemarsudde

IT Architecture Methodology Test

15:00 CEST

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

Morten Buur Rasmussen

Power Performance Specialist, IBM

2017 10 17 Common Sweden Missing index advices pdf

Tuesday October 17, 2017 15:00 - 15:45 CEST
Soliden

Systems Management

15:00 CEST

Mission: Possible! Journaling Forensics 101 (with Free Tools)

o Learn to think like a spy! Many shops use journaling for a variety of reasons, but may not be familiar with how to use these journals for forensic purposes. Mining your journals for the who, what, when, where, how - and sometimes even why - can be very useful, not to mention fun! Come join us for a lighthearted and entertaining "Mission: Impossible" themed look at one of the most useful things you can do with your journals. This session will introduce journaling concepts and share tuning tips to optimize your journal environment for forensics. After reviewing the "old fashioned" way to dig into your journals, we will demonstrate how much easier this is with the right tools. The DMPJRN and CVTJRNDTA commands used in this presentation will be made available as a free download to all attendees, including source code!
o Learning Objectives - After participating in this session, attendees should have the skills and tools to:
 Optimize your journal environment to maximize the forensic information available to you
 Understand what your journals are trying to tell you, and how to interrogate them to get the answers you need
 Dump your journals quickly and easily using the free software made available
 Be able to interpret the content of your journals to determine what really happened to your data
 Use the techniques demonstrated in the provided source code to develop your own tools
 Save the world from evil-doers
o Audience:
 Anyone who would like to better understand how to maximize their journaling environment to make use of forensic data would benefit from this session. If you've ever needed to figure out how something happened to your data, if you like playing detective, if you enjoy building tools to make your job easier, then please join us!

Speakers

Steve Wolk

CTO, PC Richard & Son

Journaling Forensics 101 Steven Wolk pdf

Tuesday October 17, 2017 15:00 - 15:45 CEST
Prins Eugenes Salong

Systems Management

15:00 CEST

My Database Tools are Better Than Your Database Tools!

IBM i Access Client Solutions (ACS) is the newest member of the IBM i Access Product Family, and it is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. Familiarity with IBM i Access Client Solutions is very important as this is the future of the IBM i Access Family software on workstation operating systems. This future looks very bright and IBM i Access Client Solutions provides ease of deployment, and operational improvements in nearly every function the client provides. Come to this session to learn about all the great features available in ACS for the database developer and administrator, and how they are in many cases better than what you've been using!

Learning Objectives:

1. Discover the latest features in Run SQL Scripts, SQL Performance Center, and more
2. Revisit the IBM i system access and management strategy

Speakers