Informix Webcast 2019 - Informix SQL Explain - Using the SQL Optimizer Query Explain Plan by Lester Knutsen
How does the Informix SQL Optimizer choose which index or table or access method to use when running your SQL? This presentation will focus on how to view and understand the SQL Explain plan to see how your SQL is executed. The SQL Explain plan will provide times for each step in your process.
Informix Webcast 2019 - Database Indexes - Best Practices for Informix DBAs by Lester Knutsen
This presentation will focus on Best Practices for Informix database indexes. Every table should have at least one index, and managing indexes is an integral part of a DBA's task and time. Indexing is one method to optimize the performance of a database by reducing the number of disk reads when a query is executed. An index is a structure which is used to locate and access a row in a database table quickly. Indexes are used to enforce uniqueness, primary, and foreign keys and constraints. Indexes can also be a source of problems in a database and may slow performance down when misused.
Informix Webcast 2019 - Managing Migrations With Informix ER by Thomas Beebe
TAt some point, every system gets outdated or starts showing its age. We all have had to deal with the headaches and logistical nightmares of moving our core databases from a legacy system on to a new server. In this webcast, we will cover different ways in which you can leverage Informix Enterprise Replication to move from an old server to a new one with minimal downtime, headache, and infrastructure needed. We will be covering cases of needing to handle the potential for fail backs, migrating between different OS platforms, as well as covering ideas to minimize end user interruption.
Informix Webcast 2019 - Informix Databases Migrations, Exports & Imports (Part 2) by Mike Walker
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.
Informix Webcast 2019 - Informix Databases Migrations, Exports & Imports (Part 1) by Mike Walker
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.
Informix Webcast 2019 - Installing and Upgrading to the New Informix version 14 and an introduction Informix HQ by Lester Knutsen
IBM just announced the exciting new Informix 14 version in March. Advanced DataTools taught our first course for Informix DBAs on release 14 in April. We have been part of the beta programs and would like to share our findings including how to use the new installer, how to upgrade a database and an introduction to the new Informix HQ server management.
Informix Webcast 2019 - Informix Client Server Encryption by Thomas Beebe
End to end security is becoming more critical every day. In this webcast, we will demonstrate step by step how to set up basic SSL encryption for the Informix engine and how to configure ODBC clients for Windows and Linux to make sure all of your data is secured in transit.
Informix Webcast 2019 - Informix OLAP and Advanced SQL Functions by Lester Knutsen
Informix includes many Advanced SQL OnLine Analytical Processing (OLAP) functions that are rarely used, and we will demonstrate how to take advantage of them. OLAP is Business Intelligence queries that allow users to perform reporting for sales, marketing, inventory control, business processes, and many other functions. Typically it would require a multi-dimensional database. SQL OLAP functions allow you to roll-up, roll-down and slice and dice your data. We will demonstrate examples of Window Partitioning of data (before and after group by), Ranking, using row numbers, and before and after rows using ANSI SQL-99 standards, known as the Elementary OLAP package.
Informix Webcast 2018 - Dostats and Informix Update Statistics by Art Kagel
Art Kagel developed and maintains the popular open source utility dostats to enable you to automate and keep up to date catalog statistics and data distribution that the Informix Optimizer needs in order to select the best method of running your SQL statements. He will describe how it works, how to compile it on several platforms, and why you should upgrade to the latest version. He will also discuss the Informix Automated Update Statistics (AUS) and how that compares to dostats.
Informix Webcast 2018 - Capturing Informix SQL Metrics with SQLTrace by Lester Knutsen
How do you capture the cost of SQL statements and activity on your database server. We will take a look at SQL Trace, and the Sysmaster tables that enable you to save and analyze the costs of your SQL.
Informix Webcast 2018 - Unloading and Loading data with Informix Best Practices by Jack Parker
Whether you are reorganizing a table, loading a table or doing a full data migration, you will want to use the unload/load capabilities of Informix. This is an in depth look at the various options available to you in such an endeavor as well as issues which should be taken into consideration.
Informix Webcast 2018 - Uninterruptible Informix Database transactions are here! by Art Kagel
Have you ever had a large batch job that had to be rerun from scratch when the primary server crashed after the job had been running for many hours? Wouldn't you like to have that job just continue running when your secondary server takes over? You can! This will be a live demonstration of how to configure your servers to take advantage of the Informix Transaction Survival feature.
Informix Webcast 2018 - Automatic Informix Range Interval Partitioning and Rolling Windows to Organize your data by Lester Knutsen
This presentedesentation will demonstrate how to take advantage of the automatic Range Interval Partitioning and Rolling Windows to fragment your huge Informix tables. Automatically adding new partitions and fragments by interval can replace elaborate fragmentation schemes easily. The feature includes the ability to automatically drop partitions of old data reducing the need to purge old data.
Informix Webcast 2018 - Optimizing the Operating System for the best Informix Database Performance by Lester Knutsen
The Informix database depends on the operating system for the CPU, Memory, Disk and Network resources. The presentation will focus on optimizing the Unix, AIX and Linux OS for the best database performance. We will review Kernel Settings, HugePages, enabling and disabling CPUs, OS disk scheduling, SAR and other tools for monitoring Unix and Linux.
Informix Webcast 2018 - Getting going with PSM and Informix 12 for backups by Thomas Beebe
For years Informix users who backup to local disks have been stuck with the limits of ontape or the tediousness and slowness of the Informix TSM system. Introduced in version 12 there is the brand new PSM system. Tom will cover the basics of getting started using it and may have you rethinking your backup strategies.
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.