Informix Best Practice - Informix Query Performance Tuning Basics by Mike Walker
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
Informix Best Practices - Using the Sysmaster database to perform an Informix Server Heath Check by Lester Knutsen
This is the latest Webcast replay of Lester's talk on Exploring the Sysmaster database. He presented cripts to monitor and tune your Informix Server and perform a system health check. Examples include how to tell what is the most expensive query running on your server now, what page size is best for your tables, what indexes are used and not used, how is memory used on your server, and much more.... These scripts will help you identify the performance bottlenecks on your Informix Server.
Informix Best Practices - Running Informix in a Virtual Machine by Lester Knutsen
This is a replay of our Webcast on August 31, 2017 on Running Informix in a Virtual Machine by Lester Knutsen. Virtual Machines have many advantages and disadvantages. This Webcast will explore the best practices for running Informix in a Virtual Machine. We will look at small and large databases in virtual machines. A monster virtual machine is a VM with lots of memory, CPUs and disks. I have had the opportunity to performance tune many Informix database servers running in a virtual environment and will share some of the problems and solutions for Informix to work well in VM. We will talk about everything from a VM on my laptop to a VM with more than 256 GB of memory and more than 96 Virtual CPUs.
Informix Best Practices Webcast on Informix Connection Manager by Thomas Beebe
This is a replay of our Webcast on June 28, 2017 on the Informix Connection Manager by Tom Beebe. Tom discusses how to setup and use the connection manger to provide fail-over and capability to your database servers.
New Informix Toys and Tools - NoSQL, Mongodb Support, Data Streams with Node-RED and new useful features and utilities by Tom Beebe
This is a replay of Tom Beebe's Webcast on December 15th, 2015. With the emergence of 'Internet of Things' (IoT) we are all collecting more data than ever. Every company wants to get as much data as possible and have it available for use as even faster. With this new mentality of getting data there quickly, new methods of application development have become common. With the focus squarely on the application it has changed how the database sits in the corporate structure. Informix has grown and changed to meet the changing needs of the data economy. In this talk we will be covering a number of the new features that Informix has introduced in the last several years to meet the era of Big Data. We also are going to talk about several complimentary utilities that work hand in hand with Informix to better manage and make sense of the volumes of new data coming in. We will explain what NoSQL is and why you should care about a new method to store and manage data. Also we will talk about the new REST and Mongo listeners and show how that is changing the face of how we can access our Informix data. Join us for this look over some of the new facets of the changing Informix landscape.
Informix 4GL to Genero - Bring your code into the future by Lester Knutsen
Lester takes an Informix 4GL application written in 1993, called DBPrivileges, and guides you through the process of converting it into a modern application that can be run on Windows, Mac, iPad, Mobile or on the Web.
The basics of getting up and running with Informix (IoT) by Tom Beebe
This final webcast of the series will focus on installing and setting up Informix. Intended mainly for new adopters of the IBM Informix database product,
Tom will demonstrate how this advanced and powerful database engine is simple to install and configure on just about any hardware.
Running an Informix Database Server on an ARM Computer by Tom Beebe
This webcast will explore some of the ARM-based computers that are available, and describe why ARM is such a good fit for an IoT solution. Tom will show how simple it is to install a full version of the IBM Informix database server on a low-power, affordable ARM-based Linux computer, and why the power and simplicity of Informix makes it ideal for an embedded IoT gateway.
Using Informix TimeSeries and the Internet of Things by Mike Walker
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.
Introduction to Informix and the Internet of Things by Mike Walker
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.
Informix Performance Tuning using the Sysmaster Database (Updated) by Lester Knutsen
This is a replay of Lester Knutsens Webcast on March 24, 2015. Lester presented new scripts to monitor and tune your Informix Database server using the Sysmaster and Sysadmin Databases. This is major update to Lester's most popular talk at the Informix user conferences over the past several years, "Exploring the Sysmaster Database".
Best Practices for Informix Developers by Art Kagel
This is a replay of Art Kagels Webcast on February 17, 2015. Art Kagel, is an Independent consultant and IIUG Board Member, presented on programming, concurrency, and tuning applications against Informix. This is an update to the presentation Art did at our last Washington Area Informix User Group Meeting. (Note: there are a few problems with the sound, I tried to fix it as best as I could)
How to Secure your Data - Informix Column Encryption and Security by Lester Knutsen
Do you have an Informix database and need to encrypt columns with privacy information? Do you have time to change all of your production applications to implement encryption? Have you had a security or FISMA/DISA audit? Lester Knutsen will present how we have converted existing Informix databases to add column level encryption with minimal impact to your existing applications. He will demonstrate how to take an Informix database and change it to use encrypted columns with little impact to your front end applications using triggers, functions and Informix encryption. Lester will also discuss simplifying access using roles to grant and revoke privileges.
Learning about Informix and the Open Admin Tool (OAT) By Thomas Beebe
The Open Admin Tool (OAT) is one of the most exciting and least talked about new features for Informix in the past few years. It is an open platform to manage your Informix instances through a convenient web interface. In this talk we will be breaking down how to get up and running with OAT and covering many of the basic tasks you can perform in it. Since version 11 was released many people have migrated up to it, however most of them have either not gotten OAT up at all or looked at it briefly and put it back down. Listen to the webcast and we will tell you why you want to go to the latest release of OAT and why you should be using it every day. Some of the highlights:
Get step by step instructions to getting it running on a variety of operating systems
Learn about monitoring replicated environments using your web browser
See different ways to get very easy to read visual guides to the health of your database
Learn how to safely give your Jr DBA the ability to add new space without having to worry every time he does
See how to browse your database without needing to use dbaccess or SQL
Find out how to easily get reports that you can give to management showing how much Informix is racing along
New Informix Warehouse Accelerator 12.10 Benchmarks Webcast
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.
Fastest Informix DBA Contest 2013 Status Update Webcast
This is a replay of our Fastest Informix DBA Contest 2013 status update Webcast on August 20, 2013. This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate
from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job
and generate the most bills in a 10 minute run. For more information on the Fastest Informix
DBA Contest click
Fastest Informix DBA Contest 2009 Results Webcast - How did they do it?
This is a replay from our Webcast in 2009 reviewing the results of our Fastest Informix DBA Contest. Congratulations to Tatiana Saltykova, New 1st place finisher in the Fastest Informix DBA contest.
The challenge was to take a batch SQL job that took over 40 hours to run and optimize it and the Informix database configuration.
Fastest Informix DBA Contest July, 2013 Webcast to kick-off the contest
This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will
be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run. For more information on the Fastest Informix
DBA Contest click
Informix Performance Tuning using the Sysmaster Database by Lester Knutsen
Webcast Date - Tuesday, April 30, 2013 at 2:00 pm,EST
Lester presentednt new scripts to monitor and tune your Informix Database server using the Sysmaster and Sysadmin Database. This is based on Lester's most popular talk at Informix
user conferences over the past several years, "Exploring the Sysmaster Database". We will show what is new with Informix 12.10.
Database Driven Websites - Using PHP with Informix by Thomas Beebe, Advanced DataTools Corporation
Webcast Date - Tuesday, February 12, 2013 at 2:00 pm, EST
What do Wikipedia, Facebook, Wordpress, and Yahoo all have in common? They all run on PHP. PHP is an open source server-side scripting language designed for Web development
to produce dynamic Web pages. And it works great with the fastest database, Informix. In this talk we will be discussing how quick and easy it is get going in PHP and how to
set up PHP to talk to Informix using the PDO driver library. You can easily use PHP to select, insert, update and delete data from an Informix database to create a database driven web site.
Fastest Informix DBA Contest 2012 Webcast - How did they do it?
Webcast Date - June 19th at 2:00pm EST
On Jun 19, 2012, we held a Webcast with the Fastest Informix DBA Winner Andrew Ford, hosted by Lester Knutsen and Art Kagel, to share with other
Informix users how the winners achieved their results. Learn about the tips and tricks the real Fastest Informix DBAs used to achieve their remarkable performance.