View the Conference Grid

Conference Sessions

IBM Informix Technical Sessions
  • Faster, Faster and then Slow - Performance Measurements for an Informix Instance.
  • A Guide to Securing the Database
  • Insights from the Top 10 Database Breaches of the Past Year
  • Data Integration with Informix
  • Application Security For Informix Developers
  • Migrating from Mysql to Informix
  • Informix PDQ - Pretty Darn Quick
  • Best Practices for Upgrades with Large Deployment Requirements
  • Informix Warehouse Accelerator on a Cluster
  • Automatic Database Tuning and Monitoring with Informix
  • Best Practice for database Object Placement
  • Is Your Linux System Ready For Informix Database?
  • Tuning Data Warehouse for High Performance in Informix
  • Migrating a VLDB Informix to 11.70 with Zero Downtime Using ER and Compression Feature
  • Using Informix Dynamic Server Compatibility Features
  • Using XML Capability in Informix Dynamic Server
  • Exercising with IDS and Perl
  • Overcoming Performance Challenges - [Your organization]'s Got Talent
  • Informix SQL - Using New SQL Features
  • Live Platform Migration of Informix, The British Sky Broadcasting Experience
  • From I4GL to Genero - Modernization 101
  • Informix Applications Uncovered on iOS
  • Installing & Configuring Genero
  • Dude, Where's My Buffer?
  • IDS Single Sign-On (SSO) Authentication
  • Debugging Java Udrs: A Primer
  • Best Practices in .NET Development with Informix
  • Query Rewrite Performance for Views and Derived Tables
  • Support of Case Insensitivity in IDS
  • How To Achieve Leaps in Warehouse Query Performance with IDS
  • Index Design: Myths, Realities, and Magic
  • Implementing Database Encryption with Informix
  • Performance Tuning and Indexes, Understanding BTSCANNER
  • Performance Tuning with SQL Shared Memory Caches
  • Using SSL to Encrypt Database Network Traffic
  • An Overview and Discussion of Stored Procedures as User Defined Routines
  • Developing a Mobile Application in Genero
  • Do Stats Better - AUS pre-11.xx and Doing AUS Better than AUS
  • Doing Storage Better
  • Exploring and Understanding Flexible Grid for Your Industry Using Real Customer Scenarios
  • How Do I Share Data from Other Database Vendors in OLTP Environment?
  • Data Warehousing
  • Open Source Tools and Informix Warehousing
  • How to Combine Informix TimeSeries with the Informix Warehouse Accelerator for Analytic Performance
  • Maximizing DBA Resources with Database Autonomics
  • Put Your Storage on a Diet
  • Generate Reports using Excel - Drivers not Required
  • Troubleshooting and Tuning Informix I/O Performance
  • What's Inside Informix Shared Memory
  • Informix and Android: dbaccess, OAT, and More
  • Maximizing Performance With Informix TimeSeries
  • Eat OATs? Keeping Healthy with Informix's Graphical OpenAdmin Tool
  • Writing C-UDR (User Defined Rountine) the Basics
  • Deploying Solutions with Informix Warehouse Accelerator - Customer Experiences
  • All about Virtual Tables: The Secret of TimeSeries
  • A Customer Explores the sysadmin Database
  • Exploring the System Catalogues
  • Rolling Upgrade of IBM Informix Server
  • Never Hard-Code Anything, Ever!
  • Best Practices for Availability
  • Implementing Your Own CDC Application
  • Add a Python to Your Informix Programming Toolbox
  • Modernizing Case Studies
  • RESTful Genero Applications
  • Dummies Guide to TimeSeries
  • PHP and Informix
  • Update on Informix and Open Source
  • Informix Implementation on Pharmaceutical Distribution Company: HDR, ER, Hardware
  • Mobilize Your Data with Informix & Android
  • Informix DBA - A Newbie's Perspective
  • Informix Enterprise Gateway
  • SDS Architecture and Testing Scenarios in the Real World
  • SDS Exploration, Limitations, and Demo
  • Basic Text Search
  • Performance Monitoring using Health Advisor OAT Plugin
IBM Informix Hands on Labs by IBM
Installation and Configuration of Optim for Informix - Optim in action!

IBM Optim is an enterprise data management product that addresses critical business issues, such as Data Drowth Management, Data Privacy Compliance, Test Data Management, migrations and retirements.

In this hands-on-lab session, we would cover Optim installation and configuration for Informix. This session will not only cover ASCII (single byte) code pages but also how Optim needs to be configured for multi-byte code pages. This hands-on-lab would demonstrate all the data types supported by Optim for Informix including large objects. This session would cover all the aspects of Optim solutions i.e. Data Growth, Test Data Management and Data Masking. Informix flagship innovation MACH11 will also be demonstrated with Optim. Add-on for this session would also cover configuration of Optim for Informix across Unix/Linux platforms. This 3 hours session promised to be action packed and full of new and exciting learnings for Informix in Optim!

Limber Up: Flexible Grid for the Stiff

You've used Informix for years, no decades. You're a master. What about all that replication technology? Well you've heard about it, know a little about, but just scratched the surface. Can it really replicate DML and DDL? Do all I really need to know is SQL? Is it possible to work with multiple servers as easily as a single one? Could it help my business? This Hands-On Lab explores various aspects of the Flexible Grid in a way that gives the stiff and rigid time to warm up.

Demo of IDS Security features

The audience would learn to setup any IDS security feature of their interest. IDS authentication mechanisms like Single Sign-On and PAM authentication need more machine specific setup before usage. This demo would show example setup for security features such as Single Sign-On, PAM authentication, Mapped users and SSL encryption.

Analysis of Implementing Storage Compression in an Embedded Enterprise Replication Environment

We performed a case study with a customer's environment and data that gave us very positive results with Storage compression. This study will help our user community decide the benefits to them.

The first session will deal with the steps to enable Storage Compression and what to monitor. Attendees will perform the changes on a 2 node ER pair.

The second session will deal with analysis of the results and when to enable the feature and if time permits other tuning trials.

Hands-On Lab for On-line Data Migration from native codeset to UTF8 for 24/7 business

When organizations go global there is a need for central database to accept data from multiple languages to simplify data management tasks, and to make quick business decisions. For this reasons organizations would like to migrate data stored in native codeset to UTF8. This is a challenging task for 24/7 businesses to make data available for business "all the time" while migrating data to UTF8.

Using IBM Informix Enterprise Replication technology, organizations can migrate and consolidate data stored in native codeset format to UTF8 with zero down time to data and applications.

This Hands-On Lab helps audience to just start on how to setup Enterprise Replication and migrate data to UTF8 codeset without downtime to applications and data, and also troubleshoot problems while migrating data.

Informix Warehouse Accelerator - Installation and Setup

The Informix Warehouse Accelerator (IWA) is a workload optimized, appliance-like, add-on, that enables the integration of business insights into operational processes to drive winning strategies. It accelerates select queries, with unprecedented response times.

This session will be used to explain the installation and setup of IWA software.

The Beauty of Informix Disk Structures

The simple beauty of Informix disk pages, their various contents and how they play together is one of my favorite topics. Occasionally it's good to know a bit about them.

I'll present on and have people look at these evergreen subjects

  • Chunks
  • Pages and their structure
  • Page types
  • All sorts of spaces, physical and logical logs
  • Data and index partitions
  • Compression internals
  • TimeSeries on-disk representation (if I make it this far)
  • SMI interface to disk structures
  • Migration and platform aspects
  • All people ever wanted to know

Besides bundled utilities like oncheck and SMI, a support tool called 'onion' will be used that allows for that certain something that traditional tools sometimes are missing.

Test Drive some of the notable new Informix 11.70 features

Rather than just reading about new Informix features, actually implementing and testing those features goes a long way in understanding what the feature is all about, how it works, what it takes to implement, and whether it would be practical in your production environment. In this hands-on-lab, you will work with some of the more noteworthy new features in 11.70 including transaction completion during cluster failover, automatic storage provisioning, defragmenting partitions, flexible grid setup and management, quickly clone a primary server, convert cluster servers to ER nodes, fragment level statistics + update statistics, interval fragmentation, multi-index scans, and some of the new built-in scheduler tasks including automatically terminate idle sessions and notification of corrupt indexes. With each feature, you will learn how to monitor related information using command line utilities and/or OAT.

IBM Informix Genero Track
HTML5 - The Universal Client for Web, Desktop, Mobile and Tablets This session examines how to use Snippets, CSS3 & Javascript customization with the HTML5 client, as delivered with Genero 2.40. You will learn about the changes in the technologies between the AJAX and HTML5 offerings, examining HTML5 as a unique renderer for native client : the hybrid application concept. The schedule and roadmap for further HTML5 development will be presented.
Installing & Configuring Genero Basic Genero complete stack standalone install + setup (Windows + Linux) and connection to the database of choice (ODI), GAS/as.xcf config, Genero Studio server config, GRW, connecting to server, ODI
From I4GL to Genero - Modernization 101 Modernizing legacy I4GL code is easy with Genero Studio and the BDL language. We'll use Genero 2.40 and the Informix Stores demo database to demonstrate how to:
  • Import a migration project into Genero Studio
  • Re-compile and run the Stores demo applications with Genero BDL
  • Enhance the migrated application with Genero features
  • Enable the application for the web (time permitting)
Desktop vs. Webtop Since many applications are moving to the Web, do we still need desktop applications ? With the emerging trend towards the Software as a Service (SaaS) business model, this is a hot topic that will drive architectural decisions. Join us for a high-level exploration of the pros and cons, technologies and challengies of developing desktop versus Rich Internet Architecture applications with Genero.
Modernizing Case Studies Century Software has migrated over 7 million lines of Informix 4GL legacy code to Genero. The expertise and tools developed by Century Software in porting their Enterprise Financial Suite to Genero has also been used to migrate other clients 4GL applications. This presentation via case studies and code examples will describe our methodology and tools for migrating a large codebase.
What's new in Genero 2.40? Join us for an interactive overview and demonstration of the new features in Genero 2.40. Find out about the latest language, Web, desktop and application generator features provided in this latest release of Genero.
Software-as-a-Service with the Genero PaaS Cloud as-a-Service platforms are being rapidly adopted by enterprises to deliver more agile IT services, and ISVs must develop Software-as-a-Service offerings to maintain and grow market share in a competitive cloud world. This session will discuss the path forward for ISVs and enterprises who wish to leverage the cloud and develop Genero based Software-as-a-Service offerings.
UI Design Concepts for Genero Applications Do you need a crash course in Graphical User Interface design? If you've moved from developing for green screens to a graphical desktop or web environment, this session is for you. We'll look at graphical user interface (GUI) concepts and standards and how to apply them to your Genero applications. We'll also explore common mistakes ASCII-oriented developers make when moving to a GUI environment. You'll leave with a checklist that you can apply to your applications to easily identify and resolve common GUI mistakes.
Business Application Modeling in Genero Studio Business Application Modeling tools shipped with Genero Studio provide a high productivity environment for creating business application from design models rather than coding. The pre-defined template set shipped with the product permits the development of applications with complex forms implementing CRUD, master/detail, lookups, and zoom modules, as well as complex reports which support (as default) export to PDF, Excel, and RTF. Learn how to take advantage of the power of these tools using the default template to create fully functional applications in a just few clicks.
Creating a Web Service with Genero / Interoperating with Java and Web Services Transforming your existing 4GL business logic into a Web Services application and deploying it to the world. Integrating Genero in your Enterprise Environment. This would focus on leveraging your 4GL based components in other applications across the enterprise.
RESTful Genero applications The Genero programming language has supported SOAP web service consumption and provision for many years. But Representational State Transfer (REST) has gained acceptance across the Web as an alternative to SOAP Web services. Google, Facebook, and Yahoo either deprecating or removing their SOAP services and replacing with RESTful web services is proof of this trend. So how can you use Genero to participate in this RESTful environment. This presentation will show (with code examples) how to consume and provide a RESTFul web service using the Genero Web Service COM library. Also the handling of non XML payloads like JSON will be discussed.
Designing Graphical Reports with Genero Studio Part I In this session, you will learn about the feature set of the Genero Report Writer and how how to publish and design graphical reports: invoices, accounting reports, pre-printed forms, labels, and more. This session will demonstrate the steps for creating graphical reports using report wizards and output reports to various formats (pdf, image, MS Excel, and so on).
Developing a mobile application in Genero A step by step guide to developing a functional mobile application in Genero
Genero Deployment Strategies Should you be deploying with the Genero Application Server? Should you be deploying with SSH, SSL? This session examines the deployment of web applications and web services with a look at performance, security, and authentication.
Debugging Genero Applications Understanding all different possible layers & technologies involved in a typical Genero deployment/architecture is key to debugging Genero applications. Join us for this session, where will will discuss the debugging tools and features of Genero Studio and other products from the Genero product suite, and how they can help you in your debugging efforts. We will end the session by briefly introducing you to some of the more common third-party tools that are being used to aid in debugging Genero applications, their environment, and the solution architecture.

Stay tuned to this page for the latest information about specific sessions at this year's conference.

All items subject to change