SMI Query Series - Logical Log Space Used

The sysmaster interface (SMI) presents a comfortable way to extract information about various parts of your running IDS instance. This information can be used for:

• ad hoc analysis of performance problems
• determining the status of several IDS sub components
• monitoring replication metrics
• sampling data for capacity planning purposes

Haste makes Waste - Stored Procedure Recompilation

During the study of the release notes of the new IDS 10.00.FC8 version I noticed a long anticipated feature that already made it into IDS 10.00.FC7:

Enhanced Concurrency after Recompilation of SPL Routines

The problem of locked rows in the dictionary table sysprocplan is something that comes up in many IDS installations that work intensively with stored procedures. The recommendation to reoptimize the stored procedures manually after DDL changes - update statistics for procedure - helps to avoid the problem but is more a kind of a workaround and is often forgotten by the administrator or application developer.

SMI Query Series - Shared Memory Segments

The sysmaster interface (SMI) presents a comfortable way to extract information about various parts of your running IDS instance. This information can be used for:

• ad hoc analysis of performance problems
• determining the status of several IDS sub components
• monitoring replication metrics
• sampling data for capacity planning purposes

The DB2 Magazine is history

You may already read it in Guy's blog. The DB2 Magazine is now history and has been renamed to:

• Senior Editor Kim Moutsos: DB2 Magazine is now IBM Database Magazine

IDS V11 Certification

Some kind of "house advertising":

There is a new article written by me and published in the DB2 Magazine that talks about IDS V11 Certification:

• Becoming a Certified Informix Professional

Upcoming Informix Books

A new (german) Informix book is going to hit the road in June 2008. It will be published as part of the popular schnell+kompakt (fast+compact) series by entwickler.press.

SMI Query Series - Database Size

The sysmaster interface (SMI) presents a comfortable way to extract information about various parts of your running IDS instance. This information can be used for:

• ad hoc analysis of performance problems
• determining the status of several IDS sub components
• monitoring replication metrics
• sampling data for capacity planning purposes

SMI Query Series - Sequential Scans on Tables

The sysmaster interface (SMI) presents a comfortable way to extract information about various parts of your running IDS instance. This information can be used for:

• ad hoc analysis of performance problems
• determining the status of several IDS sub components
• monitoring replication metrics
• sampling data for capacity planning purposes

MACH 11 - Setup a SDS Node in 5 Minutes

If you didn't had the time to play with the SDS (Shared Disk Secondary) functionality which is part of the MACH 11 technology introduced in IDS 11, here is a short summary how to setup a SDS node on the same machine. It will take you only about 5 minutes to get the SDS node up and running.

I assume that you already have an IDS 11 instance running on your machine. If not, download the cost-free IDS Developer Edition:

Daily Backup via DB Scheduler

Applications that embed the database as part of their solution have challenging requirements regarding the data server:

• a customizable, small footprint
• a hardware gentle architecture
• rock-solid reliability
• flexible high availability options
• extremely low administration overhead
• smoothly backward application compatibility
• excellent performance

If you look at each of those requirements it becomes clear why IBM favors IDS as the data server of choice for integrated solutions. The new database scheduler introduced in IDS V11 offers extensive possibilities to automate routine tasks. Probably one of the most important DBA routine tasks is the regular backup of the data server.