Client Special Registers are Special
An early iCan blog, written by Scott Forstie in October 2009, reviewed Client Special Registers.  I’m revisiting this topic since client special registers are very useful for understanding who request … read more »

The Mysterious QP0ZSPWP Jobs
This week I’ll take a look at the QP0ZSPWP jobs. You’ve probably seen evidence of them and may have wondered what they do.  These jobs are created by spawn() and fork() functions.  read more »

Retrieving the Current SQL Statement for a Job
I often get asked how to determine what’s running in a prestart job that is taking a lot of system resources. When I ask for more details, the answer often starts with “We have these QZDASOINIT jobs…” … read more »

Prestart Jobs and Connection Pooling
Connection Pooling is the ability to keep a connection to the server in place.  Connections in the pool can be reused by the same application, avoiding overhead associated with creating a new connecti … read more »

Prestart Job Messages
Many prestart jobs log messages to both the job log and the history log. This article will review the messages sent by various types of prestart jobs and provide examples of how to gather useful infor … read more »