Guy Bowerman is an Informix architect, responsible for embeddability, virtualization and cloud computing. This blog covers pretty much anything related to Informix. The postings on this site are his own and do not represent positions, strategies or opinions of IBM.

The rise of Informix

IDS license revenue grew by double digits in the first half of 2006

Important security fixes announced

Bay Area - Informix Tech Fair - Free!

FREE Informix Tech Fair

September 14, 2006


Topics:
• IDS 10.00 Features
• Application Development
• High Availability Data Replication (HDR)
• SQL Optimizer
• Much more..


IBM Informix Advanced Support & Development Speakers:

Ajay Gupta, Guy Bowerman, Joaquim Zuzarte, Santosh Sajip, Suma Vinod, Vijay Lolabattu

Technology Demos

Come and see demos integrating several application technologies.

Free Consulting

Having a problem or question about Informix? Talk to an engineer and get free advice about your specific issue. Time is limited.

WHEN: September 14, 2006 9:15am - 4:30pm

WHERE:
IBM San Jose
4400 N 1st St, Suite 100
San Jose, CA 95134

Directions

COST: FREE

RSVP: sumam@us.ibm.com

Setting up HDR on a single instance - new article..

Plug for IDUG EU 2006

Solano is Documented!

Dynamic Server has the ability to host a JAVA application server, such as an EJB container or custom HTTP server,
within the database server by using a Solano-style database server connection string. For example:

jdbc:informix-direct:/stores_demo:user=user;password=passwd;

If you use a Solano-style connection string, a Java UDR can run in the data server and communicate with both the 
database server and its own client connections (for example by listening on a port and communicating with web 
browsers). This can lead to performance benefits and greatly extends the functionality of Dynamic Server.

Unofficial oninit blog

ESQL/C script for Cygwin GCC - final

#!/usr/bin/sh
CC=gcc
OTHERARGS=
CFILES=
ECFILES=
USAGE="Usage: esql script for gcc on Windows, use this like esql.exe.."

if [ $# -lt 2 ] ; then
    echo "$USAGE"
    exit 1
fi

if [ -z $INFORMIXDIR ] ; then 
    echo INFORMIXDIR not set
    exit 1
fi

for i in "$@"
do
    case "$i" in
    -ansi|-thread|-n|-nowarn)  # pass some flags to pre-processor
          ECFILES="$ECFILES $i";;
    *\.ec)  # select .ec file arguments for pre-processing
          BASE="$(basename "$i" .ec)"
            CFILES="$CFILES $BASE.c"
            ECFILES="$ECFILES $i";;
    *)    OTHERARGS="$OTHERARGS $i";; # other arguments go to compiler
    esac
done

# pre-process .ec files
eval esql -p $ECFILES || exit 1

# pass processed files to compiler
eval $CC -I$INFORMIXDIR/incl/esql $CFILES $OTHERARGS \
   $INFORMIXDIR/lib/isqlt09a.lib $INFORMIXDIR/lib/igl4n304.lib \
   $INFORMIXDIR/lib/iglxn304.lib $INFORMIXDIR/lib/igo4n304.lib -mno-cygwin

Review of recent Informix developerWorks articles

• A step-by-step how-to guide to install, configure, and test a Linux, Apache, Informix, and PHP server
  - a concise and detailed getting started guide to LAIP (or is that PAIL)
• Put yourself on the map with Google Maps API, DB2/Informix, and PHP on Linux
  - add geospatial bells and whistles to your plain looking application
• RedBook: Developing PHP Applications for IBM Data Servers
  - has a chapter on Informix
• Executing a stored procedure through a WebServer
  - I'm not a fan of ASP but this technote looks useful..

• How to enable JDBC tracing starting with JDBC version 3.0.x
  - useful support article for troubleshooting
• Writing XA applications for IDS
• DB-Access Utility for Windows to allow for connectivity to IDS version 9.40.xC2
  - about the standalone dbaccess tool

• Migrating to IBM database servers gets easier with the latest MTK release
  - New features in the IBM Migration Toolkit V1.4
• Informix Dynamic Server and Linux -- Up and running
  - A cookbook for installing Linux and IDS

Improved Windows ESQL/C script for GCC

#!/usr/bin/sh
CC=gcc

for i in $@ ; do
    # handle '-ansi' argument
    if [ $i = "-ansi" ] ; then
        ECFILES="$ECFILES $i"
    # '-thread' multi-threading support
    elif [ $i = "-thread" ] ; then
        ECFILES="$ECFILES $i"
    # '-n' suppress logo display
    elif [ $i = "-n" ] ; then
        ECFILES="$ECFILES $i"
    # handle '-nowarn' argument
    elif [ $i = "-nowarn" ] ; then
        ECFILES="$ECFILES $i"
    # other arguments starting with '-' will go to CC
    elif [ ${i:0:1} = "-" ] ; then
        OTHERARGS="$OTHERARGS $i"
    # select .ec file arguments for pre-processing
    else BASE="`basename $i .ec`" 
        if [ $BASE != $i ] ; then
            CFILES="$CFILES $BASE.c"
            ECFILES="$ECFILES $i"
            if [ $i = $1 ] ; then
                EXEFLAG="-o $BASE.exe"
            fi
        else OTHERARGS="$OTHERARGS $i"
        fi
    fi
