Informix configuration settings are stored in $INFORMIXDIR/etc/$ONCONFIG. When checking to see an individual setting, an alternative to viewing the entire file is to run “onstat -c”. This shows the contents of the onconfig file. Using this onstat with grep allows you to easily and quickly see the value of a onconfig setting. For example, to […]
As networks have gotten more complex and networked systems have become more advanced it has greatly enhanced the need for security in your systems. Even if only doing internal connections, many auditors and security policies now require information to be encrypted end-to-end. While there are a number of ways to accomplish this for Informix, there […]
Adding space to a dbspace used to involve adding a new chunk each time. If your Informix instance uses cooked files for storage, then the underlying file on the filesystem can be expanded to a larger size, preventing the need to add a new chunk. Extendable chunks are often considered part of automatic space management, […]
Lester Knutsen had the honor to be on the IBM Champions Chat: Meet the Lifetime IBM Champions. See the replay on on YouTube at – https://youtu.be/4ZB9N08mRmQ
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 […]
Back in the older days of UNIX systems most sites used SysV to manage all the start and stop scripts from /etc/init.d. Newer versions of Linux have switched over to systemd for managing services as well as to handle logging. The systemctl command controls the services, while journalctl gives you access to the current system […]
Lester Knutsen was honored to receive the IBM Champion – Lifetime Achievement Award from IBM on September 1, 2020. View his verified achievement from IBM. IBM Champion – Lifetime Achievement Certificate for Lester Knutsen
Lester Knutsen’s Interview on Informix for G2 The following is a link to an interview Lester Knutsen did on June 17, 2020, on why Informix is my best database! https://www.g2.com/products/ibm-informix/reviews/ibm-informix-review-3266329
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, […]
IBM User Group DayPresentation
Migrating and Upgrading to Informix 14 or the cloud. The easy and the hard way.
There are several easy procedures to upgrade and migrate Informix. We will look at the easy way (in-place upgrades, dbexport, cdr migrate, backup/restore), but sometimes they may not work for you, and you need to create a custom process. We will go over a set of procedures and scripts using HPL, external tables, and parallel unloads/loads that I have used over the last few years to migrate from small systems up through terabyte-sized databases to VMs, new hardware, and the cloud.
configure and maintain Informix Logs
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 […]
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 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 – 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.
21 Years of Great Work Arman Prescott started with Advanced DataTools in January 1999 and was our first Senior Database Consultant to move to Denver. He has supported our projects with the Bureau of Land Management in developing and supporting the Collections and Billing System, which manages over a billion dollars in revenue for over […]
Happy New Year from the Informix Champions at Advanced DataTools, providing Informix Training, Consulting, Support, and Free Tech Information.
I have updated our series of Informix Command Line Utilities Quick Reference Guides. Folks, you can download the Informix 14 Quick Reference Guide here. The Quick Reference Guide includes the following Informix commands: Oncheck Oninit Onmode Onparams Onspaces Onstat Ontape In 1995, after years of trying to find a manual to check the command line […]
Informix 11.70 versions reach end of support in 2020. Is your organization ready to make the change? Informix 14.10 brings in a wide number of new features and options and an entirely new installation method. Contact the experts at Advanced DataTools to help you plan, coordinate, and execute an upgrade plan to get you on […]
These are my latest Sysmaster Scripts from my presentation at the Informix IIUG World Conference in 2019. Download presentation PDF: advancedatatools.com/…/Sysmaster_IIUG_Conf_2019_A12_LesterKnutse.pdf Download New Sysmaster 2019 Scripts (zip file): advancedatatools.com/…s/sysmaster2019.zip Download Past Sysmaster 2017 Scripts (zip file): advancedatatools.com/…s/sysmaster2017.zip
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.
Loading and Unloading with Informix Note, for simplicity these facilities will herein be referred to as ‘loaders’. This is not meant to be a definitive document defining everything there is to know about the subject. This is meant to be a starting point on your road to understanding this topic and a roadmap […]