The second part of this webcast will further examine the Informix utilities which can be used to migrate data to a new system, and how to combine different utilities to speed up migrations and minimize downtime.

Migrating your Informix databases to new hardware and operating systems can be a daunting task. During this webcast, we will look at some of the challenges involved, and things to consider when migrating. We will look at the various tools available in Informix which can be used to unload and load data and cover the use of dbexport and dbimport.

An overview of using Informix External Tables for unloading and loading data and the benefits that they offer.

This session will cover some of the basics of Informix Tuning, with a focus on monitoring and tuning of queries. Some of the areas that will be covered include: Identifying long running queries, Explain plans, Optimizer directives, Monitoring the buffer pool usage, Checking statistics, and Finding busy tables

Mike discusses how to setup and use Informix auditing to monitor the usage of your database servers.

This webcast will describe Informix TimeSeries, why it is such a good fit for an IoT solution, and show how it can be used to efficiently store sensor data. Examples of querying TimeSeries data will be shown and then displayed on a web page served from a Beaglebone ARM computer. The sensor data will be pushed out to a cloud, and an example will be shown using APIs to retrieve the data and display it.

This is the first webcast in our series and will introduce Informix and the Internet of Things and give an overview of the different components. It will include a practical demonstration of data from sensors being stored on a Beaglebone Black ARM computer and pushed to the cloud. This webcast will show how simple sensor data can be read using an Arduino-based microcontroller and conclude with the data being received on the Beaglebone gateway.

This Webcast will demo and benchmark the Informix Warehouse Accelerator 12.10. Last year we showed it running 9 hours of queries in 14 minutes. Mike Walker will demonstrate our current benchmarks with this exciting new database technology. He will demonstrate ad-hoc queries on a bookstore database with 250 million customers and over a billion records in the fact table.