done

# pre-process .ec files
esql -p $ECFILES

# pass processed files to compiler
$CC $EXEFLAG -I$INFORMIXDIR/incl/esql $CFILES $OTHERARGS \
   $INFORMIXDIR/lib/isqlt09a.lib $INFORMIXDIR/lib/igl4n304.lib \
   $INFORMIXDIR/lib/iglxn304.lib $INFORMIXDIR/lib/igo4n304.lib -mno-cygwin

Compiling ESQL/C programs on Windows using GCC

1. Pre-process the .ec file using esql.exe with the -p option to pre-process only.
2. Compile the .c file using gcc, specifying the Client SDK link libraries.

esql -p $1.ec
gcc -o $1.exe -I$INFORMIXDIR/incl/esql $1.c $INFORMIXDIR/lib/isqlt09a.lib \
   $INFORMIXDIR/lib/igl4n304.lib $INFORMIXDIR/lib/iglxn304.lib \
   $INFORMIXDIR/lib/igo4n304.lib

esql -p $1.ec
gcc -o $1.exe -I$INFORMIXDIR/incl/esql $1.c $INFORMIXDIR/lib/isqlt09a.lib \
   $INFORMIXDIR/lib/igl4n304.lib $INFORMIXDIR/lib/iglxn304.lib \
   $INFORMIXDIR/lib/igo4n304.lib -mno-cygwin

Connecting with an invalid username can be slow on Windows

Notes from Shibuya

Informix JDBC Connection Pool - a minimalist tutorial

IFMX_CPM_MAX_CONNECTIONS = -1
IFMX_CPM_INIT_POOLSIZE = 0
IFMX_CPM_MIN_POOLSIZE = 8
IFMX_CPM_MAX_POOLSIZE = 80
IFMX_CPM_SERVICE_INTERVAL =  100
IFMX_CPM_AGELIMIT = 7200
IFMX_CPM_MIN_AGELIMIT = 3600

INFORMIXSERVER = myserver
USER = informix
PASSWORD = mypasswd
DATABASE = stores_demo
IFXHOST= mymachine
PORTNO = 1526

import java.io.*;
import javax.naming.*;
import com.informix.jdbcx.*;

public class regcp {
public static void main(String[] args)
{
   try {
      // Initialize context for datasource registry
      System.setProperty(Context.INITIAL_CONTEXT_FACTORY, 
         "com.sun.jndi.fscontext.RefFSContextFactory");
      System.setProperty(Context.PROVIDER_URL, "file:c:/temp");
      Context registry = new InitialContext();

      // create a new connection pool data source, read the properties file
      // and bind it to a name
      IfxConnectionPoolDataSource cpds = new IfxConnectionPoolDataSource();
      FileInputStream cpdsPropFile = new FileInputStream("myCPDS.prop");
      cpds.readProperties(cpdsPropFile);
      registry.rebind("myCPDS", cpds);
      System.out.println("Connection Pool Data Source myCPDS registered.");
   
      // create a new datasource and set the name to the connection pool
      // datasource name
      IfxDataSource ds = new IfxDataSource();
      ds.setDataSourceName("myCPDS");

      // bind a name to the datasource and it is ready to use
      registry.rebind("myDS", ds);
      System.out.println("Data Source myDS registered.");
   }
   catch(Exception e)
   {
      System.out.println("Exception: " + e.getMessage());
   }
}
}

import java.sql.*;
import javax.sql.*;
import javax.naming.*;

public class doconnect {
public static void main(String[] args)
{
   try {
      // initialize context and look up datasource
      System.setProperty(Context.INITIAL_CONTEXT_FACTORY,
          "com.sun.jndi.fscontext.RefFSContextFactory");
      System.setProperty(Context.PROVIDER_URL, "file:c:/temp");
      Context initCtx = new InitialContext();
      DataSource ds = (DataSource) initCtx.lookup("myDS");

      // now start getting connections from the connection pool
      Connection con = ds.getConnection();
      if (con != null) System.out.println("Connection established");

      // do work here...

      // "closing" a connection sends it back to the pool
      con.close();
   }
   catch(Exception e)
   {
      System.out.println("Exception: " + e.getMessage());
   }
}
}

Scripting Dbaccess

dbaccess mydb sql_file.sql

dbaccess - sql_file.sql

dbaccess - -

echo select col1 from tab1 | dbaccess mydb

#!/bin/sh
dbaccess - <<EOF
create database test;
create table t1(col1 serial, col2 char(20));
insert into t1 values(0, "hello");
select * from t1;
close database;
drop database test;
EOF

echo create database test; ^
create table t1(col1 serial, col2 char(20)); ^
insert into t1 values(0, "hello"); ^
select * from t1; ^
close database; ^
drop database test | dbaccess -