Informix by default uses the Operating System (OS) to manage users. In this video, Lester Knutsen will demonstrate how to create a Non-OS Informix User that can access Informix databases without having an OS login. This is the first in a series of videos on Informix TechTalks by the IIUG. For more information on the International Informix Users Group (IIUG) please visit https://www.iiug.org


How do you backup and restore an Informix Server? High Availability is crucial to a successful database. We will cover and demonstrate database backups, restores, and setting up High Availability Data Replication (HDR). This replay includes additional material on HDR setup and switching between Primary and Secondary Servers that is not covered in the original webcast.


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


Lester Knutsen and Mike Walker will present a series of tools to monitor and tune your Informix Database Server. *Using SQL Trace to monitor user sessions *Tips for Remote DBA monitoring * Building a Monitoring Dashboard with Yellowfin BI


Art went through the steps one takes to determine the health of the server and start Informix Database Performance Tuning: * Overall Performance * IO Performance * Tablespace Performance * Memory Performance * Virtual Processor Performance * OS Performance * Caches


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.