Technical library

  • spacer Filter by products, topics, and types of content

    (115 Products)

    (113 Topics)

    (15 Industries)

    (15 Types)

 

1 - 100 of 234 results | Next Show Summaries | Hide Summaries Subscribe to search results (RSS)

View Results
Title none Type none Date down
Migrating 32-bit Informix ODBC applications to 64-bit
Informix 64-bit ODBC driver binaries have been available for many years, but the true 64-bit Informix ODBC driver was not introduced until Informix Client SDK v4.10 in early 2013. This article discusses the differences between the Informix 64-bit binaries of the Informix ODBC driver and the newer, true 64-bit driver. Also learn how to migrate your current 32-bit or 64-bit Informix ODBC applications to take advantage of the true 64-bit driver.
Also available in: Chinese  
Articles 01 May 2014
System Administration Certification exam 919 for Informix 11.70 prep, Part 1: Informix installation and configuration
In this tutorial, you'll learn about IBM Informix database server installation, configuration and upgrade process and strategies, and about configure the different security options available in Informix. In addition, learn how to use different types of connections with database server. This tutorial prepares you for Part 1 of the System Administration Certification exam 919 for Informix v11.70.
Articles 24 Apr 2014
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.
Also available in: Chinese   Russian   Portuguese  
Articles 01 Oct 2013
Informix Dynamic Server data compression and storage optimization
Starting with IBM Informix Dynamic Server (IDS) Version 11.50.xC4, you can compress data and optimize storage in IDS databases. The advantages of data compression and storage optimization include significant storage savings, reduced I/O activity, and faster backup and restore. IDS provides full online support for enabling storage optimization and compressing existing table data, while applications continue to use the table. This article provides an overview of IDS data compression and storage optimization functionality and shows you how to perform both tasks.
Also available in: Chinese  
Articles 26 Sep 2013
Non-root installation feature of Informix: Client perspective
Starting with IBM Informix 11.70xC2, Informix started supporting the non-root installation feature. This feature, sometimes called private installation, allows Informix to be installed by a user other than root, and permits 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. This article discusses aspects of this feature in Informix and provides information on how to manage users using JDBC, ESQL/C and ODBC drivers.
Articles 11 Jul 2013
Develop Informix Open Admin Tool (OAT) plug-ins: Backup history
Backups taken with Informix ON-Bar are recorded in a separate database called sysutils. This article explains how to create a plug-in for the Informix OpenAdminTool (OAT) to query and display a list of backups and restores along with additional information such as the date when a backup was verified. This information can be very helpful for administrators who are keeping an overview about the backup history.
Also available in: Chinese  
Articles 20 Jun 2013
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
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.
Also available in: Chinese  
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.
Also available in: Chinese  
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.
Articles 06 Dec 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.
Also available in: Chinese   Vietnamese   Portuguese  
Articles 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.
Also available in: Chinese   Vietnamese   Portuguese   Spanish  
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).
Also available in: Chinese   Russian   Portuguese  
Articles 06 Sep 2012
Informix
Download a trial version of Informix Ultimate Edition or download one of the free editions: Informix Developer Edition (for development use only) or Informix Innovator-C Edition (for small production workloads.)
Also available in: Chinese   Portuguese   Spanish  
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  
Articles 20 Jun 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
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.
Also available in: Chinese   Russian  
Articles 31 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  
Articles 10 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.
Also available in: Chinese   Russian  
Articles 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
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 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  
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  
Articles 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  
Articles 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.
Also available in: Chinese   Russian   Portuguese  
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.
Also available in: Chinese  
Articles 21 Oct 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
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
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: Portuguese  
Articles 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
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  
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.
Also available in: Chinese   Russian   Japanese   Vietnamese   Portuguese   Spanish  
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  
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  
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
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  
Articles 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  
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.
Also available in: Chinese   Portuguese  
Articles 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
Informix DBA: More Musings on Informix 11.7
Lester Knutsen and Art Kagel evaluate some of the advanced capabilities that come with Informix 11.7.
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
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  
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.
Also available in: Chinese   Portuguese  
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. [16 Dec 2010: Updated command in Listing 8. --Ed.]
Articles 16 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  
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.
Also available in: Chinese   Russian  
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  
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.
Also available in: Chinese   Russian  
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.
Articles 19 Aug 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
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
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.
Also available in: Chinese   Portuguese   Spanish  
Articles 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.
Also available in: Chinese   Spanish  
Articles 22 Apr 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).
Articles 18 Mar 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.
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: Russian   Portuguese  
Articles 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  
Articles 25 Feb 2010
Call Me
Examining the role data plays in an ever-changing telecommunications business
Also available in: Chinese   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.
Articles 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  
Articles 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  
Articles 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.
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 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.
Articles 17 Sep 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.
Articles 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.
Articles 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.
Also available in: Chinese  
Articles 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).
Articles 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.
Articles 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.
Articles 16 Jul 2009
Migrating from Oracle 10g to IBM Informix Dynamic Server on Linux, Unix, and Windows
We discuss considerations, and describe a methodology, for migrating from Oracle 10g to the Informix Dynamic Server (IDS). We focus primarily on the basic topic areas of data, applications, and administration, providing information about the differences in features and functionality in areas such as data types, DML, DDL, and Stored Procedures. Understanding the features and functionality of the two products will better enable your decisions as you develop your migration plan. We provide a migration methodology and discuss the processes for installing and using the IBM Migration Toolkit (MTK) to migrate the database objects and data from Oracle to IDS. We also illustrate, with examples, how to convert stored procedures, functions, and triggers. Application programming and conversion considerations are also discussed. The laboratory examples are performed under Oracle 10g and IDS Version 11.5. However, the processes and examples can also be applied to Oracle 7, 8, and 9i.
Redbooks 06 Jul 2009

1 - 100 of 234 results | Next Show Summaries | Hide Summaries Subscribe to search results (RSS)