COMMON Fall Conference & Expo has ended

Create Your Own Event

COMMON Fall Conference & Expo

8:00am EDT

A1AA WORKSHOP: SQL – Queries – Do you know what you can do with a simple SELECT-Statement? Concept A-D A1AI WORKSHOP: IBM i and Power Systems Management Part One — Keeping It Current and Best Practices Theory

1:00pm EDT

A5AA WORKSHOP: SQL Programming Concept A-D A5AI WORKSHOP: IBM i and Power Systems Systems Management Part Two — Daily System Monitoring, Tuning, Clean-up, and Spooled File Handling Theory

5:15pm EDT

A8AH Young i Professionals (YiPs) Networking Event Studio Lounge

8:00am EDT

11AC COMMON Opening Session Regency A

9:30am EDT

12AA Moving from Power7 to Power9 Concept A-D 12AG Speed Dating with a Date Dimension Table Regency EF 12AI The best of ACS! Theory 12AB Open Source Applied - Real World Use Cases Network 12AD What's The Fuss? - Using Procedures and Service Programs Regency B 12AF What's New and Exciting in RPG Regency D 12AE Introduction to the IBM i Performance Data Investigator Regency C 12AC Speed up Your Web Site Regency A

10:45am EDT

13AD Advanced Embedded SQL Regency B 13AG Stop Building Data Extracts for BI/Analytics! Regency EF 13AI Revving Up SQL Performance with (Database) Indexes Theory 13AF VENDOR: Green Screen UI Modernization for Busy IBM i Developers Regency D 13AB POWER PICK: Future of Open Source on IBM i Network 13AC PHP Syntax Regency A 13AA Building an IBM i partition, from scratch, Live and in Color! Concept A-D

11:30am EDT

COMMON Expo Cosmopolitan Ballroom

12:00pm EDT

Lunch in the COMMON Expo Cosmopolitan Ballroom

1:30pm EDT

15AG KEYNOTE: Hey, What's the Big i-dea? Regency EF

2:45pm EDT

16AB Sponsor: Improve IBM i Developer Productivity by 50% Network 16AI Using DB2 and SQL with Open source languages Theory 16AD How to Ensure the Success of Every Project You Work On Regency B 16AG PANEL: Women in IT – IBM Power Systems - Did you Know? Regency EF 16AA IBM i Meets IoT Concept A-D 16AF The World of Node.js On IBM i Regency D 16AC Clean up your IBM i Disk Regency A 16AE IBM i Services for the System Administrator Regency C

4:00pm EDT

17AD Date and Time Calculation with SQL Regency B 17AG What's New in Db2 Web Query? LOTS! Regency EF 17AI SQL Views for Dummies Theory 17AF IBM i 7.4 and Other New Things Regency D 17AB Getting Started with Node.js Network 17AC Understanding PHP Frameworks Regency A 17AE POWER PICK: Best Practices for Moving from RPG IV to RPG Free Regency C 17AA HMC, IBM I, FSP, & Firmware: Putting All the Pieces Together Concept A-D

5:15pm EDT

18AI How to Write DB2 for IBM i SQL Stored Procedures Theory 18AD How to Become a Speaker at COMMON Regency B 18AB Node.js Deeper Dive Network 18AF Options for Consuming REST APIs from RPG Regency D 18AG POWER PICK: Intro to Unit Testing RPG Using IBMiUnit Regency EF 18AE IBM i Prestart Server Jobs Regency C 18AA POWER Pick: Cloud Virtualization Planning and Best Practices Concept A-D 18AC Web Server Magic on IBM i Regency A

6:00pm EDT

Welcome Reception in the Expo Cosmopolitan Ballroom

8:00am EDT

21AB DevOps from a Dev Perspective Network 21AE Debugging with RDi From the On Ramp to the Cruising Lane Regency C 21AI What's New in Db2 for i Theory 21AF IBM Db2 Mirror for IBM i 7.4 - What is it and why do I care ? Regency D 21AD Networking on IBM i - Best Practices Regency B 21AC Web Language Shootout Regency A 21AA Moving from HMC Classic GUI to the new Enhanced GUI Concept A-D 21AG POWER Pick: IBM i Security Best Practices Regency EF

9:15am EDT

22AD Embedded SQL - An Introduction Regency B 22AE Essentials of Backup/Recovery for Disaster Recovery on IBM i Regency C 22AA What's New in Domino 10 Concept A-D 22AB Getting Started with Machine Learning on IBM i Network 22AF Mobile RPG with PhoneGap Regency D 22AC PHP7 – Benefits of Upgrading Regency A 22AI VENDOR: Ensuring API Success on IBM i: Why Creating a RESTful API Isn’t Enough Theory

10:30am EDT

