Advanced DataTools Newsletter – January 2021

Happy New Year and Best Wishes for 2021! 1. Announcement from Advanced DataTools and XDB Systems, Inc on Informix Support and Consulting Advanced DataTools is excited to announce that Thomas Beebe and Mike Walker have formed XDB Systems, Inc. and acquired the customers, contracts, DBA support agreements, service agreements, and customer obligations from Advanced DataTools. […]

Advanced DataTools Newsletter – October 2020

1. Are you planning to upgrade to Informix 14.10?  Attend our Informix for Database Administrators Training Course. We have the Informix 14.10 training for you. Lester Knutsen will be teaching our next Informix DBA Class, Informix for Database Administrators updated for Informix version 14.10, on October 5-8, 2020. There is only one space left! More […]

How do you use the command-line utilities to manage and monitor an Informix Server? We will discuss onstat, oncheck, and the new InformixHQ to manage your server.


How do you build databases and tables in Informix? We will discuss best practices for creating and managing databases and tables, partitioning, and database security. We will demonstrate object-oriented data types, using SQL to generate SQL Scripts and creating a Non-OS user for Informix database security.


How do you connect users and tools to an Informix Server from Windows, Unix, and the Web? We will discuss connections using Microsoft ODBC, Informix SDK, Java, PHP, DRDA, and other options. This is a Webcast reply from June 25, 2020.


Advanced DataTools Newsletter – July 2020

1. Advanced Informix Performance Tuning – July 13-16, 2020 by Lester Knutsen and Art Kagel Are you ready to take your DBA Skills to the next level? This course is for database administrators and application developers who will be responsible for managing, optimizing, and tuning an Informix database server. The focus is on skills, procedures, […]

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.


How do you configure and maintain Informix Logs? The logs are critical to database reliability, and we will discuss best practices for managing and configuring Informix logical logs. We will also cover the backup and recovery of logical logs.


Advanced DataTools Newsletter – April 2020

Our Remote Informix DBA Support is Uninterrupted Advanced DataTools operations are uninterrupted by COVID-19 and we continue to support our customers in these difficult times. All our senior Informix DBAs are effectively working remotely and maintain the high standard of support to which we are committed. Our Informix DBA consultants are working and supporting our […]

Informix Tutorial – Managing Informix Disk Space

Disk IO is often the performance bottleneck for databases, every transaction needs to get written safely to disk fast. How do you set up and configure the disk space for an Informix Server? What disk and RAID configurations provide the best performance and reliability?

Disk IO is often the performance bottleneck for databases, every transaction needs to get written safely to disk fast. How do you set up and configure the disk space for an Informix Server? What disk and RAID configurations provide the best performance and reliability?


Informix Tutorials – Configuring a New Informix Server

Informix Tutorials Webcast Replay – Informix Tutorial – Configuring a New Informix Server by Lester Knutsen, February 27, 2020.

How to script configuring an Informix Server? This Webcast will cover everything you need to know to build with scripts, a new medium, or large server. The Webcast will be a review of the Informix ONCONFIG file and configuring memory, CPUs, Network, and Disk for a more extensive Informix Server configuration.

Informix Tutorials Webcast Replay - Informix Tutorial - Configuring a New Informix Server by Lester Knutsen, February 27, 2020. How to script configuring an Informix Server? This Webcast will cover everything you need to know to build with scripts, a new medium, or large server. The Webcast will be a review of the Informix ONCONFIG file and configuring memory, CPUs, Network, and Disk for a more extensive Informix Server configuration.


Informix Tutorials – Getting Started with Informix

Informix Tutorials Webcast Replay – Getting Started with Informix by Lester Knutsen on Thursday, January 30, 2020. The Webcast is a step by step guide to installing and getting up and running a basic Informix Server. We will demonstrate using InformixHQ, the IBM Informix Knowledge Center, and how to find resources to get started with Informix.

Informix Tutorials Webcast Replay - Getting Started with Informix by Lester Knutsen on Thursday, January 30, 2020, The Webcast is a step by step guide to installing and getting up and running a basic Informix Server. We will demonstrate using InformixHQ, the IBM Informix Knowledge Center, and how to find resources to get started with Informix.