In this post we look at methods to define data marts in the Informix Warehouse Accelerator (IWA). IWA is a software appliance for the Informix database server, using in-memory, columnar data storage for business intelligence applications doing OLAP. For such workloads IWA typically can achieve a query acceleration of 10 - 100 times faster than running the workload within the Informix database server.
This feature was introduced in the Informix 12.10.xC10 fixpack release. It allows you to assign a character string to your CSDK or JDBC client session and identify that character string on the database server. This is useful for environments where same userid runs multiple instances of the same application, and there is a need to distinguish one session from the other.
Hopefully you have an established routine of local backups or cloud backups, and you should be sleeping a little better (when you get a chance to sleep). And like fire-drills or other emergency procedures, you are probably practicing a restore of your backups on another server. You have probably discovered, depending on the size of your data and speed of the system, this restore may take hours. Moving from ontape to onbar helped by enabling parallel backup and restore of your dbspaces, but while backups can happen with the lights on, during a restore, the server won’t be accessible until the restore is complete. You may not be able to afford for your applications to be down that long.
The headline here is that BLOBspace BLOBs can now be compressed. We made additional enhancements to partition BLOB compression and the auto-compress feature in general. Details follow.
After closing a busy year for Informix at HCL, I was invited to attend an event at Bytec - a major Informix distributor. This was a year end dinner at the beautiful Lindau in Bodensee, in Bayern, southwest of Germany.
After the party, my friend, Richard Luft picked me up at the hotel in Lindau to kick off a busy day of meetings in Friedrischafen, then Munich, then Stuttgart, and then back to Lindau. I was wondering if we would be able to cover the distance of 650km (400 miles), plus all the meetings, and lunch and coffee gatherings, and be back at the hotel as he promised in 12 hrs. He just smiled and answered “Autobahn”.