Discover Informix - The data server with the most flexible cluster and replication technology on the market and the lowest TCO

Simple password encryption

Here’s a blog post on something I didn’t even know existed until recently: Informix simple password encryption. This does what it says in the tin and nothing else: it encrypts the password you use to authenticate to the database server which is sent in the clear otherwise. If you weren’t aware of this then it’s certainly worth reading on!

mholzbauer's picture

Extendable BUFFERPOOLs in 12.10.xC3 and higher..

starting with 12.10.xC3 the BUFFERPOOL configuration parameter has now two formats:

 

1) Use the BUFFERPOOL configuration parameter with the memory field if you

     want to specify the size of your buffer pool in units of memory like KB, MB or GB.

2) Use the BUFFERPOOL configuration parameter with the buffers field if you

     want to specify the size of your buffer pool in units of pages, or to retain

     settings from a previous release.

 

mholzbauer's picture

PLOGSPACE in 12.10.xC3 and higher / Physical log AUTO TUNING

from the manual:

 

Plogspace

 

A plogspace is a logical storage unit that is composed of one chunk that stores the

physical log. When the physical log is in the plogspace, the database server

increases the size of the physical log as needed to improve performance.

 

eherber's picture

Informix Newsletter August 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

Auditing and onaudit

Compliance is one of those things you can hardly ignore as a DBA these days. Whether it’s a PCI-DSS, financial or internal best practice audit, at some point someone is going to ask you whether you are using database auditing. In my experience the auditors struggle to ask Informix specific questions but this is one that always comes up.

I guess there are three answers to this question:

eherber's picture

Informix Newsletter Juli 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

eherber's picture

Informix Newsletter Juni 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

Large parallel index builds and temp space

This is a quick post about parallel index builds. Today I was building with PDQPRIORITY a unfragmented detached index on a large table fragmented by range with ten large fragments and I saw this message in the online log:

10:28:53 WARNING: Not enough temp space for parallel index build.
Space required = 110566014 pages; space available = 8385216 pages.
Partial index build started.

You can see I am quite a long way short of the temp space required here; I need just over thirteen times more.

eherber's picture

Informix Newsletter Mai 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

gproctor's picture

Constructing the IoT solution – A Joint IBM & Intel Webcast May 28