Client Special Registers Are Special
February 2, 2019
Client special registers are very useful for understanding who requested work for database server jobs (QZDASOINIT, QSQSRVR, and QRWTSRVR)
ArticlesRetrieving the Current SQL Statement for a Job
January 17, 2019
IBM i makes it relatively easy to identify and review jobs that may be using a lot of CPU or driving a lot of I/O
ArticlesPrestart Jobs and Connection Pooling
January 5, 2019
Connection pooling is most often used for database connections to the QZDASOINIT or QZDASSINIT (secure server) jobs. It can also be used for other prestart server jobs
ArticlesPrestart Job Messages
January 4, 2019
This article reviews the messages sent by various types of prestart jobs and provide examples of how to gather useful information from these messages
ArticlesInvestigate Prestart Jobs
December 6, 2018
Collection Services is always running on your system and you can use the Performance Data Investigator with Collection Services data for insights into your prestart jobs
Access Client Solutions Enhancements (November 2018)
November 27, 2018
IBM recently released an updated version of Access Client Solutions (ACS).
ArticlesPrestart Jobs and QPRTJOBs
November 16, 2018
What happens when you generate a spooled file from a prestart job? Where does the output go and is there an easy way to find it?
ArticlesWatches and Job Log Messages
November 5, 2018
Watches make life easier if you need to track down an intermittent error or a difficult-to-find issue in a prestart job
ArticlesThe QDFTSVR Job Description
October 25, 2018
QDFTSVR parameter settings provided by IBM with a description of why these settings are selected for prestart jobs
ArticlesManaging Prestart Server Jobs by Remote IP Address
October 3, 2018
There may be times you want to find prestart jobs associated with a remote IP address. In this case, you will want to use one of the various Netstat interfaces