All

IBM Data Management Magazine: Informix Warehouse Accelerator

Nice article about the power of Informix Warehouse Accelerator in combination with the latest IBM hardware MAX5 memory expansion technology:

Supercharging the data warehouse while keeping costs down

Informix Newsletter August 2012

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

  • Aktuelles
  • TechTipp: SQL Statement Cache
  • TechTipp: Optionen des ONSTAT (onstat -g ssc)
  • TechTipp: SMI – Sysmaster Interface – syssqlcacheprof (Stmt. Cache)
  • TechTipp: onmode -e (Statement Cache)
  • TechTipp: ONCONFIG – DBSERVERNAME und Replikation

user secure problem when install informix

Hi everyone!

I have encountered a user secure problem when install two informix database softwares in one machine which power by HP-UX. The version of informix which I installed is 11.50FC4.

The installation of the first informix database is fine at all. It's user account is informix(UID 110) and the group is informix(GID 110). The first database's directory is "/opt/informix". When I began to install another database, I created a new user for the second one. So I issued the follow:

# useradd -u 120 -g 110 -m -d /opt/infor1 -s /usr/bin/csh infor1

DBTA Magazine: Empowering Business Analysts with Faster Insights

Good article that gives a summary of the many benefits that Informix Warehouse Accelerator IWA provides to businesses. The article has been published in the DBTA Magazine and has been written by IBMs Keshava Murthy:

DBTA Magazine: Empowering Business Analysts with Faster Insights

Innovator-C Edition trimmed

You might have already heard the bad news about Informix Innovator-C Edition. IBM has trimmed it down. Instead of 4 cores you can only use a single core. But the really bad news is that HDR/ER are no longer supported in Innovator-C (:-

You'll find more information on this bad news here:

Informix Newsletter Juli 2012

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

  • Aktuelles
  • TechTipp: SPL - Funktion „sleep()“ im SQL
  • TechTipp: Beispiel zu DEFRAGMENT + REPACK + SHRINK
  • TechTipp: ifxcollect – Informationen für den Support
  • TechTipp: SYSDATE und CURRENT
  • TechTipp: Informix Warehouse Accelerator mit Solaris Intel x86

Art Kagel about the Value of Informix and FOT Indexes

Nice article from Art Kagel about the value of Informix and how FOT indexes could increase query performance:

What Is Informix and Why Should I Care ?

It is always good to see Informix in the press. Well done, Art !

60. Workshop der Deutschen Informix User Group (IUG)

(german content)

60. Workshop der Deutschen Informix User Group (IUG)

Der 60. Workshop der deutschen Informix User Group findet am Donnerstag, den 21.06.2012 in Friedrichshafen statt.

Mit bereits (Stand 13.06.2012) 61 angemeldeten Teilnehmern scheint es ein echter Erfolg zu werden. Das freut mich ganz besonders für meine Freunde aus dem IUG Vorstand. Weiter so !

Interview with IBM's Bernie Spang on Informix Growth Strategies

Here is a short interview with Bernie Spang - IBM Director Strategy and Marketing Database Software & System - about growth strategies for Informix.

IBM Informix growth strategies – 3 Point growth plan

The Value of Benchmarks

Here is a nice review about the value of benchmarks and the Informix TPC-C benchmark performed by my namesake Eric Verceletto:

David Norfolk, Bloor: Benchmarks

However I would still like to see a TPC benchmark performed by IBM with Informix. They do it for DB2, why not for Informix ?