Filter by products, topics, and types of content

(109 Products)

(140 Topics)

(12 Industries)

(14 Types)

1 - 100 of 132 results | Next
Show Summaries | Hide Summaries
View Results
Title none Date down
Offloading your Informix data in Spark, Part 4: Leverage data against other data sources
In Part 4 of this tutorial series, you'll learn how to link external and public data to your existing data to gain insights for your sales team. In this scenario for retail sales, you'll learn how to forecast the hot sales areas for new wins.
Also available in: Chinese  
25 Oct 2017
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   Russian  
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.
24 Apr 2014
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  
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.
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  
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.
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.
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  
04 Apr 2013
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  
01 Jul 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  
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  
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.
Also available in: Chinese   Russian  
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  
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  
22 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  
02 Feb 2012
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  
25 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  
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  
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  
21 Jul 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  
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   Portuguese   Spanish  
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  
02 May 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  
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  
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  
24 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  
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  
03 Mar 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  
14 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  
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  
10 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.]
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  
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  
02 Dec 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  
18 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  
03 Nov 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  
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.
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.
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  
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  
30 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  
15 Jul 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.
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).
18 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  
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  
25 Feb 2010
Call Me
Examining the role data plays in an ever-changing telecommunications business
Also available in: Chinese   Russian  
22 Jan 2010
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.
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.
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.
22 Oct 2009
Using IBM InfoSphere Guardium Encryption Expert to protect your sensitive data
IBM InfoSphere Guardium Encryption Expert provides features to encrypt and control access to data written to file systems and database backup images. Beginning with Version 1.1 Fix Pack 3, the product supports both DB2 and Informix Dynamic Server (IDS). This article describes some of the key features and mechanisms of InfoSphere Guardium Encryption Expert and shows you how to use them.
02 Jul 2009
Configure WebSphere Application Server Community Edition with Informix Dynamic Server
Combine WebSphere Application Server Community Edition with IBM Informix Dynamic Server for a stable, easy to install and use application server for developing and testing J2EE applications with a robust, highly reliable, administration-free database with outstanding performance.
28 May 2009
Pure Concentrated Data
This article reviews recent Informix enhancements, including tools to help customers model, schedule, and execute the data transformation and data flows required to create data warehouses. Most recently, IBM also announced new data compression and consolidation features that reduce the cost (and boost the performance) of both BI and OLTP applications on IDS.
Also available in: Chinese  
27 May 2009
Integrate Informix ODBC applications on Mac OS X with Informix Dynamic Server, Part 1: Installing and registering the ODBC bundle driver graphically
Learn about the new Mac OS X ODBC features available with Informix(R) Client-SDK and Connect 3.50.xC3. In Part 1 of this 2-part series, see how the ODBC features integrate fully with native Mac OS X applications. In Part 2, you'll follow a series of detailed walkthroughs using FileMaker Pro and OpenOffice.org.
16 Apr 2009
Integrate Informix ODBC applications on Mac OS X with Informix Dynamic Server, Part 2: FileMaker Pro and OpenOffice.org walkthroughs
Learn about the new Mac OS X ODBC features available with Informix(R) Client-SDK and Connect 3.50.xC3. Part 1 of this 2-part series described how the ODBC features integrate fully with native Mac OS X applications. In Part 2, follow detailed walkthroughs using FileMaker Pro and OpenOffice.org.
16 Apr 2009
Expand transaction capabilities with savepoints in Informix Dynamic Server (IDS)
This article describes how to use savepoints within transactions on IBM Informix Dynamic Server (IDS). It also explains how you can manage savepoints with various clients, such as ESQL/C and JDBC, and in different environments, such as stored procedures.
26 Mar 2009
Configure Linux shared disks for Informix Dynamic Server MACH 11
Find out how to configure true shared disks for IBM Informix Dynamic Server (IDS) Version 11.50. This article contains instructions on how to get an IDS Shared Disk (SD) secondary server up and running on Ubuntu Linux. You can also easily adapt the instructions for other Linux distributions.
Also available in: Chinese   Russian   Japanese  
05 Mar 2009
Deploy 4GL functions as Web services
Learn how IBM Informix 4GL functions can be deployed as Web services. Get an overview of a user interface (UI) tool called 'w4gl' and a back-end tool called 'w4glc' that is in-turn used by the 'w4gl'.
Also available in: Chinese   Japanese   Spanish  
12 Feb 2009
Create IBM Data Web Services using IBM Database Add-Ins for Visual Studio
Learn how the IBM Database Add-Ins for Microsoft Visual Studio tool set supports IBM data server Web services development. Walk through the creation of a data Web service, and see how it can be deployed to easily access IBM DB2 or IBM Informix from your Web applications.
Also available in: Chinese  
02 Feb 2009
IDS and ClusterIT -- How to set up Informix in a Microsoft Cluster Environment
Use the ClusterIT utility to easily set up an Informix server in a Microsoft Cluster Environment. Walk through the procedure with explanations and the meaning of all required parameters and set up your IDS in MSCS within 10 minutes.
08 Jan 2009
Access heterogeneous data using Informix Enterprise Gateway Manager with ODBC or DRDA
In this article, learn how you can query data across heterogeneous data sources using IBM Informix Enterprise Gateway with ODBC and DRDA. After a brief introduction to the architecture and configuration of the gateway, learn how to establish a connection between Informix Dynamic Server client applications and other databases such as IBM DB2, IBM solidDB, Oracle, and SQL Server. This article explains some of the utilities that act as an interface between the gateway daemon and the client application, and also highlights various advantages of the Informix Enterprise Gateway.
23 Oct 2008
Understand the Informix Dynamic Server B-tree scanner
Gain a better understanding of how the B-tree scanner works and learn techniques for leveraging this feature to achieve optimum transaction processing performance.
Also available in: Russian  
09 Oct 2008
Using single sign on authentication with Informix Dynamic Server
IBM Informix Dynamic Server (IDS) 11.50 supports Single Sign-On (SSO). SSO simplifies user authentication by sharing authentication data and requires that the user enters the password just once to access all applications and network resources. In this article, learn about the Kerberos environment and follow step-by-step instructions for SSO configuration for an IDS server in Linux and UNIX.
Also available in: Chinese  
04 Sep 2008
Build plug-ins for IBM's OpenAdmin Tool for Informix Dynamic Server
Jump start building custom modules and sharing them as plug-ins using the Plug-in Manager through the development and creation of an example plug-in for the OAT.
14 Aug 2008
Technical tip: Set up global JNDI mapping for Informix JDBC/JCC connection pooling with Tomcat
Over the years the popularity of Apache Tomcat has picked up, and so has Informix Dynamic Server. Many users are eager to use these two products together, and in fact are trying to combine and integrate them, but face a few issues in the process. In this article, you’ll learn how to solve these problems as you follow the steps to configure the JNDI DataSource on Tomcat for Informix Dynamic Server.
Also available in: Japanese  
07 Aug 2008
Manage your Informix database with the IDS OpenAdmin Tool, Part 3: Performance analysis of Informix Dynamic Server made easy through the OpenAdmin Tool
Learn how to analyze IBM Informix Dynamic Server (IDS) performance using the IDS OpenAdmin Tool (OAT). OAT is an open source, Web-based interface to IDS and is supported on version 11.10 and later. Parts 1 and 2 of this series introduced the tool and showed you how to migrate from the Informix Server Administrator. Now, see how easily you can monitor performance through statistical data and charts that give you a quick way to comprehend the information.
17 Jul 2008
Manage your Informix database with the IDS OpenAdmin Tool, Part 1: Configuring and using the OpenAdmin Tool with IDS
IBM Informix Dynamic Server (IDS) is well known for ease of administration. To make server administration more user friendly, a new open source, platform-independent tool called OpenAdmin Tool (OAT) is now available to IDS users The OpenAdmin Tool provides graphical interface for administrative tasks and performance analysis tools. Introduced with IBM Informix Dynamic Server version 11.10, it is a PHP-based, Web browser administration tool that gives you the ability to administer multiple database server instances from a single location. This article highlights some of the most useful features of OAT and helps you get started.
Also available in: Chinese   Russian  
10 Jul 2008
Manage your Informix database with the IDS OpenAdmin Tool, Part 2: Migrate from Informix Server Administrator to the IDS OpenAdmin Tool
Migrate from the Informix Server Administrator (ISA) to the OpenAdmin Tool. Also, learn about the basic capabilities of ISA that are made available on OAT, along with enhanced functionalities and greater ease-of-use.
Also available in: Chinese   Russian  
10 Jul 2008
Replication technologies in Informix Dynamic Server
IBM Informix Dynamic Server (IDS) has long been a database with powerful replication technologies. Enterprise Replication (ER) and High-Availability Data Replication (HDR) have been faithfully serving customers for years. Recent versions of IDS, 11.1 and now 11.5, add some new technologies to these stalwarts: the Remote Standalone secondary and the Shared-Disk secondary servers. In this article, get a brief characterization of each replication technology and details on the basics of using each.
Also available in: Chinese   Russian  
03 Jul 2008
IBM Migration Toolkit support for migrating data from MySQL to DB2 and Informix Dynamic Server
The IBM Migration Toolkit has been enhanced to include new capabilities for migrating from MySQL to DB2 or Informix. In this article, you'll learn how the toolkit can help you migrate DDL and DML statements, and see how to map data types.
Also available in: Chinese   Russian  
03 Jul 2008
Dynamic SQL support in Informix Dynamic Server Stored Procedure Language
Review the SPL and the capabilities uniquely available with dynamic SQL, and then explore many examples that help you get started with implementing this feature in your own databases. Also, take a look at security issues and see how to avoid pitfalls.
12 Jun 2008
Real-time data acquisition: Connecting your exercise bike to Informix or DB2
Capture data from an analog environment in real time and store it in an Informix Dynamic Server or DB2 database. Use WebSphere Application Server Community Edition to create graphs of captured data and present them in Java Server Pages. All the steps, including the installation and wiring of the magnetic sensors, the computer interface, the client OLTP code, and the JSP code for presentation of results, are presented in an easy-to-follow format.
Also available in: Russian  
27 Mar 2008
Get the most out of Informix Dynamic Server optimizer through UPDATE STATISTICS
Use the UPDATE STATISTICS statement in IBM Informix Dynamic Server (IDS) to get the most out of the database optimizer. Get a brief overview of this SQL statement and see how it can be used for a variety of problems. Discover the importance of updating statistics and view illustrations that show how statistics are gathered. Finally, browse a FAQ section at the end of the article to answer any lingering questions you might have about this important SQL statement.
Also available in: Chinese  
06 Mar 2008
CallableStatement handling using named parameters
Explore a powerful new feature of IBM Informix Dynamic Server (IDS) called "named parameters in a CallableStatement," which enables you to identify a parameter using its name instead of its ordinal position. This feature thus extends the capability of using CallableStatements so that they can be used either by ordinal position or parameter name. Learn the difference between the two techniques, and see the advantages of named parameters over the ordinal technique.
Also available in: Chinese   Russian   Japanese  
21 Feb 2008
Web service development and deployment with Informix Dynamic Server and IBM Data Studio
IBM Data Studio brings Informix Dynamic Server developers the latest in Web services technology. Learn how this new set of tools makes it easy to design, develop, deploy, and manage your IDS applications. Get started with Web services development using the latest methodology, and also learn how you can simulate a Web service response by converting it to presentable HTML format.
Also available in: Chinese  
21 Feb 2008
Create and use functional indexes in Informix Dynamic Server
Database management systems continue to focus on performance as the amount of data continues to grow at a staggering rate. This article focuses on a performance tuning technique called functional indexes. Creating and using functional indexes based on database use statistics can significantly improve the performance of your SELECT queries. See how to create and use funcional indexes in IBM Informix Dynamic Server and maximize the performance of your queries.
Also available in: Chinese  
06 Dec 2007
Column-level encryption in IDS
Protect your sensitive data by using the column-level encryption feature of IBM Informix Dynamic Server 10 and later.
Also available in: Russian  
01 Nov 2007
Work with Informix Dynamic Server V11.10 and IBM Database Add-ins for Visual Studio 2005 V9.5
The IBM Database Add-ins for Visual Studio 2005 allow users working in the Visual Studio 2005 environment to connect to several IBM databases and perform rapid application development, as well as several database operations. The latest release of IBM Database Add-ins for Visual Studio 2005 V9.5 now includes support to connect and work with IBM Informix Dynamic Server V11.10. Get an overview of all the features that have been added to IBM Database Add-ins for Visual Studio 2005 V9.5 to work with Informix Dynamic Server V11.10.
Also available in: Chinese  
18 Oct 2007
Use the Informix Dynamic Server scheduler and SQL API
IBM Informix Dynamic Server 11 (IDS 11) offers new features to assist in automating administration and maintenance tasks. Learn how the new scheduler and SQL API make a DBA's daily tasks easier.
Also available in: Japanese  
27 Sep 2007
System Administration Certification exam 918 for IBM Informix Dynamic Server 11 prep, Part 7: Informix Dynamic Server replication
Configure and manage all forms of replication options available with IBM Informix Dynamic Server (IDS) 11. The seventh in a series of eight tutorials, use this tutorial to help prepare for the IDS 11 exam 918.
26 Jul 2007
Write better distributed queries for Informix data servers
Optimize your queries for the best possible performance when accessing multiple Informix servers. Also, read the optimizer's Explain output and learn how Informix processes distributed queries. Furthermore, recognize inefficiencies in a query execution plan and write queries that avoid these pitfalls.
10 May 2007
Rapid Windows application development with IBM Informix Dynamic Server and IBM Database Add-ins for Visual Studio 2005
IBM introduced the IBM Database Add-ins for Visual Studio 2005 to allow rapid Windows application development, database schema development, and debugging, along with numerous other features. Now, support for Informix Dynamic Server (IDS) is added to this product, allowing IDS application developers to use some of the basic and important Visual Studio functionalities. In this article, you'll be introduced to the functionalities provided by IBM Database Add-ins for Visual Studio 2005 for Informix.
03 May 2007
Data archiving with Informix Dynamic Server table-level restore
Discover the most common options for archiving your IBM IDS data. Learn techniques to retrieve your data from a previously taken backup in order to store it in an independent format, preserved against future changes in your environment.
26 Apr 2007
Using the new Deployment Wizard in IDS Cheetah
Learn about a new wizard coming in the new version of Informix Dynamic Server (code-named "Cheetah") that will let you customize install options to pick and choose the features and functions you want, enabling you to minimize the footprint and control the install with much greater granularity than in the past.
05 Apr 2007
IBM WebSphere Developer Technical Journal: Configuring and using XA in a middleware environment
In today's world of transactions, XA standards are a widely used method for implementing the two-phase commit protocol for achieving reliability, ACID properties, logging, and recovery. Many middleware and database products adhere to the XA protocol to achieve transactional capabilities while interoperating between middleware and resource managers. This article provides a brief overview of what distributed transaction processing (DTP) and XA are all about, explaining concepts such as static and dynamic registration, XA switches, switch-load files, and more, then explains how you can configure various products (IBM and non-IBM) as XA compliant resource managers in a middleware environment. The article concludes with potential coding restrictions and considerations that could be imposed in an XA environment.
Also available in: Chinese  
04 Apr 2007
Non-blocking checkpoints in Informix Dynamic Server
Whether you're an expert or novice DBA, you undoubtedly want to get the best transaction performance from your IDS database. Learn about new features available in IDS V11.1 (codenamed "Cheetah") that help DBAs tune their servers for best transaction performance in an OLTP environment.
Also available in: Russian  
22 Mar 2007
Informix back up with Tivoli Storage Manager: Using OnBar and ontape utility
OnBar and ontape utilities are features and effective tools for back-up and restore operations on Informix databases. TivoliStorage Manager (TSM) is also considered an effective storage management application. Proper combination of these facilities will lead to an optimal strategy and a trusted back-up andrestore framework for Informix database administration. The main motivation of this article is to educate and encourage Informix and TSM users to use the combination and enjoy the features. This document has been prepared in assumption that the readers have basic knowledge of Informix and its underlying operating system. Preferably this document can be used as a pocket handbook for Informix database administrators and system administrators.
Also available in: Russian  
15 Mar 2007
UDR enhancements in IBM Informix Dynamic Server V10
Enhancements to UDR OUT/INOUT parameter modes and return parameter naming feature, available in Informix Dynamic Server Version 10.00, make it easier to return multiple values from user-defined routines.
08 Mar 2007
How to go hand-in-hand with DB2 and Informix
Leverage skills acquired in either Informix or DB2 to learn the other. Compare the technologies and terminologies used in IDS with DB2 9.
Also available in: Chinese  
25 Jan 2007
Informix Dynamic Server locking, Part 2: Tracking and analysis
This is the second part of a two-part article talking about locking mechanisms in the IBM strategic data server, IDS. IDS is an optimal choice for high-end OLTP and embedded solutions. This article helps you to understand locking methodology and to run traces for analyzing lock conflicts in your own IDS environment.
Also available in: Russian   Japanese  
04 Jan 2007
New capabilities for migrating to DB2 and Informix in IBM Migration Toolkit 1.4.9
The latest release of IBM's free migration toolkit, MTK 1.4.9, includes many new features that make migrating to your favorite IBM database even easier - support for more DB2 features, migration support for Oracle PL/SQL to IBM Informix Dynamic Server (IDS), Oracle's UTL_FILE package, and more.
04 Jan 2007
Using Server Studio JE with Informix Dynamic Server
IBM Informix Dynamic Server is well known for its ease of administration. When you combine it with Server Studio, administrative tasks become even easier. Learn how Server Studio's proven tools for DBAs and developers emulate natural workflow and improve your efficiency when performing common database tasks.
Also available in: Chinese  
03 Jan 2007
DB2/Informix and open source: Database defense against the dark political arts
Create a real-time monitor for your database so you can be alerted when problems arise, and also provide valuable information to others about the status of the database servers. The real-time monitor is also an asset for application and network administrators for rapid diagnosis of the root cause.
Also available in: Russian   Japanese  
21 Dec 2006
Cut out the Middle-Man: Use Informix Dynamic Server with J/Foundation to host a Java application service
Informix Dynamic Server user-defined routines can be written in C, Java, and Stored Procedure Language (SPL). A recently documented extension to Java UDR support - codename Solano - is the ability to host a Java application service directly from within the data server.
26 Oct 2006
Flexible fragmentation strategy in Informix Dynamic Server 10.0
IBM Informix Dynamic Server (IDS) 10.0 provides a new fragmentation strategy for DBAs to manage large number of dbspaces. This article highlights new and old fragmentation strategies.
19 Oct 2006
Enable WebSphere MQ messaging in Informix Dynamic Server applications
Eliminate development overhead, and encapsulate integration complexity, by enabling WebSphere MQ messaging in Informix Dynamic Server applications.
Also available in: Russian  
21 Sep 2006
Informix Dynamic Server locking, Part 1: Concepts and mechanisms
Learn about locking methodology and analyze locking conflicts in IBM's strategic data server, IDS. This is the first of a two-part article series talking about locking mechanisms in IDS.
Also available in: Russian   Japanese  
07 Sep 2006
A step-by-step how-to guide to install, configure, and test a Windows, Apache, Informix, and PHP server
Learn how to install, configure, and test a Windows, Apache, Informix, and PHP (WAIP) server. Windows, Apache, Informix, and PHP together form a very powerful and dynamic combination for a Web server.
Also available in: Chinese  
27 Jul 2006
Security information management challenges and solutions
Learn to identify the specific challenges in your own environment, and get on the right track with the task of designing and administering a strong security solution using either DB2 or Informix Dynamic Server. In addition, a handy chart lays out the problems and the solutions, and lists how the solutions are implemented in both Informix and DB2.
Also available in: Chinese  
13 Jul 2006
A step-by-step how-to guide to install, configure, and test a Linux, Apache, Informix, and PHP server
Learn how to install, configure, and test a Linux, Apache, Informix, and PHP (LAIP) server. LAIP provides a very powerful and dynamic mixture for a Web server.
08 Jun 2006
1 - 100 of 132 results | Next
Show Summaries | Hide Summaries