Informix Administration Tips, Tricks and Tools Archives - Page 5 of 7

Makefile A Simple Informix ESQL-C

Abstract

If you’re building or fixing Informix ESQL-C applications then you’re almost guaranteed to come across the UNIX ‘make’ utility. This article describes Makefile, a simple Informix ESQL-C that can be adapted for many small projects.

[Read More…]

Makefile A Simple Informix ESQL-CJohn Baker2020-08-14T12:08:39+01:00

New Features in AGS Server Studio & Sentinel

Abstract

AGS Server Studio & Sentinel are the tools of choice for day-to-day Informix DBA tasks, SQL development and system monitoring. For those who have been using it as long as we have, it is worth recapping on some of the features added since our version 7 video demos at http://www.serverstudio.co.uk were created.

[Read More…]

New Features in AGS Server Studio & SentinelDoug Lawry2020-08-14T13:23:44+01:00

Understanding Informix Configurations

Abstract:

Understanding Informix configurations is key to get the most out of your Informix installations. With Informix versions 11.50, 11.70 and 12.10, IBM has introduced an array of new configuration parameters that support new advanced capabilities and provide increased flexibility and agility. With all of these versions, IBM has also introduced greater self-management capability meaning that the database server can more readily adapt to its environment and workload – the database server itself takes control over part of its run-time configuration. This article examines the fundamental configuration data we can expect to find on any Informix systems today and where we find it, to ultimately help you improve your understanding of Informix configurations.

[Read More…]

Understanding Informix ConfigurationsTristan Baron2020-08-14T13:22:54+01:00

Making Microsoft SQL Linked Server and Informix Standard engine work

Abstract

Microsoft SQL Server is a popular choice for consolidation of report data from multiple database products, as its Linked Server feature – which is included in the base product – makes it possible to access tables in heterogeneous databases within T-SQL via OLE DB or ODBC. However, the settings are not obvious that are required to make this work with Informix Standard Engine (SE) – the legacy version of Informix that uses C-ISAM to store tables (*.dat) and indexes (*.idx) in individual files (whereas Dynamic Server manages storage within its own “dbspaces”). This article reveals how to make Microsoft SQL Linked Server and Informix Standard Engine work together.

[Read More…]

Making Microsoft SQL Linked Server and Informix Standard engine workDoug Lawry2020-08-14T13:21:38+01:00

Bug in IDS 11+ sysadmin:alertcleanup function fix

Updated June 2020

Fixed in IDS 12.10.xC6 and 14.10: https://www.ibm.com/support/pages/apar/IT09329

Abstract

Bug in IDS 11: This article describes a bug in a function provided with IBM Informix Dynamic Server (IDS) which could result in disk space being filled. We have reported this to IBM who have assigned defect number (APAR) IT09329. Meanwhile, you can fix your system using code provided below.

[Read More…]

Bug in IDS 11+ sysadmin:alertcleanup function fixDoug Lawry2020-08-14T13:21:15+01:00

onsecurity – a little known IDS command

Abstract

Continuing the series of lesser known IDS commands lurking in the bin directory of your Informix installation directory, today we’re looking at onsecurity. It is very important to keep your database server and associated files secure; as well as keeping your data safe, later versions of IDS will refuse to start should the base ownership and permissions be too insecure. If your installation has been moved or copied, or other files or directories been added over time, IDS may not be running in the most secure environment. Shipped with IDS since version 11.50.FC4, the onsecurity utility can check a given directory path is secure, report on any issues found, and can even generate a script to remedy the situation.

[Read More…]

onsecurity – a little known IDS commandScott O'Rourke2020-08-14T12:49:18+01:00

Automatic management of range interval tables

Abstract

Range interval tables can save disk space. If for instance, you wish to keep just a week’s worth of transactions, in order to save disk space perhaps, then it is quite straightforward to use a range interval fragmented table, and whenever you wish you can almost instantly purge any unwanted data by using the DROP or DETACH clause in the ALTER FRAGMENT statement. In any release prior to v12.10 this would have to done manually, as it were (albeit via a cron job perhaps), but now it can be managed entirely by the instance with the ‘rolling window’ functionality, as described in this article.

[Read More…]

Automatic management of range interval tablesPhil Rule2020-08-18T15:25:45+01:00

Onclean – a little known IDS command

Abstract

In this series of articles we are exploring some of the lesser known, but still useful, commands hidden away in your Informix bin directory. The article explores the onclean utility. It’s often necessary to run more than one database instance on a single server. While this is a useful feature and quite easy to do with IDS, when things go wrong, it’s not always straightforward to tie each oninit binary back to a particular instance, and killing the wrong binary or shared memory segment can be disastrous. Since IDS 11, the onclean utility has been bundled with the server; this useful little program can help take some of the pain out of cleaning up an instance that has not shut down properly, killing only the relevant server processes, and dropping any attached shared memory segments.

[Read More…]

Onclean – a little known IDS commandScott O'Rourke2020-08-18T15:27:08+01:00

Is the cloud the right place for IBM Informix?

“We saw an increase in computed throughput of 42%” Read how the free version, Innovator-C edition and Workgroup edition compare in a cloud environment when being stress tested by TPC-C benchmark. “The total daily cost was less than the price of 2 cups of coffee”

[Read More…]

Is the cloud the right place for IBM Informix?Tristan Baron, John Baker2020-08-18T15:36:03+01:00

Making Microsoft SQL Linked Server and Informix work

Abstract

Microsoft SQL Server is a popular choice for consolidation of report data from multiple database products, as its Linked Server feature – which is included in the base product unlike Informix Enterprise Gateway Manager – makes it possible to access tables in heterogeneous databases within T-SQL via OLE DB. However, there are some settings required to make this work seamlessly, which are described in this article as they are not that obvious.

[Read More…]

Making Microsoft SQL Linked Server and Informix workDoug Lawry2020-08-14T12:41:16+01:00

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract:

Related Technical Articles:

Abstract

Related Technical Articles:

Updated June 2020

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Abstract

Related Technical Articles:

Related Technical Articles:

Abstract

Related Technical Articles: