LinkedIn

IBM Guardium v9.5 VM Installation

Abstract:

This technical article will guide the reader through an IBM Guardium v9.5 VM installation and focus on some of the more obvious do’s and don’ts. If nothing else, if this is your first time installing Guardium this article will save you hours of head scratching. Note that there are no easily accessible trials for IBM Guardium however the IBM Part Numbers have been referenced to ease location of the required software.

[Read More…]

Related Technical Articles:

Default ThumbnailA Fresh Look at Database Security Default ThumbnailAn Introduction To TimeSeries Default ThumbnailWhat is a Vulnerability Assessment?
IBM Guardium v9.5 VM Installation2020-08-14T13:25:01+01:00

How to navigate a Genero Application

Abstract

In Informix 4GL the only way to navigate an application is using a “ring” menu. This works very well when the application has a small number of modules with one menu but in complex applications, where there are many modules grouped into various submenus, the ring menu makes navigating the application very cumbersome. Modern alternatives such as tree-view and drop-down menus don’t exist in 4GL, but they do exist in Genero! This article discuss how best to navigate a Genero application:

[Read More…]

Related Technical Articles:

Default ThumbnailAn Introduction To TimeSeries Default ThumbnailData Presentation in Genero Default ThumbnailRun a Green Screen Application in Genero
How to navigate a Genero Application2020-08-14T13:24:36+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…]

Related Technical Articles:

Default ThumbnailAGS: Release 10 New Features Explained Default ThumbnailMaking Microsoft SQL Linked Server and Informix Standard engine work InformixHQ Setup
New Features in AGS Server Studio & Sentinel2020-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…]

Related Technical Articles:

Default ThumbnailAn Introduction To TimeSeries Default ThumbnailInformix “cdr migrate server” Default ThumbnailEasy IWA: Part 2 Creating an IBM Informix Warehouse Accelerator under 12.10.FC4
Understanding Informix Configurations2020-08-14T13:22:54+01:00

Improve user productivity with Genero

Abstract

Historically, data input applications only allowed a user to access one part of the application at any one time. If a user needed to access another part of the application, for example to view customer details whilst updating an order, he or she would need to stop what they were doing and navigate to another part of the same application. As applications have grown larger and more complex this becomes a big user productivity drain. This article describes how to solve this problem elegantly and simply in Genero, by allowing multiple modules of the same application to run concurrently in a single window and ultimately improve user productivity with Genero.

[Read More…]

Related Technical Articles:

Default ThumbnailAn Introduction To TimeSeries Default ThumbnailData Presentation in Genero Default ThumbnailMigrating to Genero v4
Improve user productivity with Genero2020-08-18T10:50:11+01:00

Manage Concurrent Data Inputs and Displays in Genero

Abstract

In the commercial world today we see growing complexity and depth in the information we store. A simple example would be a custom product or order line that is itself made up of many other products each with a variety of purchasing or build options. Historically data input applications did not support this type of requirement very well. This article describes how to solve this programming problem by creating, using and managing concurrent data inputs and displays in Genero.

[Read More…]

Related Technical Articles:

Default ThumbnailData Presentation in Genero Default ThumbnailAn Introduction To TimeSeries Default ThumbnailUpgrade to the Latest Genero Release
Manage Concurrent Data Inputs and Displays in Genero2021-06-08T10:13:10+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…]

Related Technical Articles:

Default ThumbnailMaking Microsoft SQL Linked Server and Informix work Default ThumbnailMaking Microsoft SQL Linked Server and DB2 work Default ThumbnailAn Introduction To TimeSeries
Making Microsoft SQL Linked Server and Informix Standard engine work2020-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…]

Related Technical Articles:

Default ThumbnailInformix Stored Procedure for Mass Delete Default ThumbnailLittle known IDS commands: genoncfg Default ThumbnailLittle known IDS commands: onsecurity
Bug in IDS 11+ sysadmin:alertcleanup function fix2020-08-14T13:21:15+01:00

Little known IDS commands: onsecurity

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…]

Related Technical Articles:

Default ThumbnailAn Introduction To TimeSeries Default ThumbnailLittle known IDS commands: onclean Default ThumbnailLittle known IDS commands: ifxcollect
Little known IDS commands: onsecurity2024-06-14T11:06:33+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…]

Related Technical Articles:

Default ThumbnailAn Introduction To TimeSeries Default ThumbnailLocked tables: how to avoid them Default ThumbnailInformix Stored Procedure for Mass Delete
Automatic management of range interval tables2020-08-18T15:25:45+01:00
Go to Top