Guru Tech Tips Archives - Dawn May Consulting

Configure Collection Services

by Dawn May | Mar 8, 2019

This article reviews key configuration changes you should make to Collection Services.

Health Indicators

by Dawn May | Mar 8, 2019

This article reviews the Health Indicators, which are part of the Performance tasks in Navigator for i.

Find the Needle in the Haystack with Watches

by Dawn May | Mar 8, 2019

This article explains how to use watches to be notified when elusive messages are sent to job logs.

From the i Can Blog

IBM i Job Accounting and Prestart Server Jobs

March 7, 2019

Job accounting can be used to track the use of system resources, such as CPU time, transactions, printed output, and more, to a particular user or groups of users. read more »

QSQSRVR Job Considerations

February 20, 2019

The QSQSRVR jobs handle database requests for jobs with SQL Server Mode enabled. With SQL Server Mode, the SQL statements are not run directly in the requesting job, but rather by a QSQSRVR prestart s … read more »

Client Special Registers are Special

February 12, 2019

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

February 1, 2019

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

January 21, 2019

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 »