Dawn May

Dawn May




Bookmark and Share
RSS

Recent Posts

  • Client Special Registers are Special
    February 12, 2019
  • The Mysterious QP0ZSPWP Jobs
    February 1, 2019
  • Retrieving the Current SQL Statement for a Job
    January 21, 2019
  • Prestart Jobs and Connection Pooling
    January 10, 2019
  • Prestart Job Messages
    January 4, 2019
  • 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 requested work for the database server jobs (QZDASOINIT, QSQSRVR, and QRWTSRVR).

    Read More

    Posted: February 12, 2019 |

    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

    Posted: February 1, 2019 |

    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…” Another common scenario I hear is “We have users that run ad-hoc queries…”

    Read More

    Posted: January 21, 2019 |

    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 connection for each request. Connection pooling improves performance by reducing the number of jobs started and ended, as well as reducing the overhead of full opens and program activations.   

    Read More

    Posted: January 10, 2019 |

    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 information from these messages.

    Read More

    Posted: January 4, 2019 |

    Investigate Prestart Jobs

    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.

    Read More

    Posted: December 6, 2018 |

    Access Client Solutions Enhancements (November 2018)

    IBM recently released an updated version of  Access Client Solutions (ACS). There is a long list of enhancements in this update; at the end of this article you will find the list of the enhancements from the ReadMeSPACS.txt file. The number of Request for Enhancement (RFEs) addressed in this update is impressive. The ACS development team is clearly listening to what users are asking for.

    Read More

    Posted: November 27, 2018 |

    Prestart Jobs and QPRTJOBs

    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?

    Read More

    Posted: November 16, 2018 |

    Watches and Job Log Messages

    Trying to track down a message sent to the job log of a prestart job is much like looking for a needle in a haystack; on busy systems, there could be hundreds of jobs to look through. If the error was relatively minor, the jobs may end and not generate a job log.

    Read More

    Posted: November 5, 2018 |

    The QDFTSVR Job Description

    Many prestart server jobs on IBM i use the default server job description (QGPL/QDFTSVR) provided with the operating system. Several of host servers use the QSYS/QZBSJOBD job description, but that job description has the same default parameter settings as the QDFTSVR job description.  These job descriptions are defined for optimal performance for prestart jobs.

    Read More

    Posted: October 25, 2018 |

    Displaying results 1-10 (of 366)
     |<  < 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|