23AC POWER Pick: Enterprise DevOps Regency A 23AE POWER PICK: Are You Covered: Brand New Tooling for Quality Assurance Regency C 23AD IBM i Access Client Solutions Deployment Guide Regency B 23AI Securing Sensitive Data in DB2 for i Theory 23AF Hidden Gems of Open Source Regency D 23AG Programming standards and guidelines Regency EF 23AB Application Security Basics Network 23AA Managing IBM i PTFs Concept A-D

11:30am EDT

COMMON Expo Cosmopolitan Ballroom

12:00pm EDT

Lunch in the COMMON Expo Cosmopolitan Ballroom

1:30pm EDT

25AD External User Defined Table Functions (UDTF) – Hidden Secrets Regency B 25AI Advanced SQL Set Processing Theory 25AB Connecting to Db2 on IBM i with Node.js Network 25AC PHP and Database Access Regency A 25AF A Nerd's Guide to DATA-INTO in RPG Regency D 25AG What’s New in 7.2, 7.3 and 7.4 Security Regency EF 25AA What You Need to Know to Successfully Upgrade to 7.4, 7.3, and 7.2 Concept A-D 25AE Best Practices for IBM i Performance Management Regency C

2:45pm EDT

26AB Building Reusable APIs Network 26AF REST for IBM i, its more that just for ILE programs. Regency D 26AD IBM i ACS Advanced Usage and Administration Regency B 26AI Advanced SQL DDL - More Than Just Physical Files Theory 26AE POWER Pick: What's New with Backup Recovery on IBM i - Including Virtual Tape and Encryption Regency C 26AA PANEL: Women in IT - Perspectives Concept A-D 26AC VENDOR: Tools to Modernize Your IBM i Applications and Adopt DevOps Regency A

4:00pm EDT

27AE POWER Pick: RDi and Git - The Basics Regency C 27AG JavaScript 101: First Look from an RPG Perspective Regency EF 27AF Be a Customer Service Superhero Regency D 27AB Intro to React Network 27AC Help I've Fallen and I Can't git Up Regency A 27AD POWER Pick: Finally – RPG Freed from the Fetters of Fixed Format Regency B 27AI Ch Ch-Ch-Changes – What ‘s your shame? – Not knowing what changed on your system! Theory 27AA Sponsor: The Path to the IBM i Cloud Concept A-D

5:15pm EDT

28AE Tips and Techniques for Shrinking Backup/Recovery Windows on IBM i Regency C 28AA What's New in Notes and Sametime 10 Concept A-D 28AF Modernization on IBM i Heading to Normal Regency D 28AD IBM i OS Networking Security Regency B 28AB Creating APIs in 5 minutes with Node.js and Loopback Network 28AC Accessing IBM i from Python Regency A 28AG IBM i Encryption Made Easy Regency EF 28AI My CIO said we are moving to the cloud – Now what do I do? Theory

8:00am EDT

31AG POWER PICK: Accessing IBM i from Other Systems Regency EF 31AD Group By, Having and multi-dimensional Grouping Regency B 31AI Choose Your Own Adventure: An Interactive IBM i Modernization Case Study Theory 31AF Everything they never taught you! Regency D 31AE Controlling Access to IBMi Systems and Data Regency C 31AA Storwize Storage Advanced Topics Concept A-D 31AC Managing Open Source on IBM i with Containers Regency A 31AB Debugging your web application from A to Z (Apache to Zend) Network

9:15am EDT

32AF The ABCs of RDi Shortcuts Regency D 32AA The Latest on Putting IBM i to the Cloud Concept A-D 32AC VENDOR: Go Beyond Modernization with Profound Logic Regency A 32AD Revamping Your Web Pages for Mobile without CSS3 Media Queries Regency B 32AE Give me an hour, and I'll give you a week! Regency C 32AB CI/CD workflow for RPG Network 32AI What Happened To All The Memory / Faulting Best Practice Guidelines?!? Theory

10:30am EDT

33AC Getting the Most Out of BRMS Recoveries! Regency A 33AD VENDOR: Create IBM i web and mobile dashboard apps with no programming (unless you want to) Regency B 33AI Comparing Modernization Approaches : RPG OA, Node.js, PHP and more Theory 33AB Djust Django: The Powerful, Flexible Python Framework Network 33AF Introduction to Python on IBM i Regency D 33AE SQLRPGLE the Better File Access Regency C 33AG Authority Collection in 7.3 & 7.4: Locking Down Security for Sensitive Data, Files and Objects Regency EF 33AA Tales from the Datacenter: Worst Practices in Systems Management Concept A-D

11:45am EDT

34AA A Free IDE Alternative For RPG Concept A-D 34AC Git for Open Source and Source Control Regency A 34AD Recursive Queries and Hierachical Query Clause Regency B 34AB Next Gen UI/UX & IOT Extensions for IBM i Terminal Emulation Network 34AI Designing Responsive IBM i Mobile Web Applications Theory 34AF Advanced Python Programming and IBM i Regency D 34AE Mission: Possible! Journaling Forensics 101 (with Free Tools) Regency C 34AG Rapid Fire Admin Regency EF