About The Event

WHERE

Hotel Legoland
Billund, Denmark

WHEN

Wednesday to Thursday
October 11 to 12, 2017


The POWER event of the year!

Hotel Legoland
Åstvej 10
7190 Billund

Enroll here:

http://www.common.dk

This event is a part of your membership.
Please write in the comment field during the enrollment if you are not attending both days.

Remember to book a hotel room if you need that. Rooms are selling out fast, so please hurry up.
Roomrates are not a part of your membership and have to be paid by the attendee.
Please use this link:

https://booking.legoland.dk/reserve/en/block/111017COMM?Arrival=2017-10-11


Hurry Up!

Don't miss this! The event will start in

Conference Schedule

This is a conference in 2 session tracks.
Except for the keynotes.
  • Day 1

    October 11, 2017

  • 09:45 - 10:45
    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.
    Inspirational
    Where
    Room 1

  • 11:00 - 12:00
    You keep hearing about these web service “things” but are not really sure what they are, where they fit into your toolset or why they’re important. IBM continues to add native functionality, positioning the Power System as a key player in this technology. In this fast moving session we will discuss the ins and outs of web services and the many ways you can work with them on IBM i. Points of discussion include how web services work, where to find them and a demonstration of the tooling you will find, TODAY, already available in your own shop.
    Application Development

  • 11:00 - 12:00
    Systems Management

  • 12:15 - 13:15
    Et indlæg med et tilbageblik på AS/400 B modeller, Pulsar, Northstar, Power4, Power5, Power6, Power7 alt sammen som oplæg til en status på Power8. Power8 produkt linien Gennemgang af 4 nye performance optimerede Power8 installationer for at vise hvordan common medlemmer bruger Power8 Den første installation er et eksemepl på ekstrem performance optimering af I/O systemet for at forbedre batch performance. Den anden installation er et eksempel på en Power-HA installation med 24x7 drift, målsætning er intet mindre end 100,00 % oppetid. Den tredje installation er et eksempel på en performance optimeret 3-sites HA løsning med en kombination af et HA cluster og logisk replikering Fjerde og sidste eksempel er en installation hvor vi har brugt den hurtigste Power8 man kan købe for penge sammen med et All-Flash disksystem til at forbedre svartider for et ældre ERP system uden at ændre ERP systemet på nogen måde!
    Systems Management

  • 12:15 - 13:15
    Abstract: 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. Learning Objectives: The more normalized a database is, the more tables need to be accessed to get the required data. Instead of reading one table after the other, SQL allows those tables to be joined and merged together by using different join methods for fulfilling the request in a single SQL statement. This session will not only discuss the basics but also demonstrate several tips and tricks for exploiting the join and merge methods. Audience: Developers and query users who already use or want to use SQL. SQL is not only good for ad hoc queries, but can also be used for generating statistical reports, in RPG or Cobol programs as an alternate for native I/O. The only programming languages that support native I/O are RPG and Cobol. All other languages such as PHP or C++ have to use SQL to get access to the data located in database objects. Level: Average Duration: Single Session
    Application Development

  • 14:15 - 15:15
    This session will cover the basics of what open-source is, how it's being used currently and what we can do to make ILE languages more open-source. It will go from moving RPG source to the IFS, integrating Git and how source change management can benefit your business (45-50 mins)
    Application Development

  • 14:15 - 15:15
    The evolution of IT now clearly includes cognitive data analysis, using systems which are contained, at least partially, in clouds. Yet transaction processing remains at the core of most businesses. In this session, we'll look at the direction of IBM i, the integrated solution operating system on Power Systems, in this new era.
    Inspirational

  • 15:45 - 16:45
    This presentation continues the performance educations from last years event, and shows you some selected tips and tricks that can help you getting better performance and help you better understandperformance issues on IBM i.
    Systems Management

  • 15:45 - 16:45
    “New” RPG Free Form enhancements? Well sure, but that happened at 7.1. Time marches on and so do the enhancements. Today’s RPG is living, vibrant and ever-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 the many new treasures that will not only improved the readability of your code but also the reliability. Long live RPG!
    Application Development

  • 17:00 - 18:00
    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.
    Systems Management

  • 17:00 - 18:00
    Abstract: 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. Audience: Developers and users who are experienced in SQL Queries and need to create XML documents and store them in either a SQL table or directly in the IFS or simply want to enhance their SQL know-how. Level: Advanced Duration: Single Session
    Application Development

  • Day 2

    October 12, 2017

  • 08:30 - 09:30
    Modernization is such an interesting word. It seems everyone has a definition, and depending on the vendor, there is only ONE way to modernize. Yet, everyone has a different starting point, different ending destination, and therefore, different roadmap. Trevor brings his 25 years of modernization and transformation experience and 30 years of IBM i related experience to help you decide the best direction for your own unique modernization journey. Also covered will be several real world examples and ideas of what to do and what not to do. A simple and effective strategy approach is also introduced. Learning Objectives: 1. Understand that your modernization roadmap is unique 2. Learn starting points on where to embark on that modernization journey 3. Discover pitfalls to avoid and keys to successful modernization
    Application Development

  • 08:30 - 09:30
    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. Level: Advanced Duration: Single Session
    Application Development

  • 09:45 - 10:45
    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.
    Application Development

  • 09:45 - 10:45
    Come hear an overview of the capabilities of the most recent deliveries on 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.
    General

  • 11:00 - 12:00
    In this session, I talk about how you can use Embedded SQL to send HTTP requests in less than 5 lines of code, as well as learning about useful SQL scalar functions that are available in RPG (45-50 mins)
    Application Development

  • 11:00 - 12:00
    Learn more about Layered Security Fundamentals and GDPR.
    General

  • 12:45 - 13:45
    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.
    General

  • 12:45 - 13:45
    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. Learning Objectives: 1. Learn the various ways to edit open source code on IBM i 2. Learn what a shell is and how to access one 3. Tie these tools together to be a productive open source user and developer!
    Application Development

  • 14:00 - 15:00
    Does work fill your life? Have you ever heard the term 'spare time' and wondered what it meant? Are you stuck in a rut and see little hope of change in the perceivable future?Come to this entertaining and lively session to find simple and practical tools that will assist in refreshing your perspective. Learn how to change the balance of work in your life and put more life in your work. In this session, you will learn: 1. Practical ideas of ways to add depth to your life outside of work. 2. How to enrich your life. 3. How to improve your productivity at work. 4. What steps you can take to refresh your perspective.
    Inspirational

Our speakers

Join us - become a member

Membership in COMMON Denmark is for all individuals, and organizations interested in IBM Power Systems and other platforms. Our goal is to help you enhance your career. We do this by offering education and networking.