Vercelletto.com

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

• Aktuelles
• TechTipp: ONPSM – Primary Storage Manager
• TechTipp: CREATE TABLE AS
• TechTipp: NULLS FIRST / NULLS LAST
• TechTipp: Optionen des ONSTAT (onstat -g cac)
• TechTipp: Einmal eingetragene Werte gegen Veränderung schützen
• TechTipp: CHR()
• WebTipp: Webseite für Feature Requests
• WebTipp: Dokumentationen zur Version 12.10
• Termin: Informix Infobahn 15. Mai 2013 – München
• Termin: 62. IUG Workshop in München
• Versionsinfo: 11.70.xC7W1 ist verfügbar
• Anmeldung / Abmeldung / Anmerkung
• Die Autoren dieser Ausgabe

Informix Newsletter Mai 2013

(german content)

Am Mittwoch, den 15. Mai findet in München die IBM Informix Infobahn 2013 statt. Die diesjährige Infobahn dreht sich primär um die kürzlich erschienene neue Informix Version 12.10.

Der Event findet dieses Jahr in einer urigen Atmosphäre statt: dem weltberühmten Münchner Hofbräukeller.

Nac…

I have no idea how IBM decides what new features to add to Informix, but I do know that we can now be part of the discussion by using the new Request for Enhancement tool (RFE Tool).

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

• Aktuelles
• TechTipp: INFORMIX Version 12.10 – New Features
• TechTipp: Nicht mehr dabei ab Version 12.10
• TechTipp: Vergleich der ONCONFIG zwischen Version 11.70 und 12.10
• TechTipp: ONCONFIG Parameter exportieren / importieren
• TechTipp: ONCONFIG mittels „-FILE“ als Startoption setzen
• TechTipp: SmartBlobSpaces aufräumen
• TechTipp: Optionen des ONSTAT (onstat -g cfg)
• Referenz: Deutsche Luft und Raumfahrt verwaltet mehr als 2 PetaByte an Geodaten
• Versionsinfo: 12.10.xC1 ist verfügbar
• Versionsinfo: 11.50.xC9.W3 ist verfügbar
• Termin: Informix Infobahn 15. Mai 2013 – München
• Termin: 62. IUG Workshop in München
• Freizeit Tipp: Ein Roman aus der IT-Welt, in dem INFORMIX eine wichtige Rolle spielt . .12
• WebTipp: INFORMIX Version 12.1
• Anmeldung / Abmeldung / Anmerkung
• Die Autoren dieser Ausgabe

Informix Newsletter April 2013

(german content)

Ich freue mich Ihnen heute ein brandaktuelles Ebook vorstellen zu dürfen. Es handelt sich um einen spannenden Krimiroman bei dem das Thema Informix eine nicht unwesentliche Rolle spielt. Sie fragen sich sicherlich:

Krimi und Informix – Wie passt das zusammen?

Glücklicherweise handelt es sich nicht um einen erneuten Bilanzierungsskandal Die Informix Veteranen unter Ihnen erinnern sich sicherlich noch an diese dunklen Stunden in den 90er Jahren, die das Unternehmen fast an den Rande des Ruins tr…

This article is written in English and Portuguese (full article here)
Este artigo está escrito em Inglês e Português (artigo completo aqui)

English version:
Very quick post to report a small issue and it’s solution while installing the latest Informix version (12.10) on HP-UX (11.31 – Itanium).
After decompressing the tar file I’ve run ids_install and got the following error:
./ids_install
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
tar: ././@LongLink - cannot create

tar: ././@LongLink - cannot create
tar: ././@LongLink - cannot create
tar: ././@LongLink - cannot create
The included VM could not be unarchived (TAR). Please try to download
the installer again and make sure that you download using 'binary'
mode. Please do not attempt to install this currently downloaded copy.

I verified the package integrity and after some internal and external search I’ve found references to the fact that some versions of native tar command don’t support long file names (the limit of 100 characters is referenced in some sources). A possible solution is to get, install and use the GNU tar (a tar utility made available by the GNU foundation).
I also tried to install 12.10 in Li…

Sometimes you have to store a string of numbers in a CHAR column. Probably because the string of digits represents an account number or something similar and storing as an INTEGER or BIGINT doesn’t really make sense. The account number could have leading zeros that would be lost if stored as an integer. Parts of the account number could store special information, like positions 2,3 and 4 identify what department an account belongs to and it might be useful to be able to select digit_string[2,4]. There are plenty of reasons to store numerical data in a str…

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:
One of the changes in version 12.10 refers to the editions. In each version there are several editions which try to address different markets and usage scenarios. I know for experience that customers don’t like to see changes in editions. But I also am used to see a lot of confusion in the market about which editions exist, and the limits in each one.
One of the best sources to check this is an article on developerworks published by Carlton Doe a long time Informix guru. This page currently only addresses version 11 but accordingly to the webcast where 12.10 was announced, it should be updated soon.

I will not repeat the information here, but to give a very brief overview, some of the changes were:

1. The Growth edition does not exist anymore. We went back to the original name of Workgroup Edition
2. The Ultimate edition does not exist anymore. We went back to the original name of Enterprise Edition
3. The Choice Edition (existed only for Mac and Windows) was removed
4. The Express Edition (previously only in Linux) now exists for all the supported platforms
5. The Editions that were called “Warehouse” changed their names to “Advanced” (Advanced Workgroup Edition…