Filter by products, topics, and types of content

(110 Products)

(134 Topics)

(14 Industries)

(14 Types)

1 - 100 of 207 results | Next
Show Summaries | Hide Summaries
View Results
Title none Type none Date down
Offloading your Informix data in Spark, Part 5: Machine Learning will help you extrapolate future orders
Part 5 of this tutorial series teaches you how to add machine learning to your data to help you extrapolate future orders.
Articles 15 Dec 2017
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  
Articles 25 Oct 2017
Offloading your Informix data in Spark, Part 3: Complex analysis
The third part of this tutorial series goes deeper into joins and more complex queries. Learn how to get data from your Informix database and dump it in Spark so you can leverage it against other data sources and compile advanced analytics all that in Java. The targeted audience is Informix and non-Informix users seeking to bring RDBMS data into Spark.
Also available in: Chinese   Japanese  
Articles 20 Sep 2017
Offloading your Informix data in Spark, Part 1: Collecting the data
Learn how to get data from your Informix database and dump it in Spark so you can leverage it against other data sources and compile advanced analytics all that in Java. The targeted audience is Informix and non-Informix users seeking to bring RDBMS data into Spark.
Also available in: Chinese   Japanese  
Articles 13 Sep 2017
Offloading your Informix data in Spark, Part 2: Basic analysis of your data
Apply what you learned in Part 1 as you start exploiting the data using the Spark dataframe API and understand what a dataframe is.
Also available in: Chinese   Japanese  
Articles 22 Aug 2017
What's new in IBM Security Guardium V10
In Version 10, IBM Security Guardium takes a major step forward with intelligence and automation to safeguard data, enterprise-readiness features, and increased breadth of data sources, including file systems. This article provides an in-depth technical review of all new and changed capabilities including database activity monitoring, vulnerability assessment, and file activity monitoring. This article, originally published in September 2015, was updated to include enhancements for the updates in Version 10.1 (delivered in June 2016).
Also available in: Chinese  
Articles 23 May 2017
Building Scala applications that access IBM Data Servers
Build applications in Scala that access IBM Data Servers like IBM DB2 for Linux, Unix and Windows, IBM DB2 for z/OS, IBM Big SQL, IBM dashDB, and IBM Informix. This article includes sample code and instructions for creating Scala applications that access IBM data servers using IBM Data Server Driver for JDBC and SQLJ. I discuss multiple implementation options as samples of different approaches that you can take to create such applications.
Also available in: Chinese   Portuguese  
Articles 01 Oct 2015
Using IBM Database Add-ins for Visual Studio 2013 in DB2 Cancun (10.5 Fix Pack 4)
This tutorial explains the key new capabilities in IBM Database Add-ins for Visual Studio 2013 available with the DB2 10.5 Fix Pack 4. The authors explain support of the Microsoft Visual Studio 2013 feature set with IBM data servers (DB2 for z/OS; DB2 for i; DB2 for Linux, UNIX, and Windows; and Informix).
Also available in: Chinese  
Tutorial 16 Jul 2015
InfoSphere Data Replication for VSAM for z/OS 11.3 performance improvements
The IBM Hardware Acceleration Lab and the InfoSphere Data Replication for VSAM for z/OS development teams used a CICS VSAM Record-Level Sharing (RLS) workload to measure and improve the performance of InfoSphere Data Replication for VSAM for z/OS 11.1. These improvements were shipped in version 11.3. This tutorial outlines the improvements and the resulting measured performance benefits.
Articles 09 Apr 2015
Leverage DB2 Connect for insert operations in existing C/C++ IBM Data Server applications
This tutorial explains the key best practices when developing C/C++ applications against the IBM Data Servers; (DB2 for z/OS; DB2 for i; DB2 for Linux, UNIX, and Windows; and Informix). It provides details for leveraging several of the features in DB2 Connect that pave the way for better performance and align with best-practice recommendations. You can use this information while developing/enhancing existing applications in C/C++ targeting IBM Data Servers.
Tutorial 20 Feb 2015
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  
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
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
Using InfoSphere Streams with Informix
Learn you how to connect and use Informix as a data source or a data target with InfoSphere Streams. It covers the use of both the Informix-specific protocol and the more general IBM Common Driver protocol that is used by several IBM database products. After reading this article, a reader will be able to use Informix in a Streams environment.
Also available in: Chinese  
Articles 28 Feb 2013
Boost JDBC application performance using the IBM Data Server Driver for JDBC and SQLJ
Developing high performing JDBC applications is not an easy task. This article helps you gain a better understanding of the factors that contribute to your JDBC application performance using the IBM Data Server Driver for JDBC and SQLJ to access DB2 and Informix. Learn to identify these issues and to find and alleviate client-side bottlenecks.
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: Hadoop example: 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 computer.
Also available in: Chinese   Portuguese   Spanish  
Articles 27 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   Russian  
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
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
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
System Administration Certification exam 919 for Informix 11.70 prep, Part 2: Informix space management
In this tutorial, you'll learn how to configure and manage storage spaces on IBM Informix(R) database, the utilities to create those storage spaces, and how to use fragmentation and features to optimize the storage in the database. This tutorial prepares you for Part 2 of the System Administration Certification exam 919 for Informix v11.70.
Also available in: Chinese  
Tutorial 10 May 2012
Create an ER diagram for an Informix database
Understanding the structure of a database is important to administrators as well as to developers. An image illustrates more details within seconds than any textual listing can deliver. This tutorial demonstrates how to use a tool that can deliver an entity-relationship graphical overview of an existing Informix relational database and the contained objects.
Tutorial 26 Apr 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  
Tutorial 22 Mar 2012
System Administration Certification exam 919 for Informix 11.70 prep, Part 4: Performance tuning
Tune IBM Informix(R) database server and its different subsystems for optimum performance. After an overview, follow along with examples on how to look at the database server and its subsystems. Learn about important database optimization elements, including checkpoints, recovery, physical logging, logical logging, asynchronous I/O VP, network parameters, disk resources, CPU VP resources, PDQ, memory grant manager, scan threads, index creation, statistics maintenance, and self tuning. Use this tutorial, the fourth in a series of eight tutorials, to help prepare for Part 4 of the Informix 11.70 exam 919.
Also available in: Chinese   Portuguese  
Tutorial 01 Mar 2012
System Administration Certification exam 919 for Informix 11.70 prep, Part 3: System activity monitoring
In this tutorial, you'll learn about IBM Informix(R) database tools, the utilities to monitor the database, and how to diagnose problems. Learn how to use the system-monitoring interface (SMI) and the SQL administration API. This tutorial prepares you for Part 3 of the System Administration Certification exam 919 for Informix v11.70.
Also available in: Chinese   Portuguese  
Tutorial 28 Dec 2011
Accelerate Hibernate and iBATIS applications using pureQuery, Part 1: Enable static SQL and heterogeneous batching for Hibernate applications
When extended with the downloadable IBM Integration Module, the IBM Optim pureQuery Runtime simplifies the process of generating DB2 static SQL for Hibernate and iBATIS applications. It does this without requiring changes to your application code or gathering SQL from production workloads. The Optim pureQuery Runtime also enables Hibernate and iBATIS applications that access DB2 or Informix to benefit from the heterogeneous batching feature in pureQuery. This article is part one of a four-part series about using the IBM Integration Module with Hibernate applications. This article includes a downloadable sample application that illustrates how you can easily enable static SQL and heterogeneous batch functions with Hibernate applications. The article also provides informal elapsed time performance measurements. Part 2 focuses on iBATIS applications.
Also available in: Chinese   Russian   Portuguese  
Articles 21 Oct 2011
SYSDBOPEN: A flexible way to change session behavior in Informix
The procedures sysdbopen() and sysdbclose() can help database administrators to set environments to activate user tracing, handle short lasting locks on data records or change the reading behavior of sessions. This article shows how to create a sysdbopen() procedure that can dynamically be changed without recreation of the procedure. The benefit of this is to avoid any downtime, if session environments have to be adjusted.
Also available in: Russian  
Articles 22 Sep 2011
SQL compatibility in CLPPlus
CLPPlus provides essential functionality for users migrating scripts from PL/SQL to IBM DB2, as well as many new features that enable DB2 and Informix users to create formatted reports and perform common tasks quickly and efficiently. In this article, get started with CLPPlus and explore the support for PL/SQL dialects. Also learn how easy it is to format reports and set up scripts for common tasks. Finally, the article explains how to use AUTOTRACE with CLPPlus to get information for performance tuning, using the SQL Buffer Utility for developing large SQL blocks, and using spooling to assist in developing scripts.
Also available in: Chinese  
Articles 01 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  
Tutorial 18 Aug 2011
Use Informix ODBC Driver with an ODBC Driver Manager
Because there are many different types of ODBC Driver managers available in today's market, many users find it complicated to configure the IBM Informix ODBC Driver to work with third-party driver managers such as UnixODBC, Progress DataDirect, or iODBC. This article describes the components used by an ODBC application and provides a quick reference of the configuration parameters needed to set up IBM Informix ODBC with a third-party ODBC Driver Manager.
Also available in: Chinese  
Articles 04 Aug 2011
Informix DBA: Informix Warehouse Accelerator
The Informix Warehouse Accelerator combines new data warehouse technology with traditional relational database technology. Learn how the author's benchmark went from 9 hours and 40 minutes to just over 15 minutes using this new technology.
Also available in: Chinese  
Articles 01 Aug 2011
What's new in Informix MACH 11 high-availability features for secondary servers
IBM Informix Version 11.50.xC6 brought several enhancements for Informix multi-node active clusters for high availability, called MACH 11. In this article, get an overview of some of the new features, such as the ability to stop or suspend replication in the Informix cluster environment, and the capability to perform an external backup on a remote standby secondary server. You'll also learn how to avoid blocking checkpoints on primary servers in a high-availability data replication (HDR) environment. The article includes detailed steps for implementing the new enhancements, as well as explaining how they work. A frequently asked questions section at the end will answer any lingering questions.
Also available in: Chinese  
Articles 21 Jul 2011
Recommended practices for using Cognos with Informix, Part 2: Deploy Informix with IBM Cognos BI Server 10
Connecting your Informix databases to IBM Cognos Business Intelligence software gives you a way to unleash the power of your data with expanded query, reporting, and analysis capabilities. If you're ready to take that step, this two-part tutorial series gives you the information you need to install, configure, and deploy the necessary components to achieve the best results. Part 1 showed how to get started with using IBM Cognos Express V9 together with IBM Informix V11.5 as a content store and data source. In Part 2, you'll get the same level of detail for deploying Informix with IBM Cognos BI Server V10. The tutorials include recommended practices for each step along the way, based on lessons learned from real-world deployments on the Windows operating system.
Also available in: Chinese   Portuguese  
Tutorial 07 Jul 2011
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
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   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
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  
Tutorial 17 Mar 2011
OpenJPA caching with WebSphere eXtreme Scale, Informix, and DB2, Part 1: Caching POJOs with hellojpa
OpenJPA is an Apache persistence project. One elegant feature of OpenJPA lets you speed up your lookups and reduce the load on back-end databases with a Java Cache with NO application code changes! This article will show you how to install, configure, and experiment with IBM WebSphere eXtreme Scale (XS) product in conjunction with OpenJPA. You can experiment with this without spending any cash, as the XS cache is available for free evaluation.
Also available in: Chinese  
Articles 10 Mar 2011
Storage provisioning in Informix
Storage provisioning, a new feature in Informix 11.7, makes storage management much easier. With this new functionality, DBAs don't have to monitor Informix in order to anticipate when an application might deplete storage. Now Informix can automatically allocate storage to containers whenever a database requires additional space. In this article, learn how to implement this functionality.
Also available in: Chinese  
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  
Tutorial 17 Feb 2011
Data Manager: DHL Mexico Follows the Money
Merv Adrian tells how DHL Mexico used Informix to realize multiple IT-related benefits.
Also available in: Chinese  
Articles 14 Feb 2011
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
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
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
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
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 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
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 the IBM Data Server .NET Provider for Informix
The IBM Data Server .NET Provider supports application development for IBM Informix. It is available for download as part of the Informix Client Software Development Kit (SDK). This article describes the two .NET providers that support .NET application development for Informix, and highlights the benefits of using the Data Server .NET Provider. The article also provides examples to help you quickly get started using the IBM Data Server .NET Provider.
Also available in: Chinese  
Articles 22 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
Generate formatted reports for IBM data servers using CLPPlus
It's easy and simple to generate reports from a command line with the new tool called CLPPlus, introduced in DB2 9.7. Now database users can generate complex and neatly formatted reports using its advanced report generation facilities. The ability to connect to all IBM data servers makes CLPPlus suitable and consistent for database administrators, developers, and users who work across multiple IBM data servers, including DB2 for Linux, UNIX, and Windows, DB2 for z/OS, and Informix. In this article, get the details on important report formatting options supported by CLPPlus, and learn how to create reports by following the examples.
Also available in: Chinese   Spanish  
Articles 10 Jun 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  
Tutorial 29 Apr 2010
Using Optim with Informix Dynamic Server, Part 1: Configure Informix Dynamic Server to work together with Optim Solutions
IBM Informix Dynamic Server, with its copious feature set, meets or exceeds expectations for a high-performing, scalable, reliable, maintainable database server for enterprise applications. However, if you need to segregate older data and maintain it in such a way that it is easily accessible for reporting or strategic decision making, you may want to consider implementing it with IBM Optim Solutions. Optim lets you archive historical data from various database systems supporting an application and restore data from these archives in the production environment if needed, masking production data and making it available for reliability and application quality testing. In this tutorial, learn how to configure Informix Dynamic Server with Optim Solutions. In Part 2 of this series, you'll walk through some scenarios showing you how using Optim Data Privacy Solution with Informix can help you solve real-world problems.
Also available in: Chinese   Spanish  
Tutorial 22 Apr 2010
Integrated Data Management: Managing data across its lifecycle
The Optim portfolio from IBM focuses on realizing Integrated Data Management with innovative delivery of application-aware solutions for managing data and data-driven applications across the lifecycle, from requirements to retirement. This overview article explains both the vision and reality of Integrated Data Management and how you--whether you are a data architect, developer, tester, DBA, or data steward--can use IBM solutions today to respond quickly to emerging opportunities, improve quality of service, mitigate risk, and reduce costs. [Updated 2010 Apr: This article is updated to reflect changes in product names and functionality that occurred between 2009 June and 2010 April.]
Also available in: Chinese   Russian   Spanish  
Articles 15 Apr 2010
Using data file abstraction with external tables in Informix Dynamic Server
Starting with IBM Informix Dynamic Server (IDS) 11.50.xC6, you can use the external table feature to easily perform load and unload operations. In this article, learn how this feature provides an easy and intuitive way to unload and load data using an SQL interface. Applying table abstraction to the underlying data file makes it easier to seamlessly apply SQL operations. Also, various formats, delimiters, and date and money formats accommodate the data files that may come from any data source and from any geographic location.
Articles 18 Mar 2010
Informix Enterprise Replication made easy with OpenAdmin Tool
IBM Informix Dynamic Server (IDS) is a powerful database with many useful built-in features. One such feature is the ability to send data committed on one server to another server automatically. Now you can use a Web browser to configure and monitor this Enterprise Replication (ER) feature using the OpenAdmin Tool (OAT).
Articles 18 Mar 2010
Automate small footprint, embedded Informix Dynamic Server deployments
This tutorial shows you how to automate IBM Informix Dynamic Server (IDS) small footprint deployments by using the IDS deployment utility and the IDS embeddability toolkit. An important requirement of an embedded database system is that it be invisible to end users and administrators. IDS is a perfect database system for application environments that require an embedded database because you can install, deploy, and administer the database silently. It is transparent to users that there is a robust and reliable database system catering to the database requirements of the application.
Also available in: Portuguese  
Tutorial 11 Mar 2010
Protect your data with Secure Sockets Layer support in Informix Dynamic Server, Part 1: Setting up SSL support in IDS
Learn how to use the Secure Sockets Layer (SSL) feature of IBM Informix Dynamic Server 11.50 to encrypt data in transit from client to server.
Also available in: Portuguese  
Articles 10 Mar 2010
Automatically extend dbspaces in Informix Dynamic Server 11.5
As productive databases containing important information systems rapidly grow larger and larger, automated space management becomes more and more important. This article shows you how to avoid out-of-space situations by using existing features of Informix Dynamic Server (IDS) to implement space management functionality. IDS 11.5 delivers a system database called SYSADMIN that includes administrative stored procedures and an integrated DB scheduler. Together, the stored procedures and scheduler enable the database server to execute database functions and procedures at predefined times. You can use the scheduler to continuously monitor all Informix dbspaces, and to extend space when necessary. The article features a sample program that demonstrates how you can implement this function.
Also available in: Russian  
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
Highlights from developerWorks Information Management in 2009
Take a look at some of the great content published on developerWorks Information Management in 2009.
Articles 18 Dec 2009
Use REALbasic to develop Informix Dynamic Server database applications on Mac OS
In this tutorial, see how to develop IBM Informix Dynamic Server (IDS) database applications for Apple Mac OS using REALbasic. REALbasic is a cross-platform programming language and development platform that you can use to write a single application code base and deploy it on Mac as well as Linux and Windows platforms. This tutorial shows you how to develop REALbasic database applications on Mac OS that leverage the functionality of IDS on the Mac OS platform.
Tutorial 14 Dec 2009
Informix Dynamic Server 11.50 Fundamentals exam 555 Certification Preparation, Part 5: Using SQL
This tutorial is the fifth in a series of tutorials designed to help you become familiar with all the different aspects of IBM Informix Dynamic Server (IDS) and help you get ready for the IDS Fundamentals Certification exam. This tutorial covers the use of SQL to manipulate data.
Also available in: Portuguese  
Tutorial 19 Nov 2009
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 9: Informix replication technologies
This is the last tutorial in a series of nine tutorials to help you prepare for the Informix Dynamic Server (IDS) 11.50 Fundamentals certification exam 555. This tutorial discusses replication technologies and provides an overview of high availability technologies available in IDS. Learn the difference between High Availability Data Replication and Enterprise Replication, and follow the steps for how to set up an IDS server for replication and high availability.
Tutorial 17 Sep 2009
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 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.
Tutorial 03 Sep 2009
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 3: DBMS instances and storage objects
This tutorial is the third in a series of nine tutorials designed to help you become familiar with all the different aspects of IBM Informix Dynamic Server (IDS) and help you get ready for the IDS Fundamentals Certification exam. In this part, which corresponds with Part 3 of the exam, learn how to identify and connect to IBM Informix database servers and databases. Learn also how to create and configure database storage objects, and gain an understanding of system databases and system catalog tables.
Also available in: Chinese  
Tutorial 27 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.
Tutorial 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
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.
Articles 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.
Articles 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  
Articles 27 May 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.
Articles 16 Apr 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.
Articles 16 Apr 2009
Get started using IBM Data Studio Developer with Informix Dynamic Server
Get an introduction to IBM Data Studio and the IBM Data Studio Developer offering, and see how IBM Data Studio Developer 2.1 can be used to develop applications with Informix Dynamic Server (IDS).
Tutorial 09 Apr 2009
1 - 100 of 207 results | Next
Show Summaries | Hide Summaries