Related links:
Title
|
Type
|
Date
|
|---|---|---|
| Upgrading to Informix 12.10
IBM Informix version 12.10.xC1 comes with striking new features and enhancements in
existing features--as well as a few features or products that were removed. Understanding the
new, enhanced, and discontinued features is crucial for better planning and determining
which functions should be disabled or enabled during the upgrade process. This
minimizes the impact of conversion/reversion and results in a smooth upgrade
to Informix 12.10. This article provides all the necessary information to help
database
administrators make an informed decision on setting the 12.10 features during
conversion
and then changing the settings, if needed, after the upgrade. The article also covers the
required steps in case a reversion is needed.
|
Articles | 25 Apr 2013 |
| Compare the Informix Version 12 editions
Get an introduction to the various editions of IBM Informix, and compare features,
benefits, and licensing considerations in a
side-by-side table. Regardless of which edition you choose, Informix brings you
legendary ease-of-use, reliability, stability, and access to extensibility
features.
|
Articles | 18 Apr 2013 |
| Creating data marts with the IBM OpenAdmin Tool (OAT) for Informix
The IBM OpenAdmin Tool (OAT) for Informix is a web application for
administering and analyzing the performance of IBM Informix database servers. You can
now use OAT to administer Informix Warehouse Accelerator. Informix Warehouse Accelerator
processes warehouse queries more quickly than the Informix database server does. With
OAT, you can create data marts based on workload analysis, which is a process that
analyzes the query workload in a data warehouse. You can use OAT to schedule loads to
refresh the data in the data marts. You can also use OAT to create and drop accelerators
and enable and disable data marts. In this article, learn how to create data
marts using OAT.
|
Articles | 18 Apr 2013 |
| IBM Mobile OpenAdmin Tool for Informix
Have you ever wanted to monitor your IBM Informix database servers on
the go from your mobile device? This article introduces the IBM Mobile OpenAdmin Tool
for Informix (OAT) application. It explains how you can use this new app to check the status
and performance of one or more Informix database server instances quickly and easily
from the palm of your hand. It describes how to set up Mobile OAT and how to
connect it to your regular OpenAdmin Tool for Informix installation. This article also
outlines some recommended security best practices when using Mobile
OAT.
|
Articles | 04 Apr 2013 |
| OpenAdmin tool for Informix's Health Advisor plug-in
This article is a deep dive into the Health Advisor plug-in for the OpenAdmin
Tool for Informix. As the graphical user interface for monitoring and
administering the Informix database server, the OpenAdmin Tool for Informix (OAT) is
an ideal vehicle for a health check system for your database server. With the
introduction of the Health Advisor plug-in, you can use OAT to regularly analyze the
health and performance of your Informix database server. This article covers how the
Health Advisor plug-in works, how to use it, and how it can benefit an Informix DBA. It
also provides a step-by-step guide to customizing the Health Advisor by adding your own
health checks and alarms.
|
Articles | 21 Mar 2013 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 7: Informix Data Warehousing
In this tutorial, you'll learn about IBM Informix Data
warehousing concepts and the tools that you can use to create data warehouses and
optimize your data warehouse queries. This tutorial prepares you for Part 7 of the
System Administration Certification exam 919 for Informix v11.70.
|
Tutorial | 06 Dec 2012 |
| Private installation feature of Informix: Client perspective
Starting with IBM Informix 11.70xC2, Informix started supporting
the private installation feature. The private installation feature(non-root user
installation) will allow Informix to be installed by a user other than root, and will
permit the software to run without user Informix or group Informix on the machine.
Inside the server, Informix will be used as the owner of the system catalog, but neither
user Informix nor group Informix will have any special privileges with respect to a
private server. The CSDK and other installers which are part of the Informix bundle will
also permit non-root users to install the software. In this article, we discuss aspects
of this feature in Informix and provide tutorials on how to manage users using JDBC,
ESQL/C and ODBC drivers.
|
Articles | 21 Nov 2012 |
| Analyze DB2 spatial data with a free geobrowser
A geobrowser for DB2, Informix and Netezza is now available as a free download.
You can easily list tables containing spatial data and select the tables to be
displayed as a map using a combination of points, lines and polygons. The
color, symbols, linestyle and shading are user selectable. Map navigation
tools allow you to zoom in and out, pan the map and select and display the
alphanumeric values associated with each graphic object. The geobrowser can
render the results of spatial analysis using DB2, Informix or Netezza. Application
developers can use these components to construct custom spatial visualization
applications. This tutorial shows you step-by-step how to use the free
geobrowser to visualize data from DB2 tables.
|
Tutorial | 01 Nov 2012 |
| Solving business problems with Informix TimeSeries
This IBM Redbooks publication is for people who want to implement a solution that revolves around time-based data. It gives you the information that you need to get started and be productive with Informix TimeSeries.
|
Redbooks | 08 Oct 2012 |
| Open Source Big Data for the Impatient, Part 1: Hadoop tutorial: Hello World with Java, Pig, Hive, Flume, Fuse, Oozie, and
Sqoop with Informix, DB2, and MySQL
This article is focused on explaining Big Data and then providing simple worked
examples in Hadoop, the major open-source player in the Big Data space. You'll be happy
to hear that Hadoop is NOT a replacement for Informix or DB2, but in fact plays nicely with
the existing infrastructure. There are multiple components in the Hadoop
family and this article will drill down to specific code samples that show the capabilities.
No Elephants will stampede if you try these examples on your own PC.
|
Articles | 27 Sep 2012 |
| Stored procedures used in callable and prepared statements
To improve the performance of a relational database application, it is
normal to use stored procedures, which are nothing but
user-defined functions containing a series of SQL statements stored in database. In this
article we are going to demonstrate how to access a Stored Procedure using callable
statements with the Informix JDBC driver. JDBC CallableStatement extends the
PreparedStatement and sends the request to server to execute a Stored Procedure for
complex operations (such as returning values or using input and output Stored Procedure
parameters).
|
Articles | 06 Sep 2012 |
| Evaluate: Informix 11.7
Download a trial version of Informix Ultimate Edition 11.7 or download one of
the free editions: Informix Developer Edition 11.7 (for development use only)
or Informix Innovator-C Edition 11.7 (for small production workloads.)
Also available in:
Portuguese
|
Trial Downloads | 12 Jul 2012 |
| Oracle to IBM Informix porting guide
This article describes the differences between Oracle and
Informix functionality and syntax. In addition to DDL, DML and overall
SQL syntax, you'll explore the differences between Oracle and Informix with
regards to the use of large objects, user-defined types, user-defined
routines, and table partitioning.
Also available in:
Chinese
|
Articles | 01 Jul 2012 |
| System Administration Certification exam 919 for Informix 11.70 prep, Part
8: Security
Data security is always a concern for database administrators. This
tutorial helps you understand how to secure your data
by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database
server to monitor database activities. This tutorial prepares you for Part 8 of
the System Administration Certification exam 919 for Informix(R) v11.70.
Also available in:
Chinese
Portuguese
|
Tutorial | 20 Jun 2012 |
| Use OData with IBM DB2 and Informix
This article provides a brief introduction to OData, a Web API for data access.
It then goes on to describe how OData can be used with IBM DB2, for Linux, UNIX, and Windows,
for z/OS, and for Informix. Finally, it provides step-by-step instructions for exposing
OData from DB2 in conjunction with Microsoft Visual Studio.
|
Articles | 31 May 2012 |
| OUT and INOUT parameter support for stored procedure calls in Informix ODBC
Driver
Learn how the implementation of the OUT and INOUT parameter support
in IBM Informix ODBC Driver enhances the power of stored procedure calls
in Informix. This article explains how you can employ various types of
parameters as OUT or INOUT to send or retrieve data from an Informix database using procedure calls.
Although the OUT and INOUT types are the standard parameter types, prior to the CSDK 3.50.xC4
release ODBC driver did not support these parameter types.
Also available in:
Russian
|
Articles | 31 May 2012 |
| Understand the trusted context feature in Informix
The use of connection pooling to data sources can lead to role-based
security breaches. Support for trusted connections and trusted contexts
in Informix server gives the flexibility of connection reuse, granting of
controlled privileges to the middle tier, and enhanced user accountability
in a three-tier application without compromising database security, all while
improving system performance. This article discusses trusted connections and
trusted contexts, and shows how to manage trusted contexts using JDBC, ESQL/C
and ODBC drivers.
|
Articles | 10 May 2012 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 2: Informix space management
In this tutorial, you'll learn how to configure and manage storage spaces on
IBM Informix(R) database, the utilities to create those storage
spaces, and how to use
fragmentation and features to optimize the storage in the database. This tutorial prepares you
for Part 2 of the System Administration Certification exam 919 for Informix
v11.70.
Also available in:
Chinese
|
Tutorial | 10 May 2012 |
| Get started now with the Informix TimeSeries solution
IBM Informix provides native support for handling time series data.
The TimeSeries data type present in IBM Informix helps to
reduce the cost of storage as well as helping to increase performance when you select
and load large amounts of time series data. In this article, learn how you can start
creating and loading the time series data. Also, the Virtual Table Interface makes
time series look like the normal tables. This article also describes general architecture
of IBM Informix time series components, steps for creating and loading a time series,
and administering a time series using the Open Admin tool.
Also available in:
Chinese
|
Articles | 29 Mar 2012 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 5: Informix backup and restore
In this tutorial, you'll learn about IBM Informix(R) database
backup and restore concepts and strategies, and you'll learn about utilities and commands
for managing your database backup and restore processes. In addition, learn
how to monitor your backups and perform problem determination when necessary.
This tutorial prepares you for Part 5 of the System Administration
Certification exam 919 for Informix v11.70.
Also available in:
Chinese
|
Tutorial | 22 Mar 2012 |
| Optimizing Informix database access
Normally access to an Informix database can take from less than a second up to some expected period of time, depending on the
database operation. Sometimes it can take much longer than you expected due to many reasons, such as the network speed, system
performance, system load, and so on. In the worst scenario, the Informix client may be blocked forever for the expected server
response that never comes. This article explains how to interrupt an SQL or
connection request that is requiring more time than expected in order to improve the
performance of your Informix database application.
Also available in:
Chinese
|
Articles | 22 Mar 2012 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 4: Performance tuning
Tune IBM Informix(R) database server and its different subsystems
for optimum performance. After an overview, follow along with examples on
how to look at the database server and its subsystems. Learn about important database optimization
elements, including checkpoints, recovery, physical
logging, logical logging, asynchronous I/O VP, network parameters, disk
resources, CPU VP resources, PDQ, memory grant manager, scan threads,
index creation, statistics maintenance, and self tuning. Use this tutorial, the fourth in a series of
eight tutorials, to help prepare for Part 4 of the Informix 11.70 exam 919.
Also available in:
Chinese
Portuguese
|
Tutorial | 01 Mar 2012 |
| Developing heterogeneous database applications
using the IBM Data Server Provider for .NET
Transactional logic that works across heterogeneous databases needs to
use global transactions. The IBM Data Server Provider for .NET supports the
distributed transaction model from the System.Transactions namespace, which has
the capability to create and manage global transactions. The code examples in this article show how
to use the IBM Data Server Provider for .NET to create
and manage global transactions on the IBM data servers.
Also available in:
Chinese
|
Articles | 02 Feb 2012 |
| System Administration Certification exam 919 for Informix 11.70 prep, Part 3: System activity monitoring
In this tutorial, you'll learn about IBM Informix(R) database tools, the
utilities to monitor the database, and how to diagnose problems.
Learn how to use the system-monitoring interface (SMI) and the SQL administration API.
This tutorial prepares you for Part 3 of the System Administration Certification exam 919 for Informix v11.70.
Also available in:
Chinese
Portuguese
|
Tutorial | 28 Dec 2011 |
| Accelerate Hibernate and iBATIS applications using pureQuery,
Part 1: Enable static SQL and heterogeneous batching for Hibernate
applications
When extended with the downloadable IBM Integration Module, the IBM
Optim pureQuery Runtime simplifies the process of generating DB2 static SQL
for Hibernate and iBATIS applications. It does this without requiring changes
to your application code or gathering SQL from production
workloads. The Optim pureQuery Runtime also enables Hibernate and iBATIS
applications that access DB2 or Informix to benefit from the heterogeneous
batching feature in pureQuery. This
article is part one of a four-part series about using the IBM
Integration Module with Hibernate applications. This article includes a
downloadable sample application that illustrates how you can easily enable
static SQL and heterogeneous batch functions with Hibernate applications. The
article also provides informal elapsed time performance measurements. Part 2
focuses on iBATIS applications.
|
Articles | 21 Oct 2011 |
| Informix DBA: Every last drop
Getting the best performance out of limited resources was the theme of
the recent Fastest Informix DBA contest, held at the 2011 IIUG Informix Conference. In this article, see
how the contestants answered the challenge.
|
Articles | 21 Oct 2011 |
| Introduction to IBM Informix database software
This is an introductory Knowledge Path that will introduce you to the different features
and offerings from IBM Informix. Informix is an exceptional relational
database that offers outstanding performance, reliability, scalability and
manageability for businesses, ISVs and OEMs of all sizes. Learn how
you can reduce costs and increase productivity with near-zero administration
for small to highly-distributed environments regardless of platform.
.
|
Knowledge paths | 07 Oct 2011 |
| Informix Warehouse Accelerator: Create a data mart
Learn how to use the administration interface to create a data mart definition, validate the data mart structure, deploy the data mart, and load data into the data mart.
|
Demos | 07 Sep 2011 |
| Informix Warehouse Accelerator: Explore the accelerator interface
Become familiar with IBM Smart Analytics Optimizer Studio, the
Eclipse-based administration interface for Informix Warehouse Accelerator. Learn
how the different views and menus are used to interact with Informix Warehouse Accelerator.
|
Demos | 07 Sep 2011 |
| Perform case-insensitive queries in Informix
When you query your data, you may wish your query to be
case-sensitive, or you may wish to ignore upper- and lower-case differences in data. In the past,
IBM Informix databases were
case-sentitive, and it required some effort to perform a case-insensitive search.
Now with the latest release, Informix supports case-insensitive databases. In
this article, learn how to create a case-insensitive database and explore
considerations for implementing check constraints, using distinct searches, using
group-by aggregate queries, implementing distributed queries, and more, in a case-insensitive
database environment.
Also available in:
Chinese
|
Articles | 25 Aug 2011 |
| Integrate the rich Internet application framework ZK with Informix to build
real-world applications
This tutorial presents a real-world example that integrates IBM Informix and ZK, a
rich Internet application (RIA) framework. Informix is a flagship IBM RDBMS product, while ZK is a
Java-based web application framework supporting Ajax applications. This event-driven framework enables
creation of rich user interfaces with minimal knowledge and use of JavaScript. ZK's unique
server-centric approach enables synchronization of components and events across the client and server
via the core engine.
Also available in:
Korean
Portuguese
|
Tutorial | 18 Aug 2011 |
| Use Informix ODBC Driver with an ODBC Driver Manager
Because there are many different types of ODBC Driver managers
available in today's market, many users find it complicated to configure the IBM
Informix ODBC Driver to
work with third-party driver managers such as UnixODBC, Progress DataDirect, or
iODBC. This article describes the components used by an ODBC application and provides a quick
reference of the configuration parameters needed to set up IBM Informix ODBC with a
third-party ODBC
Driver Manager.
Also available in:
Chinese
|
Articles | 04 Aug 2011 |
| Informix DBA: Informix Warehouse Accelerator
The Informix Warehouse Accelerator combines new data warehouse technology
with traditional relational database technology. Learn how the author's benchmark went
from 9 hours and 40 minutes to just over 15 minutes using this new
technology.
Also available in:
Chinese
|
Articles | 01 Aug 2011 |
| What's new in Informix MACH 11 high-availability features for secondary
servers
IBM Informix Version 11.50.xC6 brought several enhancements for Informix multi-node active clusters for high
availability, called MACH 11. In this article, get an overview of some of the new
features, such as the ability to stop or suspend replication in the Informix cluster environment, and the capability to perform
an external backup on a remote standby secondary server. You'll also learn how to avoid blocking checkpoints on primary servers in
a high-availability data replication (HDR) environment. The article includes detailed steps for implementing the new enhancements,
as well as explaining how they work. A frequently asked questions section at the end will answer any lingering questions.
Also available in:
Chinese
|
Articles | 21 Jul 2011 |
| Recommended practices for using Cognos with Informix, Part
2: Deploy Informix with IBM Cognos BI Server 10
Connecting your Informix databases to IBM Cognos Business Intelligence software gives you a way to unleash the power of your data with expanded
query, reporting, and analysis capabilities. If you're ready to take that step, this two-part tutorial series gives you the information you need to
install, configure, and deploy the necessary components to achieve the best results. Part 1 showed how to get started with using IBM Cognos Express
V9 together with IBM Informix V11.5 as a content store and data source. In Part 2, you'll get the same level of detail for deploying Informix with IBM Cognos BI
Server V10. The tutorials include recommended practices for each step along
the way, based on lessons learned from real-world deployments on the Windows operating system.
Also available in:
Chinese
Portuguese
|
Tutorial | 07 Jul 2011 |
| Evaluate: IBM Informix Growth Edition
Informix Growth Edition provides powerful data management capabilities
for departmental solutions or small-to-midsized businesses. It supports up to
two cluster nodes of any type and unlimited replication nodes to send or
receive data updates from other nodes in the grid. I also allows unlimited data
storage.
Also available in:
Portuguese
|
Trial Downloads | 06 Jul 2011 |
| Evaluate: Informix Express Edition
A trial download is not available for Informix Express
Edition. However, you can access it on the Amazon Elastic Compute Cloud. In addition, you can download several
editions of Informix 11.7.
Also available in:
Chinese
Portuguese
|
Trial Downloads | 05 Jul 2011 |
| IBM Informix Flexible Grid: Extending Data Availability
In this IBM Redbooks publication, we focus on, and provide an overview of, the high availability and Enterprise Replication features of IBM Informix 11.70. Informix provides solutions for making data highly available in the MACH11 cluster. The components of the MACH11 cluster include High Availability Data Replication (HDR), Shared Disk Secondary (SDS), and Remote Secondary Standby (RSS) servers. Enterprise Replication (ER) provides a means of selectively replicating data between systems in near real time. The Informix Flexible Grid eliminates the administrative complexity of ER. Flexible Grid provides the ability to automatically create database objects, such as tables, indexes, and stored procedures, on all nodes within the grid as a single operation. These enhanced Enterprise Replication features provide solutions for those customers requiring reliable and quick dissemination of data across a global organization.
|
Redbooks | 27 Jun 2011 |
| Enhanced availability and workload management with Informix flexible
grid
IBM Informix 11.70 supports a new feature called flexible grid,
comprising a group of replication servers in a
distributed environment that simplify administration. With a flexible grid, you can monitor and manage servers that are geographically dispersed just
as easily as you would administer a single server. In this article, you will learn how to convert your existing Enterprise Replication
(ER) domain to a grid domain. In addition, this article shows you how to configure and monitor the grid with IBM
OpenAdmin Tools for Informix, a free web-based tool that allows you to administer Informix servers through a web browser.
Also available in:
Chinese
|
Articles | 23 Jun 2011 |
| An insider's guide to star join optimization in IBM Informix Server
IBM Informix Server V11.70 introduced a new star join optimization
feature that can significantly increase query performance for queries on star
schemas and snowflake schemas. This article explains how star join
optimization works in IBM Informix Server, and how you can affect query
optimization by using newly introduced optimizer directives and session
environment settings. It also shows you how to identify star join optimization
in explain file.
Also available in:
Chinese
Portuguese
|
Articles | 05 May 2011 |
| Database in the cloud
Data pros are adopting cloud computing concepts to offer databases as a service --
easing management burdens and sending users to cloud nine. Learn about the three steps
for getting started with database as a service.
|
Articles | 03 May 2011 |
| Informix DBA: Fastest Informix DBA contest III
DBA contestants face the challenge of performance tuning a multiuser OLTP Informix environment.
Also available in:
Chinese
|
Articles | 02 May 2011 |
| Access stored procedures using the IBM Data Server Provider for
.NET
Stored procedures and functions are highly valued for the efficiency with which they can carry out database logic. But
they also come with a high level of complexity, which can
challenge application writers. The IBM Data Server Provider for .NET alleviates the pain
by enabling you to access these complex
objects in a very simple and .NET-like way.
|
Articles | 28 Apr 2011 |
| Take advantage of fragment-level statistics and smarter statistics in IBM
Informix
Keeping statistics up to date is a regular part of the maintenance of relational databases.
However, running update statistics itself incurs overhead. Learn how new features in IBM Informix V11.7 help you to improve
efficiency by determining when you really need to run update statistics. Another enhancement
in Informix V11.7 improves efficiency by letting you gather fragment-level statistics for fragmented tables.
Learn how these enhancements can help you optimize your database and applications.
Also available in:
Chinese
Portuguese
|
Articles | 21 Apr 2011 |
| Tune your Informix database for top performance, Part 1: Tuning the data model and the application
Author Jack Parker analyzes the "Fastest DBA benchmark" to explain some basic principles
of how to tune your Informix database application to get the best possible
performance. In Part 1, of the series, he examines how the data model and the application, together with ensuring
that you have updated statistics, play into performance.
Also available in:
Chinese
Portuguese
|
Articles | 14 Apr 2011 |
| The Informix Detective Game
Here's a fun way to learn about IBM Informix! Learn or teach the basics of
Informix and relational databases with an interactive game called the
Informix Detective Game (the game's theme is a crime investigation). The game teaches
relational database concepts and shows how technology can be applied to solving real-life
problems. The Informix Detective Game is based on the DB2 Detective Game created by
Joanna Kubasta and Joanne Moore.
Also available in:
Chinese
|
Tutorial | 14 Apr 2011 |
| Evaluate: IBM Informix Developer Edition
A trial download is not available for Informix Enterprise
Edition. Informix
Developer Edition 11.7 is available for download. You can
also use Informix Developer Edition on the cloud.
Also available in:
Chinese
Portuguese
|
Trial Downloads | 30 Mar 2011 |
| Get started developing applications with the IBM Data Server Driver
Package
The IBM Data Server Driver Package (also referred to as the ds
driver) can be used to provide runtime support for various customer applications that interact with DB2 for Linux(R), UNIX(R), and Windows(R), z/OS(R), IBM i(R), and Informix(R) databases through APIs, including ODBC/CLI, .NET, and JDBC. The IBM Data Server Driver Package supports open source and Java(TM), as well as applications that use ODBC, OLE DB, and .NET provider. Find out about advantages, disadvantages, and examples of a IBM Data Server Driver Package solution compared with other
driver solutions, such as the IBM Data Server Runtime Client solution. Get the details on how the IBM Data Server Driver Package
is supported across various platforms and languages. Learn how to install and configure
the IBM Data Server Driver Package, how to use configuration files, and
how to deploy and upgrade this package on Linux, UNIX, and Windows.
Also available in:
Chinese
|
Articles | 24 Mar 2011 |
| Take a beginner's tour of the Informix virtual table interface with shared
libraries
IBM Informix (R) provides access to external data sources through the virtual table interface (VTI). The VTI provides
a set of hooks called purpose functions. As a developer, your task is to create an access method that implements VTI
purpose functions and as many additional user-defined routines (UDRs) as necessary to access your external data
source. This tutorial shows you how to compile and run your VTI UDR as a shared library.
Also available in:
Chinese
|
Tutorial | 17 Mar 2011 |
| OpenJPA caching with WebSphere eXtreme Scale, Informix, and DB2,
Part 1: Caching POJOs with hellojpa
OpenJPA is an Apache persistence project. One elegant feature of OpenJPA
lets you speed up your lookups and reduce the load on
back-end databases with a Java Cache with NO application code changes! This article will
show you how to install, configure, and experiment with IBM WebSphere eXtreme Scale (XS) product in conjunction with
OpenJPA. You can experiment with this without spending any cash, as the XS cache is available for free evaluation.
Also available in:
Chinese
|
Articles | 10 Mar 2011 |
| Storage provisioning in Informix
Storage provisioning, a new feature in Informix 11.7, makes storage management
much easier. With this new functionality, DBAs don't have to monitor Informix in order
to anticipate when an application might deplete storage. Now Informix can automatically allocate storage
to containers whenever a database requires additional space. In this article, learn how to implement
this functionality.
Also available in:
Chinese
Portuguese
|
Articles | 03 Mar 2011 |
| Migrate a database from MySQL to IBM Informix Innovator-C Edition, Part 2: Step-by-step walk-through of the migration process
Walk through a migration from MySQL to Informix, step by step.
The tutorial provides a conversion methodology and discusses the processes for migrating both database objects and data. It includes a discussion
of SQL differences and shows how to migrate tables, views, stored procedures, functions, triggers, and more.
|
Tutorial | 17 Feb 2011 |
| Data Manager: DHL Mexico Follows the Money
Merv Adrian tells how DHL Mexico used Informix to realize multiple IT-related benefits.
Also available in:
Chinese
|
Articles | 14 Feb 2011 |
| Hands-on first look: Informix 11.7
Lester Knutsen and Art Kagel introduce Informix 11.7, share the results of their performance tests, and describe its new features and how to use them.
Also available in:
Chinese
|
Articles | 14 Feb 2011 |
| Informix DBA: More Musings on Informix 11.7
Lester Knudsen and Art Kagel evaluate some of the advanced capabilities that come with Informix 11.7.
Also available in:
Chinese
|
Articles | 14 Feb 2011 |
| Use the MERGE statement in Informix Dynamic Server
This article discusses the merge statement of IBM Informix(TM) Dynamic Server,
which follows the SQL 2003 standard. The merge command is especially useful in data warehouse
(ETL) environments where transaction tables are merged into bigger warehouse tables.
Also available in:
Chinese
Portuguese
|
Articles | 10 Feb 2011 |
| Migrate a database from MySQL to IBM Informix Innovator-C Edition, Part 1: Comparing MySQL to IBM Informix Innovator-C Edition
If you are a MySQL user or are thinking about MySQL for future business
requirements, there are strong reasons to consider Informix Innovator-C Edition
over MySQL. In this article, get an overview of both products, which
highlights their key
differences, and gain insight to their respective advantages and disadvantages
for your business.
|
Articles | 03 Feb 2011 |
| IBM Informix Dynamic Server Enterprise Replication templates
Learn how to use the new templates in Informix Dynamic Server, Version 10.0, to administer a large number of Enterprise Replication nodes and tables. Introducing IBM Informix(R) Dynamic Server, Version 10.0, Enterprise Replication templates. Learn how to use templates to administer a large number of Enterprise Replication nodes and tables. The template feature is not currently available in the replication products of competitors. [19 Dec 2010: Updated command in Listing 8. --Ed.]
|
Articles | 19 Dec 2010 |
| Get started with the IBM Data Server CLI Driver for Informix
The IBM Data Server CLI Driver supports application development for IBM
Informix and IBM DB2. It is available for download as part of the Informix
Client Software Development Kit (CSDK). This article describes how the CLI
Driver supports ODBC application development for Informix, and highlights the
benefits of using the Data Server CLI Driver. The article also provides
examples to help you quickly get started using the IBM Data Server CLI
Driver.
Also available in:
Chinese
|
Articles | 09 Dec 2010 |
| Upgrade Informix high availability clusters online
Now you can upgrade your Informix high availability cluster without any downtime to your client connections and
transactions. In this article, get an introduction to the "rolling upgrade" feature and the various approaches to implementing
it. Choose the approach that best meets your needs and follow the step-by step instructions to perform the rolling upgrade
of your 11.50 Informix high availability cluster to 11.70 Informix high availability cluster.
Also available in:
Chinese
Portuguese
|
Articles | 02 Dec 2010 |
| Monitoring in DB2 9.7, Part 2: Relational access to XML event monitor data in DB2 9.7
Learn how you can get relational access to the subset of monitor data
that is captured in the form of an XML document by an activity or statistics
event monitor in IBM DB2 for Linux, UNIX, and Windows Version 9.7
(DB2).
Also available in:
Chinese
|
Articles | 24 Nov 2010 |
| Understand the Informix Server V11.7 defragmenter
Starting with IBM Informix, Version 11.70.UC1, you can defragment a
table, a fragment, or an index, including system catalogs. This reduces the number of extents
in which the data in your partition resides. In this article, learn what the defragmenter is,
understand some considerations for its use, and see usage examples.
|
Articles | 18 Nov 2010 |
| Understanding Informix 11.70 features with upgrade impact
IBM Informix, Version 11.70.xC1 has an abundance
of new features, and this article aims to help you achieve a smooth upgrade to Informix
11.70.xC1 and efficiently use these new features. In this article, explore a list
of the features that have upgrade impact, and get a brief overview of each
feature, with information about how to use the features after upgrade, information
about reversion messages (in case you want to revert to your older version), and information
about any new onconfig parameters and system catalog changes that were added for the new features.
Also available in:
Chinese
Portuguese
|
Articles | 11 Nov 2010 |
| The Beginning of the Next Decade of IBM Informix
The story behind Informix 11.7, the new possibilities it brings, and what it will mean in the years to come.
Also available in:
Chinese
|
Articles | 03 Nov 2010 |
| IBM Informix Developer's Handbook
This IBM Redbooks publication provides fundamentals of Informix application development. It covers the Informix Client installation and configuration for application development environments. It discusses the skills and techniques for building Informix applications with Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade, and Hibernate. The book uses code examples to demonstrate how to develop an Informix application with various drivers, APIs, and interfaces. It also provides application development troubleshooting and considerations for performance.
|
Redbooks | 29 Oct 2010 |
| Informix TCO: The facts are in
Two studies from ITG and Forrester Consulting show how Informix reduces TCO and maximizes ROI.
Also available in:
Chinese
|
Articles | 10 Oct 2010 |
| Informix DBA: Building fast data warehouse schemas: Part 3
The last of Lester Knutsen’s three-part series focuses on designing summary tables.
Also available in:
Chinese
|
Articles | 10 Oct 2010 |
| Event-driven fine-grained auditing with Informix
Learn how to use triggers to implement fine-grained auditing. This
article covers the use of the datablade API to generate auditing events from
transactions. It also introduces a feature called trigger introspection that
allows you to create a generic auditing function that can be applied to any
table. The article comes with example code that implements the solutions
discussed.
|
Articles | 16 Sep 2010 |
| Accelerate Hibernate and iBATIS applications
using pureQuery, Part 2: Using the IBM Integration Module for iBATIS and pureQuery
When extended with the downloadable IBM Integration Module,
the IBM Optim pureQuery Runtime simplifies the process of generating
DB2 static SQL for Hibernate and iBATIS applications.
It does this without requiring you to make changes to your application code or
to gather SQL from production workloads.
The Optim pureQuery Runtime also enables Hibernate
and iBATIS applications that access DB2 or Informix to benefit from the heterogeneous
batching feature in pureQuery.
With the heterogeneous batching feature, you can batch multiple INSERT,
UPDATE, and DELETE requests before sending them across the network, even when the requests reference multiple tables.
This article is part two of a two-part series.
It describes using the IBM Integration Module with iBATIS applications.
This article includes a downloadable sample application that illustrates how you can easily enable
static SQL and heterogeneous batch functions with iBATIS applications.
Part one of the series focuses on Hibernate applications.
|
Articles | 16 Sep 2010 |
| Generating XML from the Informix server
This article describes how to use the extensibility features of IBM
Informix to generate XML-formatted data. Sample code is included.
Also available in:
Russian
|
Articles | 19 Aug 2010 |
| Informix DBA: Building fast data warehouse schemas: Part 2
Lester Knutsen shows how to design dimension tables in part two of a
three-part series on data model and schema design for data warehouses.
Also available in:
Chinese
|
Articles | 30 Jul 2010 |
| Embedded Informix: Think inside the box
A discussion of the reliability and performance characteristics of Informix that make it an excellent candidate for use as an embedded database server, and a walkthrough of creating an embedded deployment. Informix provides features--such as the Deployment Wizard and Deployment Utility--that simplify the creation of a deployment optimized for an embedded environment.
Also available in:
Chinese
|
Articles | 30 Jul 2010 |
| Migrating from Microsoft SQL Server to IBM Informix
In this IBM® Redbooks publication, we discuss considerations, and describe a methodology, for transitioning from Microsoft SQL Server 2008 to the Informix Dynamic Server. We focus on the topic areas of data, applications, and administration, providing information about the differences in features and functionality, including the data types, data manipulation language, data definition language, and stored procedures. Understanding the features and functionality of the two products assists you in developing a migration plan.
|
Redbooks | 26 Jul 2010 |
| Get started with direct file I/O support in IBM Informix 4GL
IBM Informix 4GL is a comprehensive development and production environment for creating sophisticated database
applications.
The 7.50.xC4 release of Informix 4GL includes direct support for file I/O without requiring function calls in
another language such as C.
This article describes the advantages of using the direct I/O support and provides you with an introduction
to how you can use it with operations such as OPEN FILE, CLOSE FILE, READ, WRITE, and SEEK.
The article includes code samples that can
help you get started with implementing the file I/O feature in your own applications.
Also available in:
Chinese
|
Articles | 15 Jul 2010 |
| Recommended practices for using Cognos with Informix, Part
1: Deploy Informix with IBM Cognos Express 9
Connecting your Informix databases to IBM Cognos Business Intelligence software gives you a way to unleash the power of your data with expanded
query, reporting, and analysis capabilities. If you're ready to take that step, this two-part tutorial series gives you the information you need to
install, configure, and deploy the necessary components to achieve the best results. Part 1 gets you started with using IBM Cognos Express V9 together
with IBM Informix V11.5 as a content store and data source. In Part 2, you'll get the same level of detail for deploying Informix with IBM Cognos BI
Server V10. The tutorials include recommended practices for each step along
the way, based on lessons learned from real-world deployments on the Windows operating system.
Also available in:
Chinese
|
Tutorial | 30 Jun 2010 |
| Informix DBA: Building Fast Data Warehouse Schemas
Why should you be concerned with the data model or schema design for
your data warehouse? Lester Knutsen shows why it's important to consider speed
when building data warehouse schemas, and how dimensional models or star schemas
can speed up query times
|
Articles | 30 Apr 2010 |
| Using Optim with Informix Dynamic Server, Part 2: Scenarios for using Optim with IDS
Part 1 of this tutorial series showed how to configure IBM Informix
Dynamic Server with Optim. In this tutorial, walk through some scenarios to
see how using Optim Data Privacy Solution with Informix can help you solve
real-world problems.
|
Tutorial | 29 Apr 2010 |
| Using Optim with Informix Dynamic Server, Part 1: Configure Informix Dynamic Server to work together with Optim Solutions
IBM Informix Dynamic Server, with its copious feature set, meets or
exceeds expectations for a high-performing, scalable, reliable, maintainable
database server for enterprise applications. However, if you need to segregate
older data and maintain it in such a way that it is easily accessible for
reporting or strategic decision making, you may want to consider implementing
it with IBM Optim Solutions. Optim lets you archive historical data from
various database systems supporting an application and restore data from these
archives in the production environment if needed, masking production data and
making it available for reliability and application quality testing. In this
tutorial, learn how to configure Informix Dynamic Server with Optim Solutions. In Part 2 of this series, you'll walk through some scenarios
showing you how using Optim Data Privacy Solution with Informix can help you
solve real-world problems.
|
Tutorial | 22 Apr 2010 |
| Informix application development and testing on the cloud
IBM Informix Dynamic Server (IDS) is database server software targeted
at high-volume online transaction processing (OLTP). IDS is ideal for managing
large deployments and embedded solutions. This tutorial provides step-by-step
instructions for using IDS in the Amazon Elastic Compute Cloud (EC2) for your
database application development.
Also available in:
Korean
Portuguese
|
Tutorial | 08 Apr 2010 |
| Using data file abstraction with external tables in Informix Dynamic Server
Starting with IBM Informix Dynamic Server (IDS) 11.50.xC6, you can use
the external table feature to easily perform load and unload operations. In
this article, learn how this feature provides an easy and intuitive way to
unload and load data using an SQL interface. Applying table abstraction to the
underlying data file makes it easier to seamlessly apply SQL operations. Also,
various formats, delimiters, and date and money formats accommodate the data
files that may come from any data source and from any geographic
location.
Also available in:
Portuguese
|
Articles | 18 Mar 2010 |
| Informix Enterprise Replication made easy with OpenAdmin Tool
IBM Informix Dynamic Server (IDS) is a powerful database with many useful
built-in features. One such feature is the ability to send data committed on one
server to another server automatically. Now you can use a Web browser to configure and
monitor this Enterprise Replication (ER) feature using the OpenAdmin Tool (OAT).
Also available in:
Portuguese
|
Articles | 18 Mar 2010 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 8: Backup and restore
In this tutorial, learn about essential Informix Dynamic Server 11.50
database backup and restore concepts, and about ON-Bar and ontape utilities to
backup and restore database server data. You will also learn about table-level
restore with archecker utility.
Also available in:
Portuguese
|
Tutorial | 11 Mar 2010 |
| Protect your data with Secure Sockets Layer support in Informix
Dynamic Server, Part 1: Setting up SSL support in IDS
Learn how to use the Secure Sockets Layer (SSL) feature of IBM Informix
Dynamic Server 11.50 to encrypt data in transit from client to server.
Also available in:
Portuguese
|
Articles | 10 Mar 2010 |
| Automatically extend dbspaces in Informix Dynamic Server 11.5
As productive databases containing important information systems rapidly grow larger and larger,
automated space management becomes more and more important.
This article shows you how to avoid out-of-space situations by using existing features of
Informix Dynamic Server (IDS) to implement space management functionality.
IDS 11.5 delivers a system database called SYSADMIN that includes administrative
stored procedures and an integrated DB scheduler.
Together, the stored procedures and scheduler enable the database server to execute database functions and procedures at
predefined times.
You can use the scheduler to continuously monitor all Informix dbspaces, and to extend space when necessary.
The article features a sample program that demonstrates how you can implement this function.
Also available in:
Russian
Portuguese
|
Articles | 25 Feb 2010 |
| Call Me
Examining the role data plays in an ever-changing telecommunications business
Also available in:
Russian
|
Articles | 22 Jan 2010 |
| The Informix High Performance Loader – Part 1
Understand the basics of High Performance Loader. Follow a simple HPL scenario of unloading a large table to a single flat file and loading this data into a new table with the same schema.
|
Articles | 15 Jan 2010 |
| The Informix High Performance Loader - Part 3
Look at the more tedious, but sometimes necessary, High Performance Loader maps and formats objects.
|
Articles | 15 Jan 2010 |
| Use REALbasic to develop Informix Dynamic Server database applications on
Mac OS
In this tutorial, see how to develop IBM Informix Dynamic Server (IDS)
database applications for Apple Mac OS using REALbasic. REALbasic is a
cross-platform programming language and development platform that you can use
to write a single application code base and deploy it on Mac as well as Linux
and Windows platforms. This tutorial shows you how to develop REALbasic
database applications on Mac OS that leverage the functionality of IDS on the
Mac OS platform.
|
Tutorial | 14 Dec 2009 |
| Informix Dynamic Server 11.50 Fundamentals exam 555
Certification Preparation, Part 5: Using SQL
This tutorial is the fifth in a series of tutorials designed to help you
become familiar with all the different aspects of IBM Informix Dynamic Server
(IDS) and help you get ready for the IDS Fundamentals Certification exam. This
tutorial covers the use of SQL to manipulate data.
Also available in:
Portuguese
|
Tutorial | 19 Nov 2009 |
| Get started with Informix Warehouse Feature, Part
2: Extract, load, and transform your data in Design Studio
The new IBM Informix Warehouse Feature provides an integrated and
simplified software platform to design and deploy a warehouse repository on
your existing IBM Informix Dynamic Server (IDS) infrastructure. This tutorial,
the second part of a series, gives you a hands-on and example-driven view of
the Informix Warehouse Client component, the Design Studio. Follow the steps
for designing and testing the data movements and transformations
(Extract-Load-Transform, or ELT jobs) in the form of data flows and control
flows that will do the task of populating the new data warehouse repository
you created in Part 1 of this series.
Also available in:
Portuguese
|
Tutorial | 12 Nov 2009 |
| Consume Web services using Informix 4GL
Enable IBM Informix 4GL (I4GL) as a service consumer to leverage and
reuse existing Web services and business logic coded in I4GL or other
programming languages. Enabling I4GL as a service consumer opens up many
possibilities of using I4GL to communicate with any programming language while
still enjoying the ease of coding using I4GL.
Also available in:
Portuguese
|
Articles | 29 Oct 2009 |
| Use IBM Informix 4GL to develop applications that support UTF-8 character sets
After an introduction to the UTF character set, this article
describes some of the Informix(R) 4GL capabilities, including searching, editing UTF
characters, displaying UTF characters, and creating reports with UTF-8 characters.
After reading this article, you will know how to configure Informix 4GL
7.50.xC1 to support the UTF-8 character set.
|
Articles | 29 Oct 2009 |
| Get started with Informix Dynamic Server user interface tools
Learn about the user interface utilities that help to access,
administer, and monitor IBM Informix Dynamic Server (IDS). This article
highlights the utilities DB-Access, AGS Server Studio, Open Admin Tool, and
Informix Server Administrator. In addition, learn about some new features that
help you leverage IDS capabilities using these tools.
|
Articles | 22 Oct 2009 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 9: Informix replication technologies
This is the last tutorial in a series of nine tutorials to help you
prepare for the Informix Dynamic Server (IDS) 11.50 Fundamentals certification
exam 555. This tutorial discusses replication technologies and provides an
overview of high availability technologies available in IDS. Learn the
difference between High Availability Data Replication and Enterprise
Replication, and follow the steps for how to set up an IDS server for
replication and high availability.
|
Tutorial | 17 Sep 2009 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 7: Tools and utilities
With a good understanding of the tools and utilities that come with IBM
Informix Dynamic Server (IDS), you'll find the database easier to monitor and
administer. In this tutorial, learn about those tools. This is the seventh of
a series of nine tutorials that will help prepare you for IDS exam
555.
|
Tutorial | 17 Sep 2009 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 4: Examining database objects
This tutorial continues your journey into Informix Dynamic Server by
discussing many of the objects that can be created and used inside of a
database. Some of these objects include tables, indexes, triggers, and views.
This tutorial discusses what they are, how they are used, and how to create
them.
Also available in:
Russian
|
Tutorial | 03 Sep 2009 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 3: DBMS instances and storage objects
This tutorial is the third in a series of nine tutorials designed to
help you become familiar with all the different aspects of IBM Informix
Dynamic Server (IDS) and help you get ready for the IDS Fundamentals
Certification exam. In this part, which corresponds with Part 3 of the exam,
learn how to identify and connect to IBM Informix database servers and
databases. Learn also how to create and configure database storage objects,
and gain an understanding of system databases and system catalog
tables.
|
Tutorial | 27 Aug 2009 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 2: Security
Get an introduction to the concepts of authentication,
authorization, and privileges as they relate to IBM Informix Dynamic Server 11.50
(IDS). This tutorial is the second in a series of nine tutorials designed to help you
prepare for the IDS Fundamentals Certification Exam (555).
Also available in:
Russian
|
Tutorial | 20 Aug 2009 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 6: Data concurrency
This tutorial is the sixth in a series of nine tutorials designed to help you
become familiar with all the different aspects of IBM Informix Dynamic Server
(IDS) and help you get ready for the IDS Fundamentals Certification exam. In
this part, which corresponds with Part 6 of the exam, gain an understanding of
the data concurrency mechanisms in IDS.
|
Tutorial | 13 Aug 2009 |
| Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 1: IDS planning and installation
This tutorial is the first in a series of tutorials designed to help you
become familiar with all the different aspects of IBM Informix Dynamic Server
(IDS) and help you get ready for the IDS Fundamentals Certification exam. This
first tutorial covers the planning and installation of IDS--a great place to
start to successfully understand and use IDS.
Also available in:
Russian
|
Tutorial | 16 Jul 2009 |
