Scheduled and Alternate Sessions
Session Abstracts
Keynotes
Big Data Keynote - David Barnes
- With the emergence of Big Data, new technologies have appeared that can gather and process massive amounts of information in a cost-effective way. These storage and processing technologies, such as Hadoop, have been the focus of attention in most Big Data discussions. Now, with new analytic solutions like IBM’s Jeopardy!-winning Watson, organizations are turning their attention to how analytic solutions can unlock the economic value of Big Data and provide actionable insights by putting powerful and easy to use tools in the hands researchers, business users, and domain experts.
Back to Top IBM - An Investment in Informix - Innovation for Champions - Arvind Krishna, Martin Wildberger
- Dr. Arvind Krishna and Martin Wildberger will host a keynote presentation which is sure to be a highlight of the conference. Plan to attend to hear how Informix fits within IBM’s larger IM strategy and how ongoing investments are delivering new value propositions to clients and partners alike. You will also have the opportunity to hear about important global advancements in Information Management, Big Data, and Business Analytics and Warehousing
Back to Top The Informix Way - Forever Relevant For A Growing Smarter Planet - Jerry Keesee
- Jerry Keesee will once again deliver a keynote presentation providing his unique perspective on Informix development. Don’t miss this opportunity to hear how Informix clients and partners are using the newest Informix innovations, as well as key focus areas that are driving the Informix roadmap.
Back to Top
Technical Sessions
A Case Study of the German Aerospace Center: Using Satellite Imagery to Help Build A Smart - Alexander Koerner
- The German Aerospace Center (Deutsches Zentrum fuer Luft- und Raumfahrt; DLR), acquires information from imaging satellites to help provide rapid response to major world disasters. This session will look at the myriad of requirements and technologies used to provide smarter data to authorities and aid workers alike. Management System (DIMS).
Back to Top A customer explores the sysadmin database - Jack Parker
- The sysadmin database provides some new functionality to the Informix product and a rich new environment to explore. Come listen to such an explorer report back on his findings. This is useful to two communities 1 - colleagues who want to take advantage of the features and want to hear from a fellow traveler, 2 - from the IBM developers standpoint to understand how their features have been interpreted in the field.
Back to Top A Guide to Securing the Database - Noa Bar-Yosef, Rob Rachwald
- The enterprise database infrastructure houses a gold mine of information highly coveted by malicious hackers and spiteful insiders. As database threats escalate and the government tightens compliance regulations, the need for database security is imperative.
Imperva's own research organization, the Application Defense Center (ADC), has identified the top 10 most dangerous threats affecting today's organizations, as well as provided background and general risk mitigation strategies. Included among the Top 10 list are the following three threats:
• Excessive Privilege Abuse: When users (or applications) are granted database access privileges that exceed the requirements of their job function, these privileges may be abused for malicious purpose.
• SQL Injection: When a perpetrator inserts (or injects) unauthorized database statements into a vulnerable SQL data channel.
• Denial of Service: When access to network applications or data is denied to intended users.
Back to Top Add a Python to your Informix programming toolbox - Mark Rees
- Python is an open-source, dynamically typed, object-oriented programming
language. It offers an easy learning curve and access to a vast array of libraries
including Informix database access. With implementations available for most
operating systems as well as the versions that run under the Java and .NET
virtual machines, you can add Python to your Informix database administration
and application programming toolbox. The presentation will give an overview of
the Python programming language, discuss the Python DBI and the libraries that
allow access to Informix databases. Code examples will also be provided and
explained.
Back to Top All about Virtual Tables: The Secret of TimeSeries - Pradeep Natarajan
- TimeSeries data is all the rage now! Even though Informix has supported
TimeSeries data since the 90s, the rest of the world has just woken up to this
fact. The functionality that makes TimeSeries processing possible is Virtual Table
Interface (VTI). VTI is not just for TimeSeries data. It is an extensibility feature
that allows the users to manipulate their own data type in very unique ways. In
this session, the audience will have a chance to learn about VTI, how it enables
TimeSeries, and how to take advantage of it.
Back to Top Always Online: Modifying your server and database schema while keeping your apps online - Uday Kale
- MERGE SESSIONS 106 164 200 Session will focus on the new IDS features that let you update the server configuration and alter schema while keeping your apps online.
Attendees will learn about the many features IDS has added in recent releases to enable online schema updates and dynamic server reconfiguration.
Back to Top An Overview and Discussion of Stored Procedures as User Defined Routines - David Jay
- This session will explore the advantages and disadvantages of User Defined Routines, written in stored procedure language. We will also explore how they are created, stored and accessed, along with a handful of examples that demonstrate when UDR's are most useful.
Back to Top Application Security For Informix Developers - Tom Beebe
- You have heard about the ever growing frequency of companies in peril after web based attacks. This presentation will cover a number of the common mistakes that developers far too often make when writing web based database code. It can be trivial to secure your code if you know what to look for. Live examples of common exploits will be shown.
Back to Top Ask the Experts - Performance/Autonomics - Scott Lashley, John Miller
- Scott Lashley and John Miller will answer your questions regarding performance issues and autonomics.
Back to Top Automatic database tuning and monitoring with Informix - Sanjit Chakraborty
- This session will explain how Informix can helps enterprises better manage their database administration operations, reducing down-times as well as the overall time taken in database management. We will discuss:
- Different automatic tuning features available with Informix. For example: automatic readahead, checkpoint, virtual processes, LRU, re-optimize SQL routines etc..
- Different database administration activities that can manage dynamically. For example: dynamically defragment partition extents, automatic update statistics, dynamic configuration changes, dynamic logical logs, PDQ, query explain, optimizing data storage etc.
Back to Top Backup and Restore Tips and FAQ's - Hyun-Ju Vega
- This presentation is a summary of the Informix backup and restore landscape from the view of the perennial questions that seem to come up. Why is ontape backup faster than onbar serial backup? What affects backup/restore performance? Do I have to restore all dbspaces? How does onsmsync work? What's the relationship between the ixbar file and sysutils? How do I restore a fragmented table using table-level restore (all the examples just show a table in a single fragment)? What's the proper way to run archecker (backup verification)? And more ...
Back to Top Basic Text Search - Kate Tomchik
- A presentation on how to set up the BTS blade for your environment followed by examples of how the Searches work.
Back to Top Best practice for database object placement - Sanjit Chakraborty
- Informix allows you to control the placement of databases objects across physical storage devices. A poor database objects placement can cause significant performance impact. This presentation will discuss how users can achieve optimal database performance by :
- Intelligent disk layout
- Table-location and partition strategy
- Consideration index performance
- Impact of logical logs and physical logs size and location
- Deal with smart large objects
Back to Top Best practice for upgrade to Informix 11.70 - Sanjit Chakraborty
- Explains important aspects involved in upgrading to Informix 11.7. This session will review following sub-topics:
- Plan for upgrade
- Best upgrade approach: in place or not
- Migrating across platforms, codepages, and page sizes
- Data movement utilities and when to use them
- Disaster recovery plan for upgrade failure
- Non conventional upgrade solution
Back to Top Best Practices for Availability - Davis Kwong, Davis Kwong
- This talk will discuss many of the best practices for a site using any form of availability, including clustering, basic ER, or The Flexible Grid
Back to Top Best Practices for Embedded Data Management - Pradeep Natarajan
- A small footprint, a silent install, self-managing capabilities - these are some of the critical things to consider when choosing to embed a data management solution. This session will look at requirements and best practices for embedding data management in your application to offer customers a world-class solution at a reasonable cost.
Back to Top Best Practices for Upgrades with Large Deployment Requirements - Jeremy Bowman
- Points that will be covered include upgrade goals across a large enterprise,
best practices in performing upgrades in such a way as to end up with
standard layouts and configurations across the enterprise as a condition of
success, and how to work with the business and technical customers to
ensure success while overcoming obstacles like switching operating
systems on the fly, Informix bugs, lost source code and high availability
systems that can have no or minimal downtime,
Back to Top Best Practices in .NET development with Informix - Brent Gross
- This presentation focuses on application development in .NET with Visual Studio 2010 and .NET providers available for Informix servers.
Application development techniques are presented for both windows apps and web apps, both traditional ADO.NET as well as the Entity Framework - enabling LINQ applications.
This presentation also discusses schema evolution available within Visual Studio as well as common pitfalls and how to avoid them.
Finally - direction is given relative to future priorities.
Back to Top Beyond Relational - Leveraging User Defined Data Types and Routines to Develop Advanced Applications - Madison Pruet, Davis Kwong
- The development of some of today's most advanced applications requires an extension of the relational data model to include more complex data types. Many of these applications pose new functionality and performance requirements as well, such as with multimedia web applications, geographic information systems, and time series applications. This session will give an overview of data management requirements for complex data types, and will attempt to demystify to concepts of user-defined data types and routines.
Back to Top Building an operational data store with Informix data on Netezza - Paul-John To
- Create operational data stores to produce day-to-day or week-to-week executive summary reports in seconds. Netezza's workload management and massively parallel processing (MPP) architecture makes it the ideal platform for running complex analytical queries. Learn how to integrate ETL practices with the Informix and Netezza loaders, differences in schemas between Informix and Netezza, and everything you need to create dynamic reports and support dynamic decision-making processes.
Back to Top Business Application Modeling in Genero Studio Part I - Christophe Meyer
- 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.
Back to Top BUSINESS: Using Informix with the new Ultra-light Websphere Server - Ajay Gupta
- WebSphere has a new fast ultra-lightweight application server
that is in Alpha trial right now. This session will explain
why you need an application server and show you how to
develop a Java Server Page. A live demo will create an
Informix powered JSP in less than 5 minutes and less than 20
mouse clicks. You'll come away with the skills to try this
at home.
Back to Top Business:Using IBM Data Studio with Informix - Anson Kokkat
- This presentation is an introduction to the next generation of Data Studio and its many capabilities including object management tasks including complex change management, administrative tasks such as runstats, job management including scheduling, health monitoring, query development and refinement, query tuning, creating SQL and command scripts, routine development and debugging.
Back to Top Case Study for TPC-C Informix Innovator-C benchmarks - Eric Vercelletto
- 300 TPC-C terminal sessions on a low range server with Informix Innovator-C? you bet ?”
A large number of Informix users have been wondering about how much load would Informix Innovator-C handle.
This session will provide you with the answer.
Back to Top Creating a Web Service with Genero / Interoperating with Java and Web Services - Florencia Vitale
- 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.
Back to Top Customer Success Story (Stories) - Scott Barney
- M&M or Versaterm
Back to Top Data Integration with Informix - Rob Beal
- Today, the Informix database shares the data environment with other databases and non-relational sources of data. This presentation will explore the many different ways to get data into and out of Informix. We will discuss tools that are native to Informix, and those that are not.
Most experienced DBAs will have used some of the tools discussed in this presentation, but there will probably be one or two that you have not used, but wanted to check out, and possibly one or two you never heard of.
The purpose of this presentation is to provide a short overview of the tools, when and why to use them, and directions on where to find more information.
Back to Top Data Warehousing Technology Trends - What You Need to Know - Frederick Ho, Rajesh Nair
- There have been many changes in data warehouse technologies spanning a few generations, with recent trends toward columnar and in-memory databases. Learn what technologies are hot, why they matter, and how you can benefit from them.
Back to Top Debugging Genero Applications - Delane Freeman
- 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 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.
Back to Top Debugging java udrs: a primer - Laksmana Skaray
- Modern database engines allow developers to design user defined routines in a multitude of languages. Though most languages are specific to a single database engine, Java is available in most, which makes it a viable proposition for this reason alone.
Sounds interesting? Not all that glitters is gold though: the other side of the coin is that debugging java udrs running inside a database engine is not as straight forward as debugging standalone ones.
This presentation steps through the basics of getting a java debugger to look under the covers of a java udr as it runs nside an Informix Dynamic Server instance.
Back to Top Deploying Solutions with Informix Warehouse Accelerator - Customer Experiences - Rajesh Nair, Dennis Allen, Frederick Ho
- MERGE SESSIONS 129 205 Primary focus on
- Understanding the different warehouse offerings, related tools
- - "When, what, how, why" of the two strategic offerings
- Examples from different real life deployments/testing
- How the different warehouse offerings fit into these scenarios
Back to Top Designing Graphical Reports with Genero Studio Part I - Rakesh Naik
- 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).
Back to Top Desktop vs. Webtop - Laurent Galais
- 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 challenges of developing desktop versus Rich Internet Architecture applications with Genero.
Back to Top Developing a mobile application in Genero - David Jay
- A step by step guide to developing a functional mobile application in Genero.
Back to Top Diary of Information within Informix Dynamic Server - Mukta Singh
- IBM ® Informix OLTP and Informix Warehouse accelerator are optimal and low-TCO database software that reduces costs and increases productivity by providing near-zero administration for small to highly distributed environments regardless of platform. When combined with IBM ® InfoSphere Integration and Governance Solutions - it delivers the winning combination of performance, cost and agility to help businesses of today enhance information integrity, availability and quality.
IBM ® Informix and IBM ® InfoSphere Integration and Governance Solutions' synergy brings to the table essential capabilities for data consolidation, data quality, data governance, life cycle management with high ROI that is a top differentiator for companies. IBM® InfoSphere Information Server, Optim and Guardium Solutions delivers the speed, quality and availability to reduce operation risks of an Enterprise Data, and ensures Trusted and Compliant data for today’s businesses.
Back to Top Do--Stats Better - AUS pre-11.xx and doing AUS better than AUS - Art Kagel
- The Informix Version 11.10 Auto Update Statistics feature is a good idea, but it is not available if your organization is still on an Informix version earlier than 11.10 or if you are using ANSI mode or non-logged databases. Learn how you can implement Auto Update Statistics in these environments.
Even if you are using version 11.10 or later, AUS may be taking excessive resources to run and if you have large numbers of tables, the AUS Evaluator may never complete and your AUS runs may not be processing all tables. Learn how you can do AUS the "right" way.
Back to Top Doing Storage Better - Art Kagel
- Planning your next storage subsystem for your server? Choosing between alternatives such as:
RAW Devices -vs- COOKED Devices -vs- Filesystem Files
Normal IO -vs- DIRECT IO (-vs- CONCURRENT IO on AIX)
RAID5 -vs- RAID10
Disk -vs- SSD
With so many options and combinations, what are the trade-offs? This presents the results of actual testing and real results.
Back to Top Dude, Where's My Buffer? - Tom Girsch
- Revised, corrected, and expanded from last year, this presentation covers how to monitor and manage the buffer pool, deal with contention issues, and generally understand what's happening with your buffers.
It covers how to look at the buffer pool using both onstat and SMI, and should allow time for a free-form question-and-answer session.
Back to Top Dummies guide to Time Series - Jacques Roy
- This talk will talk about Time Series.(put in by David Link)
Back to Top Eat OATs? Keeping Healthy with Informix’s Graphical OpenAdmin Tool - John Miller III
- Understand the capabilities and architecture of OAT, OpenAdmin Tool for informix. This will be an overview of the capabilities of OAT, highlighting such things as, Replication, Query Tracing, Storage Optimization, Performance History Graphs, Auto Update Statistics, Space Management, along with the many other capabilities.
Back to Top Enabling Social Media Analytics with IBM Infosphere BigInsights - Zach Zakharian
- Social Media Analytics with InfoSphere BigInsights - Your customers are effectively leveraging social media to make informed purchasing decisions. Blogs, forums, twitter feeds are rife with discussions about your products. Are you leveraging this bank of information ? How do you make sense of all this unstructured data and effectively leverage this in your decision making. This session will focus on InfoSphere BigInsights as a platform and how it enables one to glean useful information from social media and other sources of unstructured information. The focus of this session will be on text analytics over unstructured data, and integration with existing Informix infrastructure. Why Enterprise customers are struggling to understand how to tackle analytics over social media. This session will give them an overview of BigInsights as a platform with emphasis on text analytics.
Back to Top Ensuring Business Continuity with Always-On Data Access - Tom Rieger
- Continuous access to business information can rarely be achieved with a “one-size-fits-all” solution. A business employing 10 people requires information availability on a much different scale than a corporation of thousands. And, as businesses grow and expand across geographies, their information infrastructure needs the flexibility to meet new business opportunities without missing a beat. This session will examine different options and technologies for achieving high availability without breaking the bank.
Back to Top Everything you want to know about fast recovery - Sanjit Chakraborty
- Fast recovery is an automatic, fault-tolerant feature. This session will discuss different aspects of fast recovery:
- What is need for fast recover?
- When fast recovery is initiate?
- Fast recovery and logging
- Configuration parameters that control fast recovery
Back to Top Exercising with IDS and Perl - Nadir Doctor
- Perl is now a popular open source & versatile cross-platform
programming language which is no longer just for text
processing. It has grown into a sophisticated, general-
purpose programming language with a rich software
development environment complete with debuggers, profilers,
cross-references, compilers, interpreters, libraries,
syntax-directed editors and all other trappings of a "real"
programming language. People know that they can be creative
in Perl because they have freedom of expression. Computer
languages differ not so much in what they make *possible*,
but in what they make easy. Perl is *different*. In a
nutshell, Perl is designed to make easy jobs easy, and hard
jobs possible.
This session will provide a brief discussion of how to use
IDS with Perl. It will cover some Perl basics, advantages of
scripting with Perl, connecting to databases, selecting &
modifying data, creation of Perl modules & utilizing them to
reuse code.
Back to Top Exploring and Understanding Flexible Grid for your industry using real customer scenarios - Tom Rieger, Rajesh Nair
- Flexible Grid is often confused to be a problem for complicated requirements. This session will take the audience through building up the requirements : 1)from a simple HA primary-secondary environment , 2) an existing ER deployment and 3) multiple independent deployments that can benefit by defining a grid environment. The session will use real-life scenarios from various industry/customer scenarios that highlight the industry's business challenge, an existing configuration and how using capabilities of Flexible Grid, the customer can address current challenges or gain new benefits.
Back to Top Exploring the system catalogues - Jack Parker
- With the advent of data warehousing and its requirement for information about data, there has been a great deal of focus on metadata. Much of it deals with external repositories, and many have forgotten or do not realize that substantial metadata already exists within any Informix© SQL database in the system catalogs. Furthermore, knowledge of the system catalogs is a highly useful tool for the day-to-day maintenance of the database.
This discussion will walk through what is available in the system catalogues and how that information can prove useful.
Back to Top Faster, faster and then slow - performance measurements for an Informix instance. - Michael Pintus
- MERGE SESSIONS 177 148 253 This talk is aimed at customers new to Informix and will be
building up on the information
provided in "up and down around we go". This session will
focus on measurement helpful to
investigate the performance of an Informix instance.
Examples will be taken from real life problems support has
dealt with during the last year.
Back to Top From I4GL to Genero - Modernization 101 - Rakesh Naik
- Modernizing legacy I4GL code is easy with Genero Studio and the BDL language. We will 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)
Back to Top Generate Reports using Excel - drivers not required - Doug Lawry
- Demonstration of techniques to enable self-refreshing Excel workbooks linked to Informix databases that don't need drivers or anything else installed on the client PC. Faster, cheaper and more flexible than reporting packages. More secure and controllable than ODBC, with configurable limits on rows returned and run time. Full support for enterable parameters. Data extraction can alternatively be run centrally in advance and results retrieved in Excel
Back to Top Genero Deployment Strategies - Oscar Vera
- 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.
Back to Top How do I share data from other Database Vendors in OLTP environment? - Sudhir Katke
- Today companies use various Database Technologies within their
environments. There is a need for them to share the data
without duplicating the data.
This session will explain the way to achieve that.
Back to Top How To Achieve Leaps in Warehouse Query Performance with IDS - Frederick Ho
- MERGE SESSIONS 104 224 225 252 See how to get mind-blowing leaps in warehouse query performance in orders of magnitude with IDS Ultimate Warehouse Edition. The query timings also can potentially change the way we do application development since you wont have to work around some limitations.
Informix Ultimate Warehouse Edition released this Spring enables OLTP customers to get performance leaps in orders of magnitude for their warehouse queries. Attendees will learn how to set up, which queries will get the performance benefit and how this blows the competition. It will also touch up on the change in application development methods that this opens up.
Back to Top How to combine Informix TimeSeries with the Informix Warehouse Accelerator for analytic performance - Kevin Brown, Andreas Weininger
- The Informix time series data type has been already optimized for performance and storage requirements of time stamped data in operational data stores. For some specific in depth analytic requirements, based on the stored time series data, it might be beneficial to offload some of those data into the Informix Warehouse Accelerator to gain additional query performance. This session will discuss some use cases when it might be appropriate to consider the combination of Informix time series data with the Informix Warehouse Accelerator. In addition it will introduce the technical steps required to make such a combination happen.
Back to Top HTML5 . The Universal Client for Web, Desktop, Mobile and Tablets - Olivier Imbert
- 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.
Back to Top IBM Informix in the Social Media - A snapshot - Louis Cherian, Beth Flood
- I would like to present the following at IIUG 2012
1. A snap shot of IBM Informix in the social media
2. Our growth in the past 1 year
3. Some of the highlights
4. How can we make this initiative better for all of us and Especially Informix, by helping each other
Back to Top IBM Infosphere Guardium and Informix - How does it work in the governance space? - Bill Plants
- IBM InfoSphere Guardium addresses the entire database security and regulatory compliance life cycle in a homogenous and holistic fashion. It enables finding and classifying sensitive data and monitor access to it and helps meet privacy regulations and laws such as SOX, PCI DSS. It creates a single, centralized audit repository for enterprise-wide compliance reporting, investigation and forensics.
Guardium provides Informix Database Audit Officers a centralized, extensive and extendable audit and regulatory compliance solution, independent of the audit configuration of the databases and their distribution. It helps prevent unauthorized access through its robust Vulnerability Assessment tests, thus ensuring the integrity of the data in the Informix data center. Guardium provides nearly fifty Informix specific Vulnerability Assessment tests to enable database security administrators to identify and assess security vulnerabilities.
Back to Top Identify and trouble shoots a server block - Sanjit Chakraborty
- This session will discuss different reasons of Informix server block; indentify the problem and necessary action to rectify it.
Back to Top IDS Single Sign-On (SSO) Authentication - Priya Govindarajan
- We see more of our customers using SSO. This will be a comprehensive SSO presentation (what, why, how) from an SSO expert. Demo would show step by step configuration of SSO
authentication (any audience requested platform) with IDS server.
Back to Top Implementing Database Encryption with Informix - Mark Jamison
- This presentation compares the various methods of Database encryption "at
rest" and then discusses implementing encryption using IBM's Database
Encryption Expert.
Back to Top Implementing your own CDC application - Madison Pruet
- Anyone can implement a Change Data Capture application fairly easily. This talk will describe the steps necessary to implement such a solution.
Back to Top Improve database development productivity & save tooling cost by using IBM Data Studio - Lakshman Sakaray
- Presentation will take a customer usecase and go thru each step of development how IBM Data Studio going to help to improve the productivity of Informix users. IBM Data Studio has something to offer for each type of users,demo for Java developers the rich Eclipse development Integrated development environment and utilities and tools to support Java application database development. For SQL developer and Administrator users how the IBM Data Studio going to help to improve productivity by using various features like object management explorer, powerful stored procedure debugger and deployment manager to deploy multiple scripts on test and production database at once.
We will also go thru the customer experiences how enterprise customers savings thousand of dollars by using free IBM Data Studio and support. How Independent Software Vendor users can make use of its various platform support for Informix, Sybase, Oracle, DB2 LUW, DB2 Z and Derby instead of paying for various tools.
Back to Top Index Design: Myths, Realities, and Magic - Martin Hubel
- Many applications enter production with sub-optimal indexing
strategies. Regardless of the reasons for this, performance
can be substantially improved if indexes are designed or
redesigned to better match the needs of the application, to
reduce search times, and to avoid sorts.
This presentation will review index structure, and discuss a
number of ways to use and redesign indexes without affecting
application integrity.
Back to Top Informix and Android: dbaccess, OAT, and more - Marty Lurie
- Use the Android open platform to work on Informix! This
session will provide a brief introduction to the Android
OS. We'll then bring up dbaccess and some other command line
options on the smartphone. Using browser capabilities we'll
show OAT running on the phone. And we'll wrap up with a
REST based web service to show native application development
options to access Informix data.
Back to Top Informix and open source: big data with Hadoop - Marty Lurie
- Planning to implement a big data solution and not sure where to start? Massively Parallel Processing (MPP), Hadoop, NoSQL - what does it all mean and how do you know the right solution for your requirements? This session will explore these technologies and includes some hands-on testing and demos.
Back to Top Informix Applications Uncovered on iOS - Jacques Roy
- MERGE SESSIONS 182 260 The presentation will cover iOS support for Informix. Business / Utility / Gaming
Applications can be seamlessly written to Support Informix as the backend. The
development environment used on iOS via open source, web services etc. will be
detailed for application development. Commercial vendors in the space will be
detailed additionally.
DBA's can manage the Informix Servers on their iPhones. The upcoming vNext
Genero stack integration on Smartphones will be covered in conjunction to the
above.
The whole new associated Smartphone business opportunity will be uncovered.
Back to Top Informix Bells WallStreet! - Michael Pintus
- In times where the Global economic backbone WallStreet is more intensely
technologically challenged than ever in the past decade, Informix is fully geared
to be the database choice.
The presentation walks thorough the recent additions of Flexible Grid,
TimeSeries and the Warehouse Accelerator wrt to WallStreet or other global
Stock Exchange requirements. Grid has enabled the connected exchanges to
seamless inter-operate while Time Series is ticking all volatile market
movements with half the data storage …
Informix Grid enables server and storage resources to be added to or removed
from the system without requiring complicated configuration changes, thereby
enabling flexible deployment that avoids the problems inherent in the fixed
topology model. Stock Financial Analysis is now more readily processed with
Informix Warehouse Accelerator.
The presentation provides live demos of "Belling the WallStreet"!
Back to Top Informix DBA - A Newbie's Perspective - Jacob Shadix
- Necessary skills that college "failed" to teach
Transition from college graduate to entry DBA
Building a DBA from the ground up - Recommendations to build on for any DBA skill-set
Back to Top Informix DBA Guided Client Application Development - Yunming Wang
- Client application for accessing databases in a multitier architecture is usually developed and maintained independently. It is very important for client application developers to understand how Informix database server handles the requests sent from an application, including requests for connections, transactions, locks, etc. This presentation will discuss some good practices in terms of performance from an Informix DBA's perspective that developers should follow during their application development:
1) Database connection management
2) Static SQL vs. Dynamic SQL
3) Singleton updates, Bulk updates, and Violations table
4) Constraints and Indexes
5) Cursors, Locks, and Transactions
6) Data Types and Codepage conversion
Back to Top Informix Enterprise Gateway - Jacob Shadix
- Presentation includes an overview of gateway concepts, terminology, and practical usage. Dive into the installation, configuration, and security components of the Informix Gateway and resurface with a unique perspective on all things gateway.
Back to Top Informix High-Performance Federated Database System - Yunming Wang
- Informix high-performance federated database system refers to the integration of the Informix Dynamic Server and the Informix Enterprise Gateway for DRDA or ODBC. It allows Informix users to interoperate with non-Informix database systems transparently as if the underlying target DBMS appear to both client and server applications as an instance of Informix. You can integrate data from Informix and almost every heterogeneous database, such as DB2, Oracle, MySQL, etc. This presentation will cover everything you need to know about the Informix Enterprise Gateway for DRDA and ODBC, including the architecture, installation, configuration, administration, and troubleshooting.
Back to Top Informix implementation on Farmaceutical distribution company: HDR, ER, Hardware - Vicente Salvador
- Fedefarma is a Large Pharmaceutical distribution Company. This presentation, shows how Informix is used in a distribution company environment with more than 350,000 order lines each day and 7 warehouses around the country.
Customer experience transforming their legacy multiDB centralized systems to ER-Informix that allows centralized analysis and distributed processing transparently.
Hot Topics: HDR, ER, Data centralization, Offline processing, Datawarehouse.
Back to Top Informix in the Cloud - Mahesh Dashora, Davis Kwong
- Informix already exists in the cloud. This talk will discuss the common cloud providers and describe how Informix can be deployed in each of them.
Back to Top Informix PDQ - pretty darn quick - Jeffrey Bohm
- This presentation goes into the what, when, how, and why of Parallel Data Queries (PDQ).
It explains what PDQ is, when to use it, how to use it and of course why should it be used.
This also includes a few slides on the Informix Warehouse Accelerator (IWA) as an extension/alternative to DSS queries that can benefit from PDQ.
Back to Top Informix port for Identity Insight - Dennis Allen
- IBM InfoSphere Identity Insight is a powerful identity and social network analysis platform that combines pioneering identity and relationship disambiguation technology with innovative event processing capabilities to quickly and automatically provide actionable intelligence on persons, things and their connections. In this session, you will learn how Identity Insight helps organizations around the world use threat and fraud analytics to establish a unique identity, discover obvious and obscured relationships and monitor and correlate individual actions.
Back to Top Informix Roadmap - 2012 and Beyond - Mahesh Dashora
- IBM has delivered many Informix innovations in the past few years, enabling significant business benefits for clients and partners. This session will examine where Informix is relative to the data management market, where we expect to go in 2012, and will provide a glimpse of the ongoing strategy for continuing to enable smarter solutions.
Back to Top Informix SQL - Using New SQL Features - Jeff Filippi
- Give examples of how to use many of the new SQL features that have been added to 11.50 and 11.70 versions. Since there are many new SQL features, I will give examples on how they can be used in their database systems.
Back to Top Informix TimeSeries : Exploring the Extension - Anup Nair
- This session will explore the use Informix TimeSeries data type extension for handling time stamped data. It will being with the introduction of the data type and will further go into details of its usage, with examples
Back to Top Informix Warehouse Accelerator ** Billion rows benchmark demo - Lester Knutsen, Mike Walker
- I have been using the Informix Warehouse Accelerator for over a year and I am continually shocked at how fast it is. In one set of benchmarks it ran 9 hours of queries in 14 minutes. Mike Walker and I will demonstrate our current benchmarks with this exciting new database technology. We will demonstrate ad-hoc queries on a bookstore database with 250 million customer records and over a billion sales transaction records in the fact table.
Informix Warehouse Accelerator Demo Agenda:
1. Benchmarks - Fast Performance Demo
2. How to Setup the Accelerator
3. How the Accelerator Works
4. Smart Mart Demo - How to Automatically Build a Data Mart
Back to Top Informix Warehouse Accelerator - A look at the First Year and Beyond - Frederick Ho, Dennis Allen
- The Informix Warehouse Accelerator was first released at the end of March 2011. In this session, I will provide a summary of customer deployments, Proof of Concepts, and Partner initiatives on how this product is changing how customers view Data Warehousing on Informix.
I will then discuss plans for future enhancements and releases.
Back to Top Informix Warehouse Accelerator on Cluster - Andreas Breitfeld
- The presentation shows a live demo of Informix Warehouse Accelerator (IWA) on a cluster of cheap computers. Main topics explained are:
- hardware and software prerequisites to build a cluster of cheap computers for IWA
- IWA configuration and administration for cluster operation
- demo shows scaling of IWA for load and query tasks
Back to Top Informix Warehouse and Pentaho Open Source Business Intelligence - Lester Knutsen
- Pentaho is the open source business intelligence leader. Thousands of organizations globally depend on Pentaho to make faster and better business decisions that positively impact their bottom lines. The Pentaho BI Suite provides a full spectrum of data integration and business intelligence (BI) capabilities including ETL, OLAP, query and reporting, interactive analysis, dashboards, data mining and a BI platform that has made it the world's most popular open source BI suite. We will how you how to setup Pentaho with Informix and get started building a data warehouse using Open Source Software.
Back to Top Insights from the Top 10 Database Breaches of the Past Year - Noa Bar-Yosef, Rob Rachwald
- The cost of a data breach continues to rise. Last year was the first time data theft exceeded the loss of physical assets in dollar value. This talk will present data breach findings from the past three years and investigate trends in incidents.
The presentation will also explore the top ground-breaking database breaches of the past year. The selected breaches represent a blend of innovative attacks, updated vectors, and good old entertaining hacks. Each attack has one common thread: all proved costly for enterprises and governments. How can organizations reduce these costs and prevent such breaches? By comparing data breaches in 2010 to those in 2011 this talk will present a clear statistical graph on the state of today’s database breaches. Based on lessons from this past year, this presentation will provide security practitioners guidance for their 2011-2012 database security initiatives.
Back to Top Installing & Configuring Genero - Ramesh Srinivasan
- 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
Back to Top Is your Linux system ready for Informix database? - Sanjit Chakraborty
- Problem is not always resided inside the database. It can lies within the operating system. Is your Red Hat Enterprise Linux system optimally configured for Informix?
This presentation is a step by step guide for tuning and optimizing Red Hat Enterprise Linux running Informix database. It covers following topics on Linux:
- Kernel Upgrades
- Kernel Boot Parameters
- Memory Usage and Page Cache
- Swap Space
- Setting Shared Memory and Semaphores
- Setting File Handles
- Adjusting Network Settings
- Setting Shell Limits for the Inoformix User
- Enabling Asynchronous I/O Support
- Configuring I/O for Raw Partitions
- Large Memory Optimization
Back to Top Live Platform Migration of Informix – The British Sky Broadcasting Experience - Nicholas Geib, Andrew Curry
- Does moving production database servers from Solaris on Sparc to Red Hat on AMD sound like a challenge? Well how about doing this with minimal downtime? This Fall we undertook this project, and thanks to teamwork, careful planning, and powerful Informix technologies like High Performance Loader (HPL) and Enterprise Replication (ER) achieved some results worth talking about.
Back to Top Loading Data Warehouses without any Fancy Schmancy stuff - Mike Walker
- This presentation will show how a robust and very flexible datamart load process can be written using nothing more than UNIX scripts and the standard Informix utilities - dbaccess, dbload, High Performance Loader and External Tables.
This session will cover how to load multiple tables in parallel to maximize performance, validate the loads and follow best practices. It will also include suggestions for improving the flexibility of the datamart loads, and to simplify modifications.
Back to Top Making Smart Metering Smarter: TimeSeries to the Rescue - A case study - Doug Dailey, Anup Nair
- MERGE SESSIONS 173 244 232 This session explores the solution implemented at a large utility industry (Energy and Utility ) while migrating to Informix using Time Series data type, that enabled them to cut the storage cost in half with increase in performance and reduction of total cost of ownership.
Back to Top Maximizing DBA Resources with Database Autonomics - Tom Rieger
- The more a data server can automatically sense and respond to change without human intervention, means DBA resources can do more. This helps keep costs down while ensuring reliable and robust operations. This session will examine what "self configuring", "self healing", and "self managing" mean, and how organizations can take advantage of automonomic data management capabilities.
Back to Top Maximizing Performance With Informix TimeSeries - Kevin Brown
- Discover the latest best practices to optimize performance with Informix TimeSeries.
-Create basic TimeSeries data in your database.
-Use container pooling to spread container usage for optimal i/o.
-Best practices when loading TimeSeries data.
-Best practices when purging TimeSeries data.
-Monitoring loads and purges to ensure maximum throughput.
-Discuss practical lessons learned from the IBM/AMT-Sybex benchmark whitepaper.
Back to Top Migrating a VLDB Informix to 11.70 with zero downtime using ER and Compression feature - Celso Cabral Coimbra
- Migrating a Very Large Informix Database to a new box using version 11.70 with zero downtime using Enterprise Replication and deep compression feature in the target database.
Moving from a Solaris box using Informix 11.50 to a Linux Red Hat box using Informix 11.70 reorganizing the fragmentation strategy and without enough space to load all the data uncompressed in the target database. All the tables in the legacy database 11.50 are compressed as well.
Back to Top Migrating from Mysql to Informix - Tom Beebe
- If you have ever looked at an open source project and noticed that it required mysql yet again, don't fear, you can do something about it! This presentation will cover the basics of moving data from mysql to Informix, will compare some of the differences between the two engines, and cover some of the code changes that will need to happen to migrate an application from mysql to Informix.
Back to Top Mobilize your data with Informix & Android - Vicente Salvador
- On a mobile world, this conference shows DEISTER's experience on creating a framework for developing mobile applications.
Wich are the new challenges for mobile applications? This conference answers this questions: security, offline operation, bussines inteligence features, etc.
Back to Top Modernizing Case Studies - Mark Rees
- 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.
Back to Top Never Hard-Code Anything, Ever! - Darryl Priest
- This session will discuss how to avoid the pitfalls of hard-coding in code. Examples will be shown in many different forms, SQL, Shell, Perl, etc.
Back to Top One Point Soutions -Presenting, Designing, and Implementing a Data Warehouse using Informix & Cognos - Ron Flannery
- Does your management constantly ask you to create spreadsheets rather than focusing on your “real” job? Do you have challenges integrating data from your Informix and other data sources? Would a dashboard-driven drill-down environment help your company grow and understand its business in this competitive world? One Point Solutions will explain what it costs companies in time and profits, and how to use Informix, Cognos, and other IBM tools to resolve it. Using a real-world One Point Solutions success story for Superior Manufacturing in Chicago, He will explain: the process of presenting and “selling” the idea to management; identifying the company’s true business needs; designing, populating and implementing the data warehouse and associated Cognos reports and dashboards. We’ll also help you unravel the diverse IBM licensing options so you can identify only what you need, concluding with a real-world demo of how we created and implemented both the warehouse, reports, and dashboards.
Back to Top Onlog - Paul Watson
- onlog as been around since the product was first released,
however most people don't or won't use it as the output can be
hard to interpret. This presentation will show how onlog can
be used as a forensic tool to determine what has occurred
Back to Top Overcoming Performance Challenges - [Your organization]'s Got Talent - Nadir Doctor
- Performance Tuning Made Easy - Performance tuning is hard,
everyone knows that.
Attend this performance sequel show session for a fast track
to desired performance. It will discuss several tips,
techniques & tricks for a varied audience of developers,
dba's, architects, system administrators & managers and
provide an excellent guide to obtaining optimal performance.
Leave this session knowing what actions to take when you get
back to work on Monday.
Objective 1: Focus on system performance
Objective 2: Focus on application performance
Objective 3: Focus on database performance
Objective 4: Focus on writing efficient sql
Objective 5: Provide an A-to-Z checklist for an overall IDS
Health Check
Back to Top Performance Monitoring using Health Advisor OAT Plugin - Darin Tracy
- Using the Health Advisor Oat Plugin to monitor and improve performance for the Informix Dynamic Server.
Back to Top Performance Tuning and Indexes, Understanding BTSCANNER - Mark Jamison
- This presentation will discuss in detail how the BTREE Scanner works, how it
impacts performance, how to tune it for performance, as well as what additional
components are Driven by btscanner (like Index compression and Index
cleaning modes).
Back to Top Performance Tuning with SQL Shared Memory caches. - Mark Jamison
- This session introduces you to the SQL Shared Memory caches. Focusing on
Data Dictionary, Data Distribution and UDR caches. You will learn what they do,
how they work, How they impact performance and good methods to estimate
the right settings.
Back to Top PHP and Informix - Jacques Roy
- This session introduces PHP and its use in the marketplace.
It then continues to cover the different ways it can be used to access Informix and provides examples of how it is coded.
After this session, participants should be able to quickly create a PHP program that accesses Informix.
Back to Top Preparing your UDT for ER - Madison Pruet, Davis Kwong
- User Defined Types are an excellent way to add new functionality to your database. But UDTs require a bit of preparation in order to replicate between servers. This talk will describe what must be done to your UDT in order for ER to successfully replicate that UDT.
Back to Top Put your storage on a diet. - Scott Lashley
- Get the skinny on upcoming Informix compression technology for blobs and indexes. Includes discussion on performance impacts of using compression.
Back to Top Querix - Modernizing your 4GL application using Lycia - Hubert Hoelzl
- Lycia is a complete 4GL development solution giving you all the necessary tools for your daily development tasks. We will be illustrating some of the most common task of modernizing a 4GL application using Lycia.
- Utilizing extended 4GL functions and methods to control the graphical user interface
- Running your applications with Desktop and Web clients
- Debugging your application using the interactive graphical debugger
- Creating a graphical XML form using the LyciaFormDesigner
- Consuming and providing Web Services
- Designing an application theme using the LyciaThemeDesigner
- Generating a graphical business report using LyciaBI
Back to Top Query rewrite performance for Views and Derived Tables - Ajay Gupta, Keshav Murthy
- When you have large tables and ANSI joins inside Views or
Derived tables, IDS will perform Query rewrite to provide
maximum performance benefits. Learn various techniques in
query rewrite area. This presentation will provide examples
and sqexplain information in different customer environment.
Back to Top RESTful Genero applications - Mark Rees
- 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.
Back to Top Rolling Upgrade of IBM Informix Server - Keshava Murthy, Sapna Ramesh
- MERGE SESSIONS 126 262 Abstract: Informix 11.7 supports "rolling upgrade," a method of upgrading a running instance in a cluster with zero application downtime. This presentation will discuss IBM experience upgrading the 50 GB "ATM" database, used by Informix Development and QA to store the test data for Informix Server for almost a decade. A rolling upgrade uses several features of Informix Flexible Grid.
Back to Top SDS architecture and testing scenarios in the real world - Sun Guo Rong
- In China, Informix HDR has supported many 24*7 banking applications for years. Now, Informix SDS is challenged and demanded to provide near 100% high availability and scalability. In this session£¬ we will present a real world SDS architecture and 15 testing scenarios. These scenarios simulate possible man-made and/or hardware failure by unplugging network cable, unexpectedly killing server daemon process and connection managers, etc. Some scenarios are listed below.
1.1st SDS server shutdown normally, 2nd SDS server switch to Primary, 1st server recover..
2.1st server shutdown abnormally, 2nd SDS server switch to Primary, 1st server recover..
3.2nd SDS server shutdown abnormally, 2nd SDS server recover..
4...
With 1700 session simulations, we demonstrate how our SDS architecture behaves, response, and shifts primary role from one server to another within 45 seconds flawlessly to achieve near 100% high availability.
Back to Top SDS exploration, limitations, and demo - Sun Guo Rong
- During the severe SDS testing simulation, we have identified 2 SDS limitations which are read-delay and not-supported Select-for-Update features at 2nd SDS server. In this session, we demonstrate our research work in how we explore the SDS internal work, why it prefers the higher read/write ratio. We also demonstrate the limitations by real cases with different read isolations. Under different read isolation, we prove some limitation are irrelevant, some limitation is ignorable.
1.How SDS redo simple transaction and complex transaction with log at 2nd SDS server
2.Read-delay at 2nd SDS server and scenarios
3.Read-delay with long transaction
4.Select-for-Update and RETAINUPDATELOCKS
..
With our experimental findings, you will recognize that SDS is best simple database cluster technology available by comparing other expensive and complex technology. When you implement your SDS deployment, you know exactly how to take advantage of it strength and avoid its limitations.
Back to Top Seamless Installation and Deployment of Informix software - Sudhir Katke
- Installation via GUI, command line, RPM or Response files
Back to Top Software-as-a-Service with the Genero PaaS - Stephen Sykes
- 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.
Back to Top Support of Case Insensitivity in IDS - Ajay Gupta, Neeraj Kapoor
- MERGE SESSIONS 215 227 234 When you query your data, you may wish your query to be
case-sensitive, or you may wish to ignore upper and
lower-case differences in data. In the past, IBM Informix
databases were case-sensitive, and it required some
effort to perform a case-insensitive search. Now with the
latest release, Informix supports case-insensitive
databases. This presentation will highlight on how to create
a case-insensitive database and explore considerations for
implementing check/unique constraints, using distinct
searches, using group-by aggregate queries, implementing
distributed queries, and more, in a case-insensitive
database environment.
Back to Top Troubleshooting and tuning Informix I/O performance. - Vijay Lolabattu
- Often times database I/O can be a bottleneck in application performance. This presentation will help identify where those bottlenecks are and how to overcome the problem. This presentation will show how to narrow down the I/O related problems to specific databases/tables/sessions/physical log/logical log etc.. What tools(onstats, SQL, OAT) you can use to troubleshoot and how? What configuration parameters affect the I/O and how to fine tune.
Back to Top Tuning Data Warehouse for High Performance in Informix - Alex Cheng
- One of the big myths, if not the biggest one, about Informix is that it is only good for OLTP. The purpose of this session is to bust the myth and share with you the tuning techniques to achieve high performance in the business intelligence/data warehouse (BI/DW) environment using Informix. This session is a case study of tuning work that achieved a 12-fold performance improvement in the worst-performing BI query and substantial performance gains in overall BI/DW environment using Parallel Database Query (PDQ) and partitioned indexes.
The session will cover the details in the following areas: 1) how a set of configuration parameters are changed for PDQ and how PDQ is used for each user session; 2) how other configuration parameters are changed for the non-PDQ queries since not all queries in the BI/DW environment can or should use PDQ; 3) how to get peak performance from the tables joined in a star schema.
Back to Top UI Design Concepts for Genero Applications - Shannon Wallner
- 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.
Back to Top Update on Informix and Open Source - Jacques Roy
- This presentation gives an update of the activities that occurred related to Open source and Informix over the last year.
Back to Top Update Statistics and related FAQ's from 11.70 - Hyun-Ju Vega
- Since 11.10, there has been continuous improvements to the Update Statistics commands, as well as improvements to the way table and index statistics are collected. In 11.70, the new "smarter statistics", fragment-level statistics, and update statistics low performance improvement features were introduced. This presentation is a Quick Summary Guide of the new landscape of update statistics and query plans in 11.70, based on questions asked by customers. For example, if you are upgrading, you may be wondering what changes need to be made in monitoring. For upgraded, new, and existing 11.70 instances, you may be wondering how best to make sure update statistics is run efficiently, taking advantage of the new features and improvements.
Back to Top Using Informix dynamic server compatibility features - Paul-John To
- MERGE SESSIONS 145 245 Over the years Informix server have been supporting many compatibility features which will help the customers move from other database vendors to IBM Informix database servers. In recent years , we have seen support of many such features. The presentation will cover explanation and best usage practices of compatibility features like Sequences , MERGE INTO , CONNECT BY , built-in functions like RADIANS() , SUBSTRING_INDEX() , XPS API functions , star join optimization etc.
Back to Top Using Cognos Dashboard and Widgets with Informix" - Keshava Murthy
- Show how easily Cognos dashboards can be built by dragging and dropping of Cognos Widgets with full support on Informix. Real-life customer example and demo will be shown"
Back to Top Using Predictive Analytics With Informix - Priya Govindarajan
- IBM SPSS and other vendors, e.g. Pentaho, provides a set of data and predictive analytic tools for business users, analysts and statistical programmers. This presentation will see how predictive analytics and visualization tools can be used. A demo will include application of predictive analytic tools on a sample dataset for Informix Warehouse Accelerator.
Back to Top Using SSL to encrypt Database Network traffic. - Mark Jamison
- This presentation will discuss the benefits of Using SSL, and how to implement
SSL communication for Informix. Session will also include a brief tutorial on how
to implement SSL protocol with self signed certificates.
Back to Top Using XML capability in Informix dynamic server - Paul-John To
- Informix dynamic server has been XML capable database for few years. This presentation will explain the XML functionality of IDS and how best it can be used in the application world. Main topics to discuss will be , XML publishing , XPATH evaluation functions , XSL transformation functions etc. There is good amount of customer base which use the XML functionality from few years and continue to do so in future. The XML functionality is fully supported in some of the key platforms like Linux , Solaris , HP , HP Itanium , AIX, Windows 32 bit.
Back to Top WebData Blade - Paul Watson
- The Web Datablade ships with the engine and is the easiest and
simplest way to generate database driven web applications.
This presentation will cover the installation and
configuration and show how simple table maintenance pages can
be written in a couple of minutes.
Back to Top What's inside Informix shared memory - Vijay Lolabattu
- This presentation will give an in-depth understanding of Informix shared memory(Resident, Virtual, message) components. Will provide details and different types of bufferpools. How memory allocation happens for sessions and how it grows. What onconfig parameters control the shared memory. What onstat commands can be used to monitor shared memory. Internal tables and thread specific memory information. How stacks are allocated and how stack size can be controlled.
Back to Top What's new in Genero 2.40? - Laurent Galais
- 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.
Back to Top What's new in IDS Indexing? - Mark Jamison
- MERGE SESSIONS 105 266 Learn about the new index types in IDS, including Forest of Trees and partial column index. Some new index controls are also enabled including extent size manipulation, and create if not exists.
Focus will be on new features related to Indexing in IDS, including Forest of Trees and partial column index and the new controls on index properties like extent size.
Back to Top What's new in Optim 8.1 release? - Mukta Singh
- IBM Optim is an enterprise data management product that addresses critical business issues, such as Data Growth Management, Data Privacy Compliance, Test Data Management,
migrations and retirements.
This session would cover all the new innovations/enhancements has been part of latest and greatest release of Optim 8.1 version. Many new enhancements particularly for Informix has been implemented in Optim. Ranging for new data types support to Unicode and MBCS code pages support etc. This session will cover key changes done in Optim Archival solution to get even more benefits on storage savings. New Audit capabilities added to track who is doing what and when! One of the latest innovations to create XML, ECM (Enterprise Content Management) and CSV file formats to convert your production data and masked the same. Did you know that now Optim has set of APIs which could be called from any applications for data masking? All these and many more would be discussed!
Back to Top Writing C-UDR (User Defined Routine) the basic - John Miller III
- Want to write a C-UDR but not sure where to start? Want to write highly efficient procedures in the database engine?
This presentation will focus on the basic of writing C-UDRs. Example will be given along with the do's and don't of writing C-UDRs. This includes an example of a datetime data type which automatically adjusts for timezones.
Back to Top
Alternate Technical Sessions
Best of OAT - Erika Von Bargen
- What are the best features in OAT? Which are the most popular? Which give the most "bang-for-the-buck" vis-a-vis the command line? What are OAT's best kept secrets, i.e. the best features that aren't well known or are underutilized? Join this session to find out and to learn how to get the most out of OpenAdmin Tool for Informix.
Back to Top Walking down the Informix Technology Reminiscences of 1990's - Bharat Gera
- Golden Eye released in mid nineties was the decade that unequivocally also
witnessed the most powerful, sophisticated database engine of Informix Server
emerge. The presentation walks the memory lanes of Informix basics and
advanced
concepts; that help users and administrators to maintain and tune Informix. The
coverage includes:
- Initialization, Design rules, environment variables and files
- Initializing the database specific engine, specific steps and parameters
- Building the database environment; how to fragment tables, partition indexes
and use other advanced features
- Archiving and restoring databases as well as individual tables. To cover the
new PSM Storage Manager (if released by then )
- Monitoring database instances
- Step by Step Crash recovery techniques
- Enhancing Performance; query optimizer, virtual processors, parallel data
query etc.
Back to Top
Hands-On Labs
Analysis of Implementing Storage Compression in an Embedded Enterprise Replication Environment - Scott Lashley
- 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.
Back to Top Crash course on Enterprise Replication - Vijay Lolabattu
- This presentation will give you introductory information on
Informix Enterprise replication. Quick architectural overview
on how ER works(source/target/replication queues etc.)? How
to setup and ER and start replicating. ER related
configuration parameters. Onstats to monitor ER.
Back to Top Hands-On Lab for On-line Data Migration from native codeset to UTF8 for 24/7 business - Paul-John To, Brian Cahill
- 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.
Back to Top How to Speed up Data Warehousing with Informix Warehouse Accelerator - Andreas Weininger, Sandor Szabo
- The lab gives an overview of the Informix Warehouse Accelerator (IWA). It shows how to set up IWA in a cluster and in a non-cluster environment, and how to speed up queries with IWA. Best practices derived from several POC's with IWA will be given to allow participant to get the best performance out of their IWA.
Back to Top Informix Warehouse Accelerator - Installation and Setup - Sudhir Katke
- 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
Back to Top Installation and Configuration of Optim for Informix - Optim in action! - Peter Costigan
- 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!
Back to Top Limber Up: Flexible Grid for the Stiff - Nicholas Geib
- You’ve used Informix for years, no decades. You’re a master. What about all that replication technology? Well you’re 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.
Back to Top Security Best Practices and Guardium Demo - Mark Jamison
- Written on Site.
Back to Top Test Drive some of the notable new Informix 11.70 features - Rakesh Naik
- 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.
Back to Top The Beauty of Informix Disk Structures - Andreas Legner
- 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.
(Haven't discussed yet internally how far we can go here, so the above might be subject to restrictions imposed.)
Back to Top TimeSeries Data Type: Know It Better - Pradeep Natarajan
- In this hands-on lab, you gain firsthand experience in using the Informix TimeSeries server extension to enhance and manage huge quantities of time stamped stream data to get maximum performance and storage saving compared to other competitor database. This technology forms the heard of the smart metering solution offered by IBM-Informix.
Back to Top
Tutorials
Achieving Blazing speed with the Informix Database Engine - John Miller III, Scott Lashley
- This presentation will focus on how to improve you database performance. We will examine a few main areas which will give the student detailed knowledge about Informix Server. These include the how to improve the efficiency of your network, getting more bandwidth for less, improving the response time of connections, when and how to utilize fragmentation/partition to improve response times of queries especially on large tales, indexing and how you can improve the efficiency of indexes and the btree scanner. Lastly how to utilize the new performance features in Informix to increase performance for less work.
Back to Top Certification Preparation – Informix 11.70 System Administrator - Sanjit Chakraborty
- Are you considering taking Informix certification exams? Good for you! Upgrading your skills and earning industry wide recognition for it through certification is an excellent way to move your career forward.
The Informix Certification tutorial is the fastest way to prepare for the Informix Certification programs. Attend this class for everything you want to know about the Informix certification programs. This class will cover: Exam Preparation Strategies, Preparation Resource, Exam score structure, Taking Certification Exam, Recommended Skills, Exam Contents etc.
Back to Top Data Warehousing with Informix - Andreas Weininger
- This tutorial gives an overview of the data warehousing functionality provided now with Informix 11.70. But it will also give a detailed explanation how features like skip scan, multi-index scan, or push-down hash semi-joins work, and how they can be used to improve performance not only of the queries in your data warehouse, but also of your ETL/ELT processing. It shows best practices like which fragmentation strategy to use in which situation, when and which indexes to use, how to use external tables or how to use Informix Warehouse Accelerator. Also topics are discussed like why and how to use set-based SQL instead cursor-based programs, and how to convert cursor-based programs to set-based SQL statements.
Back to Top Discovering and using Informix TimeSeries - Carlton Doe
- You've been hearing about TimeSeries for a while. It's part
of the IBM Smarter Planet but what is it and what does it take
to use it? This session will give you hands-on experience
with this exciting technology.
Back to Top Hands-on with Informix Warehouse Accelerator - Carlton Doe
- Informix has been adding functionality to its Data Warehousing
capability. Informix Warehouse Accelerator enables customers
to get results to analytical queries hundreds to thousands of
times faster. This lab will give you an introduction to, and
some hands-on experience with this new and exciting
technology.
Back to Top HELP!!! I need an Informix Disaster Recovery plan! - Rakesh Naik
- Don't have an Informix Disaster Recovery (DR) plan or not sure if your DR plan is adequate? Want to experiment with Informix DR strategies? This tutorial will first walk you through the different tools, utilities, and features you can use to develop a DR strategy within Informix, including ontape, onbar, archecker, external, load/unload, mirroring, and HDR. You will then understand the pros and cons of various DR strategies. It will then be time for you to exercise Informix DR operations as a result of various failure situations - including performing DR due to instance, dbspace, and Primary server failures, recovering dropped tables, using mirrored disks to restore down dbspaces, and recovering using external backups. While conducting these experiments, you will also learn how to monitor the DR operations (data transfers, threads, servers, etc) for troubleshooting and tuning purposes. Discussions about the efficiency your DR strategy and/or plans will also be welcome throughout.
Back to Top Holistic Problem Solving with IBM Technical Support and You : Part 1 and 2 - Mark Jamison, Darin Tracy, Hyun-Ju Vega
- Holistic Problem Solving: Learning to identify root cause of
performance issues
In the evolving global economy, businesses are putting a
greater premium in fixing issues the first time. This
special session is designed to help you think about solving
performance issues and other problems from a Holistic or
whole system concept. We will go through several common
scenarios and the best approach to isolating and identifying
the root cause. Scenarios will include,
• Abnormally slow backups and restores
• Security related issues
• Client side issues and of course the dreaded "The box is
slow"
Back to Top Using tools to monitor and tune Informix. - Art Kagel
- Long time Informix user Art Kagel will explore monitoring and tuning a running Informix instance while it processes a version of last year's Fastest DBA Contest multi-user OLTP benchmark session. Attendees will learn what to look at and what to look for and how existing tools can help us do our jobs better and more easily.
Back to Top Windows ActiveDirectory Single-Sign-On and LDAP with IDS on Unix - Andreas Legner
- I'd present setting up an IDS (on AIX) SSO (Kerberos) setup from scratch or into an existing Windows domain, with bits and pieces that are to be considered or can be incurred.
Topics:
- the SSO / Kerberos idea and architecture
- Windows AD as a KDC and LDAP server for Unix hosts and services
- IDS using LDAP, SSO and their combination
- typical problems
Back to Top