Often time there is there is a requirement to track when users log-in to a database, how long they were accessing the database and what resources were consumed. This information can be used for auditing or charging for use of a database by the resources consumed by the user.

Accomplishing this is simple and utilizes the sysdbopen/sysdbclose procedures along with the sysmaster database.

The latest version of InfoSphere BigInsights is V1.3, click on PDF file below for more details.

ENUS211-501

“Lost time is never found again.” – Benjamin Franklin

Title: Informix Support for the Popular Columnar Databases
Date: Thursday, December 15, 2011
Time: 11:30 AM - 13:00 PM (Central Time), 17:30h Germany
Presented By: Mark Jamison (IBM)
Registration: Informix Support for the Popular Columnar Databases

Description:

I'm happy to announce a new Informix blog today:

• Informed Mix - Random Postings about IBM Informix

The blog is written by Ben Thompson an UK based Informix DBA with many years of Informix experience.

For your convenience Ben's blog has been added to Informix Zone (right side) and will also be re-published on planetIDS.com.

Show Newsfeed of Ben Thompson

Partitioning or fragmenting large tables is a great Informix feature. The ability to fragment by an arbitrary SQL expression or round robin provides more flexibility than is found in many competing RDBMSs.

One thing it never catered for that well though was large log tables that include a timestamp of some description. Most database schemas I have seen have at least one of these: it is usually some kind of application or audit log; it’s generally one of the largest tables in your schema; and after a while there will probably be a requirement to purge the oldest entries from it.

The IIUG 2012 Conference Planning Committee announced today that registration is open and the conference website is live.

At the recent Avnet Informix Community Event, Jon Ritson did an excellent presentation about hot topics including performance tuning. Many of the tips were not new but one that got me thinking was his suggestion that TCP poll threads should run on a network virtual processor (VP) rather than a CPU one. This seemed to go against previous advice I’ve read elsewhere.

The openadmin tool (aka OAT) is now available with the CSDK product and bundled with 11.70.xC4.  While the product is not installed by default you can choose the custom installer and select the OpenAdmin Tool to be installed.  OAT is available on windows 32 bit, linux 32 & 64 bit and on the mac.  This also means that IBM will officially accept support calls on OAT.  For more information please see OAT’s  http://www.openadmintool